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