Android Question SD_SQL won't connect to database server with compilation set to release but does under debug

jimseng · Sunday at 11:19 PM

Without fail I can run my app in debug mode and can connect to my mariadb server when using debug, but when I try to use release it fails and the log shows:
Not connected: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
This is over a 5g mobile connection and port 3306 is routed through to the mariadb server by a port forward on the router.
Any ideas what the issue is?

jimseng · Sunday at 11:43 PM

Ok. I have found a thread that discusses this. I'll try and follow it and see where I get to. Unless anyone has anything that say that might get me sorted quicker. I have only tried this SD_SQL for a day and I am still much in the dark over it.

jimseng · Monday at 9:18 AM

Ok. So no luck.
I have followed this thread: https://www.b4x.com/android/forum/t...to-connect-to-mysql-server-ver-8-0-30.143055/ and tried Erel's suggestion of DisableStrictMode, downloaded mysql-connector-java-8.0.28.jar and changed to #AdditionalJar: mysql-connector-java-8.0.28
That is about as far as the thread and my skill set take me. Can anyone help me from here?

jimseng · Monday at 9:44 PM

So I think I can get this to work if the mysql connection is in Main and the

B4X:

MYSQL.Initialize(Me,"MYSQL")

is in Main. When I do it from a B4XPages module that seems to make it fail in release mode.. I have no idea why. Someone might have a clue.

Android Question SD_SQL won't connect to database server with compilation set to release but does under debug

jimseng

Active Member

jimseng

Active Member

jimseng

Active Member

jimseng

Active Member

Similar Threads

Android Question SD_SQL won't connect to database server with compilation set to release but does under debug

jimseng

Active Member

jimseng

Active Member

jimseng

Active Member

jimseng

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency