Simple connection pool question

[Anusuri, Vijay M]

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