Transitioning from jTDS to Microsoft's JDBC driver
This page describes how to change from using jTDS to using the Microsoft SQL Server JDBC driver to access Microsoft SQL Server.
What do I have to do?
If Bitbucket Server was configured to use Microsoft SQL Server by following the steps outlined in Connecting Bitbucket Server to SQL Server, no change is necessary . However, if Bitbucket Server was configured to use Microsoft SQL Server by manually entering a JDBC URL, the system will lock on startup if the driver class and URL are not manually updated.
How to proceed
In the Bitbucket Server home directory, bitbucket.properties must be edited to change the JDBC driver and URL. The existing configuration should look similar to this:
jdbc.driver=net.sourceforge.jtds.jdbc.Driver
jdbc.url=jdbc:jtds:sqlserver://localhost:1433;databaseName=stash;
jdbc.user=stashuser
jdbc.password=secretpassword
The JDBC URL above is in the format constructed by Bitbucket Server when Connecting Bitbucket Server to SQL Server and will automatically be updated to a URL compatible with Microsoft's driver, with no change required on the administrator's part. If the URL contains additional properties, such as domain=, it will need to be manually updated.
To use Microsoft's SQL Server driver, the settings above would be updated to this:
jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://localhost:1433;databaseName=stash;
jdbc.user=stashuser
jdbc.password=secretpasswordThe exact values to use in the new URL are beyond the scope of this documentation; they must be chosen based on the jTDS settings they are replacing.
Additional Information
The new JDBC driver class is: com.microsoft.sqlserver.jdbc.SQLServerDriver
The JDBC URL format for the jTDS driver is documented on SourceForge at http://jtds.sourceforge.net/faq.html#urlFormat.
The JDBC URL format for Microsoft's SQL Server driver is documented on MSDN at http://msdn.microsoft.com/en-us/library/ms378428.aspx, with documentation for additional properties at http://msdn.microsoft.com/en-us/library/ms378988.aspx.