Is your oracle database configured properly? Try connecting multiple users using oem or sqlplus to rule out is the issue is from the database. I had a max cursor reached error before which was attributed to not closing the preparedstatement. Another thing you may try is to use the latest JDBC drivers. There are some issues with 9.0.3 and below drivers, found out on hibernate site.
Amin -----Original Message----- From: Au-Yeung, Stella H [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:52 AM To: Struts Users Mailing List 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]
