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
com.microsoft.sqlserver.jdbc.SQLServerDriver(fromnet.sourceforge.jtds.jdbc.Driver)Replace
jdbc:jtds:sqlserverin the datasource URL withjdbc: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.