Table of contents
You are trying to configure a SQL Server datasource, the connection fails and you find the following error in the logs :
This error occurs because of a version incompatibility between a Tomcat library (DBCP) and the JTDS driver. The latest JTDS driver works just fine with Tomcat 7, not with Tomcat 8.
The workaround is simple. You need to add a validationQuery property to your resource definition like this :
The resource definition is located in your server.xml or in JIRA context.xml file. This should look like this :