[chargeable] MSMySQL - Yet another MySQL-Library (but a FAST one :-))

DonManfred · Feb 9, 2015

I´m sure no one of my users have shared or decompiled the library...

The problem i have is:
- I get a Payment. With this Payment i get a buyer-email and probably a name.
- I have no username here in forum from the buyers.
Some of the buyers i could find from the names, some i recognized through the comments they leave (like you, Jaames)
So i´m trying to figure out this reference for myself.

Peter Simpson · Feb 9, 2015

@hotspring has been a member since 2010 but has only ever posted 2 comments @Jaames, both of which are in this library thread

Anyway, how are you finding this great library? @DonManfred has Don a great job imo...

Jaames · Feb 9, 2015

Peter Simpson said:
@hotspring has been a member since 2010 but has only ever posted 2 comments @Jaames, both of which are in this library thread

hmmm...

Peter Simpson said:
Anyway, how are you finding this great library? @DonManfred has Don a great job imo...

I'll quote myself, I've posted it already

Jaames said:
This is the best and simplest to use MySQL library I came across, Keep up the great work!
Thanks for all of your support. (I even got the lib without paying, until my card is ready to pay. Another thanks for that)

Grate lib and good job Don.

DonManfred · Feb 10, 2015

There is no property inside the lib showing the state (connected) actually.
But there is a new Event raised in actual version (0.36; can be found on my dropbox-shared link)

B4X:

Sub MySQL_Status(Connected As Boolean, ReConnecting As Boolean, RetriesLeft As Int)
    lblStatus.Text = "MySQL_Status("&Connected&","&ReConnecting&","&RetriesLeft&")"
End Sub

DonManfred · Feb 10, 2015

There is also a first version of PreparedStatements available in 0.36

for ex.

B4X:

    db.PeparedStatement("INSERT INTO members Set id=?, member_name=?;")
    db.SetPeparedInt(1,664)
    db.SetPeparedString(2,"Manfred")
    db.ExecutePeparedStatement

The first parameter of the Set-commands is the index where to put the value in.
In this case i have a query with two questionmarks. This is index 1 and 2. The maximum index depends on the amount of questionmarks in the sql.
It is actually untested!

Blobs should work too

B4X:

    db.PeparedStatement("INSERT INTO pictures Set image=?;")
    db.SetPeparedBlob(1,pathtojpg)
    db.ExecutePeparedStatement

but this is untested too actually...

hotspring · Feb 11, 2015

Sorry I registered Your lib under gschindler@gmx.at

DonManfred · Feb 11, 2015

Ahh. Ok. Thanx

BarryW · Feb 15, 2015

I test this library on wifi connection without internet connection and it seems to be slow. Is this library is checking if there is an internet access?

DonManfred · Feb 15, 2015

No. It just send out an query. If this dont work it realized that the connection is lost and try to reconnect.
It does not check for internet.

Peter Simpson · Feb 15, 2015

You should test for a connection to the database first, if you get a response you should then run your main MySQL query @BarryW.

benji · Feb 24, 2015

i was looking for something like this, direct and easy... i want this

DonManfred · Feb 24, 2015

benji said:
i want this

then you should consider to donate for it.
Maybe you already did. i got a registration today but do not have a username...
Will send out reg-mail when i´m at home.

benji · Feb 24, 2015

yes, i'm
i wait for your mail... thanks.

DonManfred · Feb 24, 2015

Send out the registrations mails for todays reggers.
You should have mail now

benji · Feb 25, 2015

i'm lost, i can't connect to mysql. obviusly i have some mistake.
This is my Initialize in Activity Create.

B4X:

DBAvalon.Initialize("MySQL","192.162.1.100","avalontr","*****","avalontr")

and i try this in a button

B4X:

DBAvalon.ExecuteASync("INSERT INTO test SET maquina=60,valor=1000;")

but, nothing happens, even, when the application starts, it's frozen(black screen) by 10 seconds, and then show the activity. i think is try to connect.

MSMySQL jar and xml is in the libraries, and mysql-connector-java-5.1.34-bin too, it's ok?

what is DisableStrictMode? it's necessary?

thanks in advance.

DonManfred · Feb 25, 2015

benji said:
it's necessary?

Usually no because this is integrated into the Library.
Maybe you need to check firewall and Antivirus if they allow connections to port 3306 on this machine (the machine the database is running on).
What does the log output? If there is a reconnect then this should be printed to the logs.

Peter Simpson · Feb 25, 2015

DisableStrictMode is not necessary as this library copes with that issue.
First try something simple like.

B4X:

DBAvalon.QueryASync2("SELECT * FROM `test`")

Then read the response in.

B4X:

Sub MySQL_QueryResult2(data As List, meta As Map)
   
End Sub

benji · Feb 25, 2015

the server is running, and i have access, for example with toad from other PC in the same network.
in the logs, i have nothing

Peter Simpson · Feb 25, 2015

Are you sure that "192.162.1.100" is 100% correct and that you have got your login details 100% correct as well?

benji · Feb 25, 2015

ok, i have connection now, what i do? i don't now... only a clean app only with a button y connection...

i go for test my old connection...

[chargeable] MSMySQL - Yet another MySQL-Library (but a FAST one :-))

Expert

Expert

Active Member

Expert

Expert

New Member

Expert

Active Member

Expert

Expert

Active Member

Expert

Active Member

Expert

Active Member

Expert

Expert

Active Member

Expert

Active Member

Privacy & Transparency

Privacy & Transparency