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

[shashkiranr]

Its a Join SQL Statement involving multiple tables.

 

[shashkiranr]

Hi Don,

I am getting signature error while executing batch async query. The values are getting updated in the table.

java.lang.Exception: Sub mysql_batchresult signature does not match expected signature.

the sub is

Sub MySQL_BatchResult(batch As Map)
    Log(batch)
End Sub

Regards,
SK

 

[DonManfred]

I am getting signature error while executing batch async query.

Download new versions from the download link you got after registration. Should be fixed

 

[adastra]

hi i have your library msmysql is is working in debug mode but does not work in release mode.i do't not why please help

 

[DonManfred]

Did you add internet permission to your manifest?

 

[adastra]

how to add inernet permission to manifest

 

[DonManfred]

AddPermission(android.permission.INTERNET)

 

[adastra]

It is working now. Thank you so much

 

[shashkiranr]

Download new versions from the download link you got after registration. Should be fixed

Same Error. The version im using is 1.06. is this the latest version?

Regards,
SK

 

[DonManfred]

is this the latest version?

yes.

I´ll investigate

 

[samperizal]

greetings

mysql to connect to the following error occurs

:null,0
java.lang.ClassNotFoundException: de$donmanfred$b4a$MySQL
at anywheresoftware.b4a.shell.Shell.getCorrectClassName(Shell.java:544)
at anywheresoftware.b4a.shell.Shell.createObject(Shell.java:516)
at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:320)
at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:238)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:521)
at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:121)
at b4a.example.main.initializeGlobals(main.java:306)
at b4a.example.main.afterFirstLayout(main.java:97)
at b4a.example.main.access$100(main.java:17)
at b4a.example.main$WaitForLayout.run(main.java:78)
at android.os.Handler.handleCallback(Handler.java:587)
at android.os.Handler.dispatchMessage(Handler.java:92)
at android.os.Looper.loop(Looper.java:123)
at android.app.ActivityThread.main(ActivityThread.java:4627)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:521)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
at dalvik.system.NativeStart.main(Native Method)

ver lib is MSMYSQL 0.36

As I fix


Thank You

 

[shashkiranr]

Hi Don,

When there is slow internet connection, the db initialization does not happen fast and blocks the main thread. Even when I put the initialization in a service module to run in background it still blocks the main UI thread. Is there a way in which I can initialize the db in the background ?

Regards,
SK

 

[jahswant]

If your internet speed is slow you won't enjoy this lib

 

[Mashiane]

Hi, whats the purpose of "DisableStrictMode" method in your example code?

 

[DonManfred]

The main connection is handled in the mainthread from the library. As of this the strigtmode is used

 

[Mashiane]

Hi, what kind of problems will I perhaps encounter if I follow the DbUtils approach in using these libraries? Will it accept ? as parameters in my queries just like SQLite?

 

[DonManfred]

No, it will not work with dbutils or any other known db method.

The library is giving the results as a map (or a list of maps) or in a csv similar format.

 

[Mashiane]

Hi,

I'm getting a "Sub NOT FOUND: 'mysql_status" , how to solve this? I'm using msmysql, can you please advise?

 

[DonManfred]

Sub MySQL_Status(Connected As Boolean, ReConnecting As Boolean, RetriesLeft As Int)
    log("MySQL_Status("&Connected&","&ReConnecting&","&RetriesLeft&")")
End Sub

 

[Mashiane]

Hi Don

Is there a way to determine if your last insert / delete / update statement was successful? eg returning a Boolean value somewhere by the lib or return Affected Rows for example.