Gildas Guillemot wrote:
Hi,
I'm using the esql with an Oracle database and when I have too many SQL errors during the connection, Oracle returns an ORA-1000 Maximum open cursors exceeded. After a search on the web, I found the problem occurs when resultSet and Statement are not closed.
It seems that in the esql.xsl file, in the "esql:connection//esql:execute-query" template, when a SQLException exception is catch, the resultSet and the statement are effectively not closed.
After addin a finally condition to close the resultSet and the Statement, the error did not occur anymore. Do you want I send a patch ?
thanks,
absolutely. submit it to bugzilla so it does not get lost. make sure you create a diff -u and specify which version of Cocoon you patched against (2.0 or 2.1). It would also be best to make sure you patch against the most recent version of that file from cvs.
bug #22050
I've made the patch against the most recent version from the cvs of cocoon-2.1.
-- Gildas GUILLEMOT
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
