Apparently wrong driver class specified for URL

Products

• CA Virtual Privilege Manager
• CA Privileged Identity Management Endpoint (PIM)
• CA Privileged Access Manager (PAM)

Issue/Introduction

When trying to use JDBC password consumer for a jboss application gets the following in server.log: 

2016-05-13 01:19:46,261 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/Test_Jboss].[jsp]] Servlet.service() for servlet jsp threw exception org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.ca.ppm.clients.jdbc.CAJDBCDriver, url: jdbc:sqlserver://<server>:<port>;DatabaseName=<database>

Also gets message when SQL Server driver is used directly: 

2016-05-16 11:31:55,294 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/Test_Jboss].[jsp]] Servlet.service() for servlet jsp threw exception org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.microsoft.sqlserver.jdbc.SQLServerDriver, url: jdbc:sqlserver://<server>:<port>;DatabaseName=<database>

Environment

12.9-Privileged Identity Manager

Cause

 

sqljdbc.jar Requires a Java Runtime Environment (JRE) of version 5.0. Using JRE 6.0 or higher will throw an exception when connecting to a database. 

Note: "Using JRE 6.0 or higher will throw an exception when connecting to a database" 

The SQL Server jdbc driver is throwing an exception, and the cajdbc driver is acting on this exception and re-throwing it.

Resolution

Customer needs to use the correct jdbc driver for the version of java they are using. 

 

Additional Information

System requirements for the JDBC driver

https://techcommunity.microsoft.com/t5/sql-server-support-blog/jdbc-this-driver-is-not-configured-for-integrated-authentication/ba-p/318491