friends,
i have implemented connection pooling with oracle by using listener.
i done the entry in web.xml for connection url & username & password.
the program is running well but after some time it gives the error of listener refused error.
thanks in advance
I faced this problem in Oracle 8i. Only solution is Connection pool manager (CPM) should release all the DB connections after certain time-out interval defined in Connection pool manager if they are not used.
You have have to manage connections using Connection pool manager.
Lets say, your CPM creates a connection pool of maximum 10 connections. CPM should keep track of Total DB connections, Total exhausted connections.
Lets say you always should have 2 free connections in the pool.
example:
If Total_DB_connections - Total_exhausted_connections < 1 && Total_DB_connections < MAX_CONN (means only 1 free connection left and Total_DB_connections < 10), add another DB connection to pool.
Hope this helps.