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:
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)
