You should investigate using connection pooling, such as is offered by the DBCP project, which is a Jakarta Commons subproject. Garbage collection does not release database connections. I'm not sure on all the details why not, but there are other reasons to use connection pooling such as performance. ----- Original Message ----- From: "Au-Yeung, Stella H" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, September 17, 2003 10:52 PM Subject: Tool to diagnose J2EE/Struts/Oracle problem
> I am havng a No resource Available problem with my J2EE/Struts/Oracle > application. It is saying I don't have any more Oracle connections > available. Even I am closing the result set, statement and connection, I > am still running into the problem. When I use the Oracle DBA monitor tool, > it shows that I have 10 'inactive' connection but then my app will give the > 'no resource available' error. So it looks like somehow it is not reusing > those inactive connections. Does Gabage Collection release those > connections? Does anyone have this problem before? > > So I am looking for a better 'tool' to find out why GC doesn't release those > connections or if those 10 'inactive' connections are actually available to > be re-used. Can someone give me a suggestion on this tool or how to > troubleshoot the problem? > > Thanks > Stella > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]