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

vbmundo

Well-Known Member
Licensed User
if you are using my lib you ARE using the connector. It is the big jar in your additional libs folder.
My lib is just a wrapper to use this connector in b4a
I understand, then I can Edit this JAR and make the changes..

I need Eclipse or some other editor or soft to edit this JAR ?

How can I modify the Source code ?
 

keirS

Well-Known Member
Licensed User
Longtime User
I understand, then I can Edit this JAR and make the changes..

I need Eclipse or some other editor or soft to edit this JAR ?

How can I modify the Source code ?

You don't need the source code. You append it to the DB name so your database parameter becomes "MyDBName?zeroDateTimeBehaviour= convertToNull'
 

vbmundo

Well-Known Member
Licensed User
You don't need the source code. You append it to the DB name so your database parameter becomes "MyDBName?zeroDateTimeBehaviour= convertToNull'

Hi Friend,

This doesn't work

In DataBase parameter, only works the real Database name...

I receive this error

B4X:
AUTO RECONNECT: Unable to re-establish database connection, please try agian later.

B4X:
SqlException: java.sql.SQLException: No database selected
 

vbmundo

Well-Known Member
Licensed User
Yes, now work the connection... don't throw error..

But the Tables that have "0000-00-00" in Date Field doesn't work.

the query does not return or only 1 record and curious .. is not fails

Please,

I sent to you my Credentials in Private..

Can you try to run "SELECT * FROM videos" ?

This can take only 1 minute for you..

Regards
 

keirS

Well-Known Member
Licensed User
Longtime User


Sorry it should be "?zeroDateTimeBehavior=convertToNull". I am British so spell Behaviour the correct way

The complete JDBC URL should look like "jdbc:mysql://localhost:3306/mydb?zeroDateTimeBehavior=convertToNull" so DonManfred should be able to advise you where to put it.
 

DonManfred

Expert
Licensed User
Longtime User
DonManfred should be able to advise you where to put it.
Add the ?zeroDateTimeBehavior=convertToNull to the HOST parameter.

Before:
Host = somedomain.net:3301
After = somedomain.net:3301?zeroDateTimeBehavior=convertToNull

or for the default port 3306

Host = somedomain.net
After = somedomain.net?zeroDateTimeBehavior=convertToNull

I GUESS-never tried it
 

vbmundo

Well-Known Member
Licensed User

Thanks KeirS !!!
 

vbmundo

Well-Known Member
Licensed User

Thank Don !! I will try
 

rkxo

Active Member
Licensed User
Longtime User

rkxo New Member Licensed User
New hi ,
Could someone give an example of load audio file the setPreapredBlob or setPreapredBlob2 method

i try this but don't work
qry = "INSERT INTO audionotes SET id_av=?, status=?, data=?;"
SQL1.PeparedStatement(qry)
SQL1.SetPeparedString(1,tr)
SQL1.SetPeparedString(2,"1")
SQL1.setPreapredBlob(3,File.DirDefaultExternal&"/temp.mp3")
SQL1.ExecutePeparedStatement("")

thanks.
 

samperizal

Active Member
Licensed User
Longtime User
Regards
You can capture the error that occurs if for example the key is wrong or the server is not correct, .....


Code
db.Initialize ("MySQL" Edit_Servidor.Text.trim (), Edit_Usuario.Text.trim (), Edit_Clave.Text.Trim (), Edit_Datos.Text.Trim (), True, False)
db.CloseDatabase

Thank you
 

vbmundo

Well-Known Member
Licensed User
Hi DonManfred

When you try to INITIALIZE with Wrong info, your library hold.

NO ERROR, simply hang the app.

My Testers report to me this error.. and when I go to try I see that your INITIALIZE stattement hang when you set wrong info.

PD : All my Testers said to me that your Lib is the holy Grial, because is faster than others

Regards
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…