ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anusuri, Vijay M" <vijay.m.anus...@bankofamerica.com>
Subject Simple connection pool question
Date Wed, 12 Apr 2006 20:20:36 GMT
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

Mime
View raw message