[jboss-dev-forums] [IronJacamar Development] - Data Source jboss 7.1.1

[Honda ...]

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&containerType=14&container=2099]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-dev-forums/attachments/20130509/09a14b9b/attachment.html