JBoss Community

i want validate connection before borrow from pool , i config data source as mention below but no validation happen before borrow connection from pool although 'select 1 from dual ' exist . so how can i config it to validate each connection .

jboss version : 7.1.1

Data Base  : Oracle 11

<datasource jta="false" jndi-name="java:/OracleDS" pool-name="OracleDS" enabled="true" use-java-context="true" use-ccm="true">

                    <connection-url>jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = prod)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = prod)))</connection-url>

                    <driver>oracleDriver</driver>

                    <pool>

                        <min-pool-size>10</min-pool-size>

                        <max-pool-size>100</max-pool-size>

                        <prefill>true</prefill>

                                                            <flush-strategy>FailingConnectionOnly</flush-strategy>

                    </pool>

                    <security>

                        <user-name>name</user-name>

                        <password>pass</password>

                    </security>

                    <validation>

                        <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>

                        <check-valid-connection-sql>select 1 from dua11</check-valid-connection-sql>

                        <validate-on-match>true</validate-on-match>

                        <background-validation>false</background-validation>

                        <stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>

                        <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>

                    </validation>

                    <timeout>

                        <blocking-timeout-millis>5000</blocking-timeout-millis>

                        <idle-timeout-minutes>1</idle-timeout-minutes>

                    </timeout>

                    <statement>

                        <track-statements>true</track-statements>

                    </statement>

                </datasource>

                <drivers>

                    <driver name="oracleDriver" module="com.oracle.ojdbc6">

                        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

                    </driver>

                </drivers>

            </datasources>

 

thanks in advance ,