HiSo if i add the following to the SimpleDataSource properties will it work, will Ping Connections older then 30 minutes, or connections not used for 30 minutes and then recreate them if required or have issue?
<property name="Pool.PingEnabled" value="TRUE"/> <property name="Pool.PingConnectionsOlderThan" value="300000"/> <property name="Pool.PingConnectionsNotUsedFor" value="300000"/> On Mon, Apr 27, 2009 at 3:43 PM, Chris O'Connell < [email protected]> wrote: > Configuring your 'ping' query will be specific to whatever database > connection pool you are using. See if there is some documentation you can > find for your pool. In general, what this will do is just have the pool > execute some very simple query at some configurable time. This shouldn't > execute every time a user needs a connection from the pool. Instead, this > should execute every 15 minutes or 30 minutes (or whatever). Basically, you > are executing these queries every so often so that the systems around you > are reminded that these connections are active and shouldn't be closed. > > > On Mon, Apr 27, 2009 at 2:39 PM, Ashish Kulkarni < > [email protected]> wrote: > >> HiHow does the performance get affected if i add a ping query, or what is >> the best way to do it >> >> On Fri, Apr 24, 2009 at 1:10 PM, Chema <[email protected]> wrote: >> >>> Logs show that he's using a SimpleDataSource , so I guess, the >>> connection pool is implemented by iBatis >>> >>> I bet for a "firewall issue". Some is resetting the connection. >>> (Connection reset) >>> >>> >>> >>> 2009/4/24 Chris O'Connell <[email protected]>: >>> > I think the issue is within the database pool you are using, with is an >>> > entity separate from iBatis. >>> >> >> > > > -- > -- > Chris O'Connell > Application Developer > Gorilla > 312.243.8777 x19 > >
