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

Document created by RSA Customer Support Employee on Sep 19, 2017•Last modified by RSA Customer Support Employee on Apr 9, 2020
Version 2Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000029641
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle 
RSA Version/Condition: 6.9.x, 7.0.x
 
IssueThe 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 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:
 
User-added image
 


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, 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

Install the jTDS JDBC driver (jar file)



NOTE: The steps below should be executed as the afx user. The example below assumes the afx user is the oracle user.

  1. Obtain the required driver jar file from the jTDS website. Note that jTDS 1.2.x is compatible with Java 6 and jTDS 1.3.x is compatible with Java 7 and 8. To determine which version of java you are using run the following command as the oracle user:


which java




  1. Transfer the jar file to the AFX server and install it in the appropriate location.

  • For versions 7.x install the file in $AFX_HOME/esb/lib/user/<jTDS driver>
  • For versions 6.9.1 and earlier install the file in $AFX_HOME/mule/lib/user/<jTDS driver>

  1. Set the ownership and permissions:


cd $AFX_HOME/esb/lib/user
chgrp oinstall jtds-1.2.5.jar
chown oracle jtds-1.2.5.jar
chmod 740 jtds-1.2.5.jar


  1. Restart AFX:


afx stop
afx start

 

Create a Generic Database Connector that uses the jTDS driver



  1. In the user interface go to AFX > Connectors > Create Connector > General tab
  2. Under the Connector Template drop-down select the Generic Database type:

User-added image



  1. Select the Settings tab
  2. Under the Database Driver drop-down, select the jTDS driver and enter a JDBC URL:

User-added image



  1. Test the connector to confirm the issue is resolved. 

 
NotesThis 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.
 

Attachments

    Outcomes