02-24-2006 12:21 PM - edited 03-09-2019 02:03 PM
Hi,
We are currently using connection pools and JDBC to connect between the DB and clients. The problem that keeps occuring as that these connections get dropped if they aren't used. I believe what is happening is since some of these connections are not used from the pool they get dropped because the connection has expired within the PIX table although there are other connections from the Oracles/JDBC connection pool. Using a smaller pool is not an option because at times we use all the connections allocated in the pool.
Does the PIX have a way around this? If not any other suggestions?
03-02-2006 08:23 AM
There is an option to set the PIX connection timeout. May be you can try setting the connection timeout that is close to the JDBC connection timeout.
03-02-2006 10:46 AM
We are trying to avoid increasing the connection timeouts. It is already at the defaults which are too long to begin with.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide