Article Content
Article Number | 000029641 |
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 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: 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:
|
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.
See RSA Knowledge Base Article 000030143 -- Data Collections and AFX Connectors from/to SQL Server endpoints fail when using the jTDS driver in RSA Identity Governance & Lifecycle for more information.
Create a Generic Database Connector that uses the jTDS driver
|
Notes | 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. |