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

[jimseng]

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]

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]

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]

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

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.