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

Its a Join SQL Statement involving multiple tables.

Hi Don,

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


the sub is

Regards,
SK

shashkiranr said:

I am getting signature error while executing batch async query.

Click to expand...

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

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

Did you add internet permission to your manifest?

how to add inernet permission to manifest

It is working now. Thank you so much

DonManfred said:

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

Click to expand...

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

Regards,
SK

shashkiranr said:

is this the latest version?

Click to expand...

yes.

I´ll investigate

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

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

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

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

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

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?

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.

Hi,

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

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.