RE: ORA-01000: maximum open cursors exceeded Exception

2001-08-15 Thread Alex Paransky
Of DENNIS STRAIGHT Sent: Tuesday, August 14, 2001 5:45 PM To: Orion-Interest Subject: Re: ORA-01000: maximum open cursors exceeded Exception Then again, it could be normal operation and we just need to increase the number of cursors allowed. This is possible but I doubt it. Setting up the limit

Re[2]: ORA-01000: maximum open cursors exceeded Exception

2001-08-15 Thread Rafael Alvarez
Hello Alex, Not a long time ago I ran with that problem using orion 1.4.5. It was at the university, and we were using a central DB server for all the courses. The problem was that I was using a lot of EJB (25+) in an implementation of TPC-W benchmark (a e-commerce like app), but the DBA

FW: ORA-01000: maximum open cursors exceeded Exception

2001-08-15 Thread The elephantwalker
resend, first one didn't catch... -Original Message- From: The elephantwalker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 12:46 AM To: Orion-Interest Subject: RE: ORA-01000: maximum open cursors exceeded Exception Alex and Dennis, This is from experience with oracle

RE: ORA-01000: maximum open cursors exceeded Exception

2001-08-15 Thread Alex Paransky
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of The elephantwalker Sent: Wednesday, August 15, 2001 2:56 PM To: Orion-Interest Subject: FW: ORA-01000: maximum open cursors exceeded Exception resend, first one didn't catch... -Original Message- From: The elephantwalker [mailto

RE: ORA-01000: maximum open cursors exceeded Exception

2001-08-14 Thread Nusairat, Joseph F.
Title: RE: ORA-01000: maximum open cursors exceeded Exception I believe u get this error when you are opening tooo many connections. (duh) In other words make sure you are closing your Statements or PreparedStatements. If you are, then check with your DBA to see how many current cursors

Re: ORA-01000: maximum open cursors exceeded Exception

2001-08-14 Thread DENNIS STRAIGHT
-0399 textmsg: [EMAIL PROTECTED] -Original Message- From: Alex Paransky [mailto:[EMAIL PROTECTED]] Sent: Monday, August 13, 2001 6:51 PM To: Orion-Interest Subject: ORA-01000: maximum open cursors exceeded Exception We have been using the server more frequently now

RE: ORA-01000: maximum open cursors exceeded Exception

2001-08-14 Thread Kesav Kumar
Title: RE: ORA-01000: maximum open cursors exceeded Exception This is because you have too many opened statements and Resultsets. Make sure that you close your statements and resultsets properly. Try to debug the jdbc activity by setting the following properties. jdbc.debug

Auto-reply: RE: ORA-01000: maximum open cursors exceeded Exception

2001-08-14 Thread ORAPOST
://www.oracle.com EMAIL;PREF;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] REV:20010601T130645Z END:VCARD smime.p7s Title: RE: ORA-01000: maximum open cursors exceeded Exception I believe u get this error when you are opening tooo many connections. (duh

RE: ORA-01000: maximum open cursors exceeded Exception

2001-08-14 Thread The elephantwalker
Kolla Voquette Inc 650 356 3740(W) 510 889 6840(R) VoquetteDelivering Sound Information -Original Message- From: Alex Paransky [mailto:[EMAIL PROTECTED]] Sent: Monday, August 13, 2001 6:51 PM To: Orion-Interest Subject: ORA-01000: maximum open cursors exceeded Exception We have been using

RE: ORA-01000: maximum open cursors exceeded Exception

2001-08-14 Thread Alex Paransky
: 888-452-0399 textmsg: [EMAIL PROTECTED] -Original Message- From: Alex Paransky [mailto:[EMAIL PROTECTED]] Sent: Monday, August 13, 2001 6:51 PM To: Orion-Interest Subject: ORA-01000: maximum open cursors exceeded Exception We have been using the server more frequently now

RE: ORA-01000: maximum open cursors exceeded Exception

2001-08-14 Thread Alex Paransky
the number of cursors allowed. -AP_ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of The elephantwalker Sent: Tuesday, August 14, 2001 10:55 AM To: Orion-Interest Subject: RE: ORA-01000: maximum open cursors exceeded Exception Here's a bit of code I use alot

Re: ORA-01000: maximum open cursors exceeded Exception

2001-08-14 Thread DENNIS STRAIGHT
: Tuesday, August 14, 2001 10:55 AM To: Orion-Interest Subject: RE: ORA-01000: maximum open cursors exceeded Exception Here's a bit of code I use alot in ejb's. The handler interface only has one method, processResultSet. The getDBConnection is a helper method. Notice how the connection, resultset