It is the documentation of the j-connector. Most probably you´ll find the info there on how to add the parameter you want to add.
-
Welcome to B4X forum!
B4X is a set of simple and powerful cross platform RAD tools:
- B4A (free) - Android development
- B4J (free) - Desktop and Server development
- B4i - iOS development
- B4R (free) - Arduino, ESP8266 and ESP32 development
[chargeable] MSMySQL - Yet another MySQL-Library (but a FAST one :-))
- Thread starter DonManfred
- Start date
- Similar Threads Similar Threads
But how can I use the j-connector and your lib ? I'm lost there.. I'm new in Java/Basic4Android
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 ?
You don't need the source code. You append it to the DB name so your database parameter becomes "MyDBName?zeroDateTimeBehaviour= convertToNull'
Well man.. THANNNNNNNNNNNNNNKS.
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 selectedMy guess is to add it to the HOST as i wrote earlier
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
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
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.
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
You can access mysql microsoft azure
i dont know. Never tried it as i have no Microsoft azure account....
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.
Thanks KeirS !!!
Thank Don !! I will try
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.
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
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
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
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