SQL Collector fails with Java version 1.6 incompatibility error
3 years ago
Originally Published: 2015-01-21
Article Number
000046910
Applies To
RSA Product Set: Identity Management and Governance
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 6.9
Platform: WebSphere
Platform (Other): null
O/S Version: N/A
Product Name: RSA-0018035-RH
Product Description: IMG R620 Appliance (ACM & AFX)
Issue
SQL collection fails with the error:

UnsupportedOperationException: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
Cause
RSA IAM Platform currently ships with the Microsoft JDBC Driver for SQL Server (sqljdbc.jar). This version of the jar supports Java JDK/JRE 5.0. This will throw an exception when using JRE 6.0.
Resolution
 If you are using an Application Server that uses JRE 6.0, WebSphere 7 for example, you must replace the version of sqljdbc.jar file found in our deployed EAR:  aveksa.ear/aveksa.war/WEB-INF/LocalAgent/common/lib/sqljdbc.jar

Obtain sqljdbc4.jar, which supports JRE 6.0, and then replace sqljdbc.jar with sqljdbc4.jar.