Paul Sideleau created AS7-5557: ---------------------------------- Summary: Connection pool config unable to run check-valid-connection-sql only in background thread Key: AS7-5557 URL: https://issues.jboss.org/browse/AS7-5557 Project: Application Server 7 Issue Type: Bug Affects Versions: 7.1.1.Final Environment: SQL Server 2012 JTDS 1.2.5 JBOSS 7 Cluster using domain controller Centos OS virtual Reporter: Paul Sideleau There may be a bug trying to get check-valid-connection-sql to only run in the background thread instead of every-time a connection is checked out from the pool. We have our connection pools configured to do background validation. The validate-on-match is explicitly set to false. Our SQL is simply "SELECT 1". We are using JTDS driver 1.2.5 against SQL Server 2012. We use new relic for performance monitoring and it is showing that the "SELECT 1" is executed every time a connection is checked out from the pool. When we had this configured under JBOSS 6, new relic correctly did not show the "SELECT 1" statement occurring. Here is an example datasource that we place in our domain.xml file: <datasource jta="true" jndi-name="java:jboss/MSSQLDS-DKR" pool-name="jboss/DKR41" enabled="true" use-java-context="true" use-ccm="true"> <connection-url>jdbc:jtds:sqlserver://OUR_DATABASE;sendStringParametersAsUnicode=true;</connection-url> <driver>jtds-1.2.5.jar</driver> <transaction-isolation>TRANSACTION_READ_UNCOMMITTED</transaction-isolation> <pool> <min-pool-size>45</min-pool-size> <max-pool-size>150</max-pool-size> <prefill>false</prefill> <use-strict-min>false</use-strict-min> <flush-strategy>FailingConnectionOnly</flush-strategy> </pool> <security> <user-name>username</user-name> <password>password</password> </security> <validation> <check-valid-connection-sql>SELECT 1</check-valid-connection-sql> <validate-on-match>false</validate-on-match> <background-validation>true</background-validation> <background-validation-millis>60000</background-validation-millis> <use-fast-fail>true</use-fast-fail> </validation> <timeout> <blocking-timeout-millis>5000</blocking-timeout-millis> <idle-timeout-minutes>2</idle-timeout-minutes> <query-timeout>30</query-timeout> </timeout> </datasource> Thank you -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira