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,
-- Gildas GUILLEMOT
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
