000029641 - How to install the third party jTDS database driver using RSA Identity Governance and Lifecycle Access Fulfillment Express (AFX)

Document created by RSA Customer Support Employee on Sep 19, 2017
Version 1Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000029641
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 6.9.x, 7.0.x
Platform: JBoss
Product Description: Access Fulfillment Express (AFX)
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 domain 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 this driver with the product but it can be sourced from the internet.  
There is no specific Access Fulfillment Express (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 /home/oracle/AFX/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

How to install the jTDS jar file for RSA Identity Governance and Lifecycle Access Fulfillment Express (AFX)


  1. Obtain the required driver jar file jtds-1.2.5.jar from the jTDS website.  At the time of writing the 1.2.5 version of the jar file is known to be compatible.
  2. Transfer the jar file to the AFX server and install it in the appropriate location.
  • For versions 7.0.0 and later, install the file in /home/oracle/AFX/esb/lib/user/jtds-1.2.5.jar.
  • For versions 6.9.1 and earlier install the file in /home/oracle/AFX/mule/lib/user/jtds-1.2.5.jar.
  1. Set the ownership and permissions:

acm-702:/home/oracle/AFX/esb/lib/user # chgrp oinstall jtds-1.2.5.jar
acm-702:/home/oracle/AFX/esb/lib/user # chown oracle jtds-1.2.5.jar
acm-702:/home/oracle/AFX/esb/lib/user # chmod 740 jtds-1.2.5.jar

  1. Stop and start AFX:

acm-702:/home/oracle/AFX/esb/lib/user # afx stop
acm-702:/home/oracle/AFX/esb/lib/user # afx start

 

Define the generic database connector to use the jTDS driver


  1. Press Create Connector under AFX Connectors menu.
  2. Under the Connector Template select the Generic Database type:

 


User-added image


 


  1. 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 article only covers getting the driver to work with AFX. To use the driver with Collectors, contact RSA Customer Support for assistance with article 000034189 (How to install the jTDS JDBC driver on WildFly in a non-clustered RSA Identity Governance and Lifecycle environment.)

Attachments

    Outcomes