B4J Question MySql Connector not working when compiled with B4JPackager11

[Elby dev]

Hi I need some help with my B4J Program which connects to a MySql database on a LAN Network. The Program works fine in Debug mode and Release mode.
But when Compiled with the standalone packager 11 it compiles ok but running it it show the following error:
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at b4j/com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(Unknown Source)
at b4j/com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(Unknown Source) (many more lines all the same 'Unknown S
I believe I need add some inclusions? But am not sure where to put this in the program. Hope somebody knows the answer please.
Thanks

 

[Erel]

Are you using a ssl connection?

If so, try to add this line:

#PackagerProperty: IncludedModules = jdk.crypto.ec

 

[Elby dev]

Hi Erel, I checked the MySQL server which is on the other end of a vpn 25 km away and yes Authentication is set at 'caching_sha2_password'
so I added the above suggested property line and YES the compiled standalone package is now working Perfectly. Thanks Heaps
Ps Do you have a donation tin there? You have saved me one big headache tonight! Thanks Elbert

 

[Erel]

Do you have a donation tin there?

Learn Cross Platform App Development IoT, Desktop & Server | B4J

B4J is a 100% free programming tool, similar to B4A that generates desktop, server and web applications.

www.b4x.com