As part of our release for Jama Software 2014.1,we
made some improvements to our indexing and search functionality that
required an upgraded library for connecting to Microsoft SQL Server. However, after doing a bit of additional testing we found that we could make some significant performance improvements by modifying the original jTDS connector and moving away from Microsoft's official library. If you have installed 2014.1 with Microsoft SQL Server at any point, this change applies to you. Whether you're upgrading from 2014.1 now or have in the past, you'll need to make the following changes in order to take advantage of the improved performance. Who does this affect?
This issue will only affect users whose installations use Microsoft SQL Server as Jama Software's database management system, and who have installed the sqljdbc4.jar
driver as part of the installation process for Jama Software 2014.1
(build date 2014/05/16). The version number and build date can be found on Jama Software's login page. For more information, please see How can I tell what version of Jama Software I'm using?
You will only need to follow the steps outlined once, as part of your upgrade from Jama Software 2014.1 (regardless of which Jama Software version you are upgrading to). How do I make the change?
- Shut down Tomcat
- If necessary, go through the normal process to upgrade Jama Software, stopping before Tomcat is restarted
- Remove the sqljdbc4.jar file from [Tomcat home]/lib
- In your contour_home directory, remove the database.properties file (make sure you have your database connection information on-hand)
- Restart Tomcat and go through Jama Software's initial setup to reenter the database connection settings
Microsoft's URL format for specifying a named instance (jdbc:jtds:sqlserver://[host]\[instance]:[port]/[database]
) is not supported with the jTDS driver. To specify a named instance of SQL server, you’ll need to use the format jdbc:jtds:[server_type]://[host]:[port];database_name=[database];instance= [instance]
See the jTDS FAQ
for further details.#installation