[jboss-jira] [JBoss JIRA] (AS7-5557) Connection pool config unable to run check-valid-connection-sql only in background thread

[Paul Sideleau (JIRA)]

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