RSA Access Manager with MSSQL Data Adapter is not compatible with Java Development Kit (JDK) 1.6.0_29

Originally Published: 2016-04-25

Last Modified: 2023-10-06

Article Number

000064099

Applies To

RSA Product Set: Access Manager
RSA Product/Service Type: MSSQL Data Adapter
RSA Version/Condition: 6.2

Issue

Using the MSSQL JDBC jar with JDK 1.6.0_29 breaks the connection from the Aserver and Eserver to the MSSQL database.

The Aserver and Eserver do not throw any exception, but do stop logging at the first attempt to connect to the Aserver/Eserver and never connect. For example:

Starting connection(s) to SQL:
    mssql ... 15:30:41:506 [dal_conn] [main] - Attempting to open connection.
15:30:42:003 [dal_conn] [main] - Attempting to validate ...
15:30:42:003 [dal_conn] [main] -   Executing query: SELECT COUNT(*) FROM WEB_SERVER_TYPE WHERE 1=2

No further connection logging appears after this.

Cause

If the Java Runtime Environment (JRE) is changed from the default version included with Access Manager 6.1 to a standalone version such as Sun Java 1.6.0_29 JDK during an upgrade from Access Manager 6.1 to 6.2, an incompatibility issue can be introduced in JDK 1.6.0_29 where it is not compatible with the MSSQL JDBC driver.

More information can be found in Stack Overflow's article on how the Driver.getConnection hangs using SQLServer driver and Java 1.6.0_29 and on Oracle's discussion forums.

Resolution

The issue can be resolved by upgrading to a later version of JDK.

Notes

In the next version of Access Manager, Java 1.6 will no longer be supported so customers will then need to upgrade to JDK 1.7 or 1.8.

Don't see what you're looking for?

Related Articles

Trending Articles