Unable to reuse idle sessions.

Hi All,

My J2EE application works fine when it connects to a remote Oracle db server. But when it tries to use the local Oracle db server, the connection pooling mechanism fails. The way it works is as follows:

For every db operation, the application requests a connection from the connection pool. When the connection pool receives a request for a connection, it searches for idle connections. If it finds any idle connection, the same is returned otherwise a new connection is established. When the connection pool reaches the maximum number of connections, it can not create anymore new connections. The reason why the application is failing is that the idle connections are not being returned to the connection pool.

Interesting thing to note here is that the connection pooling mechanism works perfectly fine when connected to remote Oracle db server but it fails on the local db server.

Any clues on what might be causing this behavior? Is there any configuration parameter on the Oracle db server which needs to be set for the connection pooling to work on the local machine? Thanks in advance,
Nilesh Received on Tue Feb 01 2005 - 01:34:32 CST