Atomikos Forum

Hi,

We are using Atomikos 3.6.5. We are having a problem with the firewall of our hosting provider closing idle database connections between our application server and our database.

With c3p0 connection pools we can set the following parameter on the pool:

idleConnectionTestPeriod

This will cause the pool to test (using the test query that is configured) any idle connections in the pool periodically. This test of the connection typically serves to verify that the connection is still usable but in my case it will act as a 'keep alive' for the connection so the firewall will not terminate it for inactivity.

There doesn't appear to be a similar attribute in Atomikos in the AtomikosNonXADataSourceBean that will work.

Suggestions?

This is a known feature request in our product backlog...