How to install the jTDS JDBC driver on WildFly for use with Data Collections in RSA Identity Governance & Lifecycle

RSA Product Set: RSA Identity Governance & Lifecycle 
RSA Version/Condition: 7.0.x, 7.1.x, 7.2.x
Platform/Application Server: WildFly
 

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.  

This RSA Knowledge Base Article explains the steps to installing the jTDS driver on an RSA Identity Governance & Lifecycle 7.x WildFly appliance. In the case of a clustered configuration, the steps, at a high level, are the same, the difference being the .ear file needs to be deployed on each node of the cluster. Steps to do this are documented in the RSA Identity Governance and Lifecycle Installation Guide for your version.
 

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. 

 

 

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.

Please note that installing the jTDS JDBC driver is an example. You may use this approach for including any custom/external JDBC driver.

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

To install the jTDS 1.2.x driver on RSA Identity Governance & Lifecycle versions 6.9.1 and below, Place the new driver in the lib folder and remove the existing driver. Execute 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