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

DonManfred · Jun 22, 2016

vbmundo said:
I need to know how can I Add this in your lib

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.

vbmundo · Jun 22, 2016

DonManfred said:
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.

But how can I use the j-connector and your lib ? I'm lost there.. I'm new in Java/Basic4Android

DonManfred · Jun 22, 2016

vbmundo said:
But how can I use the j-connector and your lib ?

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

vbmundo · Jun 22, 2016

DonManfred said:
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 · Jun 22, 2016

vbmundo said:
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 · Jun 22, 2016

keirS said:
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.

vbmundo · Jun 27, 2016

keirS said:
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

DonManfred · Jun 27, 2016

My guess is to add it to the HOST as i wrote earlier

vbmundo · Jun 27, 2016

DonManfred said:
My guess is to add it to the HOST as i wrote earlier

Yes, It's true, only works in Host

Thanks !!

vbmundo · Jun 27, 2016

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

vbmundo · Jun 28, 2016

Are any way to finish with this Issues ?

I repeat, DATEs with "0000-00-00" in Default is very usual

Thanks

keirS · Jun 29, 2016

vbmundo said:
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

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 · Jun 29, 2016

keirS said:
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

Luis Carrillo Escalona · Jun 29, 2016

You can access mysql microsoft azure

DonManfred · Jun 29, 2016

Luis Carrillo Escalona said:
You can access mysql microsoft azure

i dont know. Never tried it as i have no Microsoft azure account....

vbmundo · Jun 29, 2016

keirS said:
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 !!!

vbmundo · Jun 29, 2016

DonManfred said:
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

Thank Don !! I will try

rkxo · Jul 9, 2016

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 · Jul 9, 2016

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 · Jul 16, 2016

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

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

Expert

Well-Known Member

Expert

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Expert

Member

Expert

Well-Known Member

Well-Known Member

Active Member

Active Member

Well-Known Member

Privacy & Transparency

Privacy & Transparency