Hi,
My client is facing issue with oracle jdbc driver (ojdbc7.jar client). CA API Gateway (9.2) is throwing error "Unsupported driver class "oracle.jdbc.driver.OracleDriver".
I tried importing the jar (ojdbc7.jar) and followed instruction as mentioned in "https://docops.ca.com/ca-api-gateway/9-1/en/configure-security/tasks-menu-security-options/manage-jdbc-connections/install-the-jdbc-interface".
After following all the steps I tried testing the connection with jdbc driver class as "oracle.jdbc.driver.OracleDriver" and connection url as "jdbc:oracle:thin:@<host name>:port:<DatabaseName>".
It is throwing error: Testing Failed: JDBC URL resolved to unsupported JDBC driver class "oracle.jdbc.driver.OracleDriver" .
Please advise.
Rudra Singh
Rudra,
I've been able to duplicate the issue in our lab. I found that by downloading the driver from Oracle Database 12c Release 1 JDBC Driver Downloads and following the steps outline in the documentation that I received the error "com.l7tech.server.jdbc.JdbcConnectionPoolManager: Cannot configure a pool associated with a JDBC connection Comm due to: JDBC URL resolved to unsupported JDBC Driver class oracle.jdbc.OracleDriver". I noted that the driver class was not aligning to oracle.jdbc.driver.OracleDriver but to oracle.jdbc.OracleDriver. Once I changed all the values to "oracle.jdbc.OracleDriver" and it worked.
Sincerely,
Stephen Hughes
Director, CA Support