JDBC: jTDS vs MS JDBC driver

Tigase XMPP Server supports two JDBC drivers intended to be used with Microsoft SQL Server - one created and provided by Microsoft itself and the alternative implementation - jTDS. Tigase is shipped with the latter in the distribution packages, wowever we do not recommend using jDTS with Tigase and urge users to use JDBC driver created by Microsoft. It can be downloaded from Microsoft website: JDBC Driver 4.0 for SQL Server and unpack archive, then copy sqljdbc_4.0/enu/sqljdbc4.jar file to ${tigase-server}/jars directory.

Depending on the driver used --user-db-uri needs to be configured accordingly.

  • Microsoft driver:

    --user-db-uri=jdbc:sqlserver://...
  • jDTS driver

    --user-db-uri=jdbc:jdts:sqlserver://...