You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by "Anusuri, Vijay M" <vi...@bankofamerica.com> on 2006/04/12 22:20:36 UTC

Simple connection pool question

Hi ,
 
I am trying to add the following highlighted new properties to my simple
connection pool to fix connection reset problem whenever database server
is rebooted.   Could you please explain me the connection pool behavior
when  PingConnectionsOlderThan property value = "0" ?  I assumed 3600000
value is in milli sec for PingConnectionsNotUsedFor  property.  Please
correct me if I am wrong.
I am using Oracle database.
 
<transactionManager type="JDBC" >
        <dataSource type="SIMPLE">
      <property name="JDBC.Driver" value="${driver}"/>
      <property name="JDBC.ConnectionURL" value="${url}"/>
      <property name="JDBC.Username" value="${username}"/>
      <property name="JDBC.Password" value="${password}"/>        
      <property name="Pool.PingQuery" value="select * from dual"/>
      <property name="Pool.PingEnabled" value="true"/>
      <property name="Pool.PingConnectionsOlderThan" value="0"/>
      <property name="Pool.PingConnectionsNotUsedFor" value="3600000"/>

     </dataSource>
</transactionManager>
 
 
Thanks,
Vijay