I work in a multi-user environment. In such an environment, I can never
know who else is doing what with the DB. Oracle maintains a maximum open
cursors that are accessible by everyone, through any means (sqlplus, jdbc,
etc). Theoretically, yes, open cursors should get cleaned up with close(),
but you have no guarantee as to when garbage collection is done. Upping the
max number of open cursors may only delay this problem, or may eliminate it
if either of the conditions above is true. The default number is fairly
small.
----- Original Message -----
From: "Bill Burke" <[EMAIL PROTECTED]>
To: "JBoss-User" <[EMAIL PROTECTED]>
Sent: Monday, March 05, 2001 11:45 PM
Subject: Re: [jBoss-User] maximum open cursors exceeded
> Where does that get me? Shouldn't the number of open cursors get
> cleaned up if I'm closing the ResultSet, Statement, and Connection?
>
> Regards,
> Bill
>
> Guy Rouillier wrote:
>
> > Have you tried increasing the number of open cursors allowed?
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
