| peetez 2004-04-15, 3:04 pm |
| Hi all,
I'm using Apache 2.0.48, Tomcat 4.1.30 and Oracle 9.2.0.1. They work great
together until Oracle runs out of connection memory at some time.
This happens every two/three days, and I'm forced to reboot the Oracle
server. Everything is like the ConnectionPoolDatasource never releases the
connections, even though they are expired ( regarding the MaxIdle... in
tomcat's server.xml ).
I've also noticed that when I stop/start the webapp in tomcat, the
connections stay alive, while unreachable by the jvm.
Again, when I stress the application, connections seems no to be reusable
among sessions, ie a inactive session (which has released the connection,
i've checked that) doesn't effectively released the connexion to the pool...
What can I do from that point ??? Have I a spare solution, without rewriting
all the code ??? Should I use another object to connect ??
Cyril
|