I check the webforum at the JRun site but didn't find any answer to my issue.
The issue I have is: 11/05 12:25:39 error java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded javax.servlet.ServletException: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded My issue started to occur when I switch over from JRun 3.1 to 4.0. I haven't experience this issue on JRun 3.1. The max cursor on the DB is set to 1500. We have check the code and it closes all the resultset, statement and the connection. We are assuming that it is the JRun connection pool that is having an issue. We are using the oracle classes12.zip driver. The machine gets a weekly reboot and there is about max 70 hits a day. Just trying to know where to start looking or test out... -Peter -----Original Message----- From: Skip Klobucher [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 9:20 AM To: JRun-Talk Subject: RE: Dynamic JRun Reconfiguration and Restart Hi Peter, This is one place where you can get answers to your JRun-related questions. There are generally a lot of knowledgeable JRun users who monitor the JRun-Talk discussion group and contribute product information and troubleshooting guidance. There is also a JRun Product Forum that is accessible from the Macromedia web site (http://webforums.macromedia.com/jrun/), which is monitored by both users and JRun Support personnel. And if your question is related to product installation, Macromedia also provides free of charge installation support at http://www.macromedia.com/support/jrun/installation.html. If your question is in-depth or time-sensitive, you may want to consider opening a support case. There is a fee associated with this (whereas the other options are free). But there is also accountability associated with an actual support case, and in many circumstances it's the best option. For more information on that, you can visit the Macromedia product support web site (http://www.macromedia.com/support/programs/). One of these options should cover whatever questions you may have. Hope this is helpful, thanks. Skip -----Original Message----- From: Lee, Peter [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 5:26 PM To: JRun-Talk Subject: RE: Dynamic JRun Reconfiguration and Restart I was wondering is this the email I can use to get some answer about a JRun issue I'm encountering. Sorry for the spam. -Peter ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://affiliates.macromedia.com/b.asp?id=2439&p=go/dw_aff1 Message: http://www.houseoffusion.com/lists.cfm?link=i:8:5310 Archives: http://www.houseoffusion.com/lists.cfm?link=t:8 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:8 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
