Database Type

Owned by Former user (Deleted)
Dec 21, 2021

Type of database.

Options:

  • MySQL
  • MS SQL Server
  • Oracle
  • DB2
  • Sybase SQL Anywhere
  • Other
     

Note

When using the database type Other, you will need to source the JDBC driver from your database vendor. Simply place the JDBC driver .jar file into the $CATALINA_HOME/webapps/uc/WEB-INF/lib directory and restart Tomcat. Format the Connection URL and Driver fields per the database vendor's documentation.

Note

Customers have reported difficulty establishing secure SQL connections using the jTDS open source JDBC driver for Microsoft SQL Server (Driver=net.sourceforge.jtds.jdbc.Driver) when SSL/TLS is enabled on the server.

We have received feedback that the issue can be resolved by installing a patched version of the jTDS driver from bug report https://sourceforge.net/p/jtds/bugs/725/.

Stonebranch only bundles the official jTDS release, currently 1.3.1, with the Universal Controller.

We do not include unofficial patches, and if you decide to use them, you do so at your own risk.