How to install the jTDS JDBC driver for use with AFX in RSA Identity Governance & Lifecycle

[#1]

Article Number

000062908

Applies To

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

Issue

The jTDS JDBC driver is a third-party JDBC driver that can be used in place of the default JDBC driver for connections to SQL databases. Specifically, this driver is often used for connections to the Microsoft SQL server if Windows authentication is required to establish the connection (as this is not supported by the native driver). Due to licensing restrictions, RSA is unable to provide the jTDS driver with the product but it can be sourced from the internet.  

There is no specific AFX connector for jTDS, but the driver may be specified manually as an option when using the generic SQL driver. With traditional connectors, any dependent .jar files are uploaded automatically through the connector interface but for the jTDS driver, the required driver files must be installed manually. If this is not done, the following exception will be thrown:
 

Image description
 

Connection error: Error trying to load driver: net.sourceforge.jtds.jdbc.Driver :
net.sourceforge.jtds.jdbc.Driver (java.sql.SQLException)
org.mule.transport.ConnectException: Error trying to load driver: net.sourceforge.jtds.jdbc.Driver : net.sourceforge.jtds.jdbc.Driver (java.sql.SQLException)
     at org.mule.transport.jdbc.JdbcConnector.getConnection(JdbcConnector.java:280)

The same error is logged in the connector log file, which is located at $AFX_HOME/esb/logs/esb.AFX-SETTINGS-{Database}.log file:
 

2017-09-14 12:09:32.415 [WARN] com.aveksa.AFX.transport.database.DatabaseSettingsTest:104 - 
Error connecting to database for endpoint JTDS
org.mule.transport.ConnectException: Error trying to load driver: net.sourceforge.jtds.jdbc.Driver : 
net.sourceforge.jtds.jdbc.Driver (java.sql.SQLException)
     at org.mule.transport.jdbc.JdbcConnector.getConnection(JdbcConnector.java:280)

 

Resolution

This article is for versions that are no longer supported.

The solution for this article has been marked as Internal Only.

Please open an RSA Customer Support Case and ask for alternative options to use in place of the JTDS driver. 

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.

This RSA Knowledge Base Article covers installing the jTDS driver for use with AFX. To use the jTDS driver for data collections, please 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.