Data Collections and AFX Connectors from/to SQL Server endpoints fail when using the jTDS driver in RSA Identity Governance & Lifecycle

Header

Title	Data Collections and AFX Connectors from/to SQL Server endpoints fail when using the jTDS driver in RSA Identity Governance & Lifecycle

URL Name	Data-Collections-and-AFX-Connectors-from-to-SQL-Server-endpoints-fail-when-using-the-jTDS-driver-in-RSA-Identity-Governance-Lifecycle

Summary	Data Collections and AFX Connectors from/to SQL Server endpoints fail when using the jTDS driver in RSA Identity Governance & Lifecycle.

Validation Status	Technically Approved

Age	3,289.16

Article Content

Translate To

Applies To

RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 6.x, 7.0.x

Issue

Data collections that collect from SQL Server endpoints and AFX connectors that provision to SQL Server endpoints fail in RSA Identity Governance & Lifecycle when using the jTDS JDBC driver.

SYMPTOMS:

Data Collection

When a SQL Server data collection fails, a test of the same collector fails with the following error in the user interface:

Collector test failed:

com.aveksa.server.runtime.ServerException: Test request failed with response: com.aveksa.server.runtime.ServerException: com.aveksa.sdk.collector.CollectionException: com.aveksa.common.DataReadException: ERROR: Could not get accounts data: . Caused by com.aveksa.common.DataReadException: ERROR: Could not get accounts data: . Caused by java.sql.SQLException: No suitable driver found for jdbc:sqlserver://node,domain.com:1433;databaseName=somedatabase

AFX Connector

When a SQL Server AFX connector fails, the mule_ee.log file ($AFX_HOME/esb/logs/mule_ee.log) has the following error:

Exception followed by:
Caused by: java.lang.UnsupportedClassVersionError: net/sourceforge/jtds/jdbc/Driver : 
Unsupported major.minor version 51.0

Cause

These error messages indicate an incompatibility between the jTDS JDBC driver and the version of Java being used by RSA Identity Governance & Lifecycle.

For example, the jTDS 1.3.1 driver is compatible with Java 6 but not Java 7.

Resolution

For RSA Identity Governance & Lifecycle versions 7.x which use Java 7+, install the jTDS 1.3.x driver.

To install the jTDS driver for use with data collections, see RSA Knowledge Base Article 000034189 -- How to install the jTDS JDBC driver on WildFly for use with Data Collections in RSA Identity Governance & Lifecycle.

To install the jTDS driver for use with AFX, see RSA Knowledge Base Article 000029641 -- How to install the jTDS JDBC driver for use with AFX in RSA Identity Governance & Lifecycle.

For RSA Identity Governance & Lifecycle versions 6.9.1 and below which use Java 6, install the jTDS 1.2.x driver.

Place the new driver in the lib folder and remove the existing driver. Run these commands as the oracle user.

cp <jTDS 1.2.x driver> $AVEKSA_HOME/jboss-4.2.2.GA/server/default/lib/<jTDS 1.2.x driver>
rm <existing SQL Server driver>
afx stop
acm restart
afx start

Workaround

Notes

This is a legacy Knowledge Base Article and only applies to the listed versions which are no longer actively supported.
RSA does not recommend the continued use of the public domain JTDS driver on current versions of the product.  RSA recommends customers use the JDBC driver specific for their database.

Legacy Article ID 000030143

Article Settings

Audience	External

Article Source	Case

Original Article Author	Regina Rohr-Haase

Original Created Date	4/29/2015 4:37 PM

Owner	Regina Rohr-Haase

Article Assignment

Assigned To

Assigned By

Assignment Note

Assignment Due Date

Article Properties

Publication Status	Published

Article Type	Knowledge

Article Number	000055996

Created By	Regina Rohr-Haase

Last Modified By	Katrina Nash

Language	English