Mysql connection

[yawmbox]

hi all.
i've googled many hours before decide to ask your help, but i didn't find any solution for my trouble. :BangHead: :BangHead: :BangHead:

i've to create the android-client version of a server/client application. this application store all data into a mysql database with a lot of tables/records and a discrete traffic from server and more clients.
i've tried the json solution for connecting the android clients to the database but it's very slow for that use.

anyone know any other way to connect an android clients to the mysql database directly or in a very fast mode?

 

[agraham]

i not have the xml file for the thirdparty.jar.

If you actually read it that link tells you how to make an xml file for the jar!

 

[yawmbox]

If you actually read it that link tells you how to make an xml file for the jar!

i already did what you say but didn't work.
if i create a b4a project with only my jar imported and after import the object folder in an eclipse project that have in the build path the thirdparty.jar all works.
if i create a b4a project with my jar and thirdparty.jar/admob.xml (renamed in thirdparty.xml) after the compilation, at runtime, the device says me:

Spiacenti
Interruzione imprevista dell'applicazione MyApp
(processo com.mycompany.myapp).
Riprova.

English:
Sorry
Unexpected application termination MyApp
(process com.mycompany.myapp).
Try again.

 

[agraham]

Look in the unfiltered logs to see what the problem might be. Does Thirdparty appear in the Libs tab? If not there's a problem, if so have you selected it?

 

[yawmbox]

Starting activity: Intent { act=android.intent.action.MAIN flg=0x10000000 cmp=com.mycompany.myapp/.main }
Start proc com.mycompany.myapp for activity com.mycompany.myapp/.main: pid=1053 uid=10028 gids={3003}
** Activity (main) Create, isFirst = true **
Total arena pages for JIT: 2
Exception Ljava/lang/RuntimeException; thrown during Lcom/mysql/jdbc/Messages;.<clinit>
Exception Ljava/lang/ExceptionInInitializerError; thrown during Lcom/mysql/jdbc/Util;.<clinit>
Shutting down VM
threadid=3: thread exiting with uncaught exception (group=0x4001b168)
Uncaught handler: thread main exiting due to uncaught exception
java.lang.ExceptionInInitializerError
   at com.mysql.jdbc.NonRegisteringDriver.parseURL(NonRegisteringDriver.java:673)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:279)
   at java.sql.DriverManager.getConnection(DriverManager.java:191)
   at java.sql.DriverManager.getConnection(DriverManager.java:226)
   at sqlmy.mysqlhandler.Initialize(mysqlhandler.java:34)
   at com.mycompany.myapp.main._activity_create(main.java:214)
   at java.lang.reflect.Method.invokeNative(Native Method)
   at java.lang.reflect.Method.invoke(Method.java:521)
   at anywheresoftware.b4a.BA.raiseEvent2(BA.java:105)
   at com.mycompany.myapp.main.afterFirstLayout(main.java:84)
   at com.mycompany.myapp.main.access$100(main.java:16)
   at com.mycompany.myapp.main$WaitForLayout.run(main.java:72)
   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:4363)
   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:860)
   at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
   at dalvik.system.NativeStart.main(Native Method)
Caused by: java.lang.ExceptionInInitializerError
   at com.mysql.jdbc.Util.stackTraceToString(Util.java:350)
   at com.mysql.jdbc.Util.<clinit>(Util.java:115)
   ... 21 more
Caused by: java.lang.RuntimeException: Can't load resource bundle due to underlying exception java.util.MissingResourceException: Can't find resource for bundle com.mysql.jdbc.LocalizedErrorMessages, key it_IT
   at com.mysql.jdbc.Messages.<clinit>(Messages.java:60)
   ... 23 more
Caused by: java.util.MissingResourceException: Can't find resource for bundle com.mysql.jdbc.LocalizedErrorMessages, key it_IT
   at java.util.ResourceBundle.getBundleImpl(ResourceBundle.java:245)
   at java.util.ResourceBundle.getBundle(ResourceBundle.java:134)
   at com.mysql.jdbc.Messages.<clinit>(Messages.java:58)
   ... 23 more
Sending signal. PID: 1053 SIG: 3
threadid=7: reacting to signal 3

 

[mimmofg]

Italiano:
salve,
è possibile provare questa libreria per collegare direttamente a Mysql?
saluti.

Englesh:
this library you can try to connect directly to MySQL?

 

[hasanaydin52]

MySQL Library

Hello yawmbox,

I added MySQL Library.
I wrote looking at your java code.
MYSQL Library
​

 

[avacondios]

Dear all,

In a few days, I will present a new MYSQL Library which it will cover the most of the known Microsoft ADO commands and functionality. The library will have the following classes: ADOConnection, ADOCommand, ADORecordset. I am still in progress of that and if anyone wants to help on that, please to come in contact with me.