Honda ... [
https://community.jboss.org/people/honda23] created the discussion
"Data Source jboss 7.1.1"
To view the discussion, visit:
https://community.jboss.org/message/817031#817031
--------------------------------------------------------------
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 ,
--------------------------------------------------------------
Reply to this message by going to Community
[
https://community.jboss.org/message/817031#817031]
Start a new discussion in IronJacamar Development at Community
[
https://community.jboss.org/choose-container!input.jspa?contentType=1&...]