Skip to main content
Skip table of contents

Deprecation of jTDS MSSQL Driver

The MSSQL jTDS driver has not seen any updates for many years and at this point we recommend using the official Microsoft driver which has been made open source in 2018.

The change should be straight-forward:

  • Download the most recent version of the driver that matches your Java version from the Microsoft page or from the Maven archives.

  • Add the .jar file to your confluence-install/confluence/WEB-INF/lib directory and restart Confluence.

For your MSSQL datasources in PocketQuery, continue as follows:

  • Change the driver to (from net.sourceforge.jtds.jdbc.Driver)

  • Replace jdbc:jtds:sqlserver in the datasource URL with jdbc:sqlserver

After making this change, double-check that your MSSQL datasources are working as before. If you have any trouble making this change, do not hesitate to reach out to us.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.