Cannot connect to Registry with MySQL when ?useSSL=true

Document ID : KB000103032
Last Modified Date : 21/06/2018
Show Technical Document Details
Issue:
Our DBA team required the use of of ssl for the database connection.

After setting the properties I am getting an error on the registry. lisadb.pool.common.driverClass=com.mysql.jdbc.Driver lisadb.pool.common.url=jdbc:mysql://devdbv0202:3306/qmeca_db?useSSL=true

Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!
Cause:
MySQL was not configured to use SSL.
Resolution:
Your MySQL must be configured to use this option on the JDBL URLĀ 

?useSSL=true

So until MySQL is configured on the Database to use SSL you must leave off this option.