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

[DonManfred]

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]

@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]

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

hmmm...

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

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

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]

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)

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

 

[DonManfred]

There is also a first version of PreparedStatements available in 0.36

for ex.

    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

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

but this is untested too actually...

 

[hotspring]

Sorry I registered Your lib under gschindler@gmx.at

 

[DonManfred]

Ahh. Ok. Thanx

 

[BarryW]

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]

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]

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]

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

 

[DonManfred]

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]

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

 

[DonManfred]

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

 

[benji]

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

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

and i try this in a button

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]

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]

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

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

Then read the response in.

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

 

[benji]

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]

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

 

[benji]

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...