Skip to Content
0
Jun 28 at 05:58 PM

MySQL Connection in SLD, B1IF

53 Views

Hello,

I am trying to connect to a MySQL database in the SLD, B1IF v1. Current attempt uses J.AnySystem, using:

Driver: com.mysql.jdbc.Driver

URL: jdbc:mysql://mysqlIP:3306/db_name

I have added the mysql-connector-java-8.0.7-dmr-bin.jar file to:

C:\Program Files (x86)\sap\SAP Business One Integration\IntegrationServer\Tomcat\webapps\B1iXcellerator\WEB-INF\lib

The response I am getting is:

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.

This connection also requires SSL, and I don't know where/how to add the .pem files. Any guidance or assistance would be greatly appreciated.

Thanks.