JDBC error after 10.1 upgrade Error: JDBC URL resolved to unsupported JDBC Driver class com.mysql.cj.jdbc.Driver

Products

• CA API Gateway

Issue/Introduction

We upgraded to 10.1 and since then, we are getting an error in the policy manager when trying to connect to our mySQL database.

Environment

Release : 10.1

Cause

10.1 need to include specific parameter in the system.properties and CWP  jdbcConnection.driverClass.defaultList when adding custom driver 

Resolution

Use custom driver with 10.1

Change ClusterWide Properties (CWP) as follow include cj and ibm

List CWP:  jdbcConnection.driverClass.defaultList

com.mysql.cj.jdbc.Driver

com.mysql.jdbc.Driver

com.l7tech.jdbc.mysql.MySQLDriver

com.l7tech.jdbc.db2.DB2Driver

com.l7tech.jdbc.oracle.OracleDriver

com.l7tech.jdbc.sqlserver.SQLServerDriver

com.ibm.db2.jcc.DB2Driver

Change /opt/SecureSpan/Gateway/node/default/etc/conf/system. Properties to include the following: 

com.l7tech.server.jdbcDriver=com.mysql.cj.jdbc.Driver\ncom.mysql.jdbc.Driver\ncom.l7tech.jdbc.mysql.MySQLDriver\ncom.l7tech.jdbc.db2.DB2Driver\ncom.l7tech.jdbc.oracle.OracleDriver\ncom.l7tech.jdbc.sqlserver.SQLServerDriver\ncom.ibm.db2.jcc.DB2Driver

Restart Gateway