cleanup of used resources should be done by OJB itself.
I assume you use PB.getCollectionByQuery, do you use the same PB instance for both queries?
Can you post the complete test code?
regards, Armin
Ribi Roland wrote:
I'm not a OJB Guru, perhaps anyone else here can help?
It could be a bug in OJB. But I don't know the Ojb very well.
Roland Ribi
-----Original Message----- From: Mindy Pereira [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 5:10 PM To: OJB Users List Subject: RE: Maximum open cursors exceeded
If that's the problem, how do I force OJB to close the statement?
-----Original Message-----
From: Ribi Roland [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 11:08 AM
To: 'OJB Users List'
Subject: RE: Maximum open cursors exceeded
This is'nt the problem of the query, this is because the close() Method
of a java.sql.Statement-Object is'nt called after the query.
Oracle needs to close all open cursers after the query is finished. This
occurs after too many SQL-Calls to the database without closing the
cursor. You can also create this behavior whith stored procedures in
Oracle.
Perhaps ojb does'nt closes the Statements in this QueryBySQL ?
Roland Ribi
-----Original Message----- From: Mindy Pereira [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 5:02 PM To: OJB Users List Subject: Maximum open cursors exceeded
I'm getting a collection beans using a QueryBySQL.
Previously, it worked with no problems, however, when I
added another
filter to the data set ("where X = Y and Z = 2 and W = 3"),
I got the
following error:
[org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR: ORA-01000: max imum open cursors exceeded
Any help would be appreciated. Mindy
---------------------------------------------------------------------
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]
--------------------------------------------------------------------- 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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
