Re: esql and max open cursors

[Simeon Walker]

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,

Hi,

I saw this recently but hadn't looked into it yet (in the process
of going from 2.0 to 2.1m3...)
The patch would be useful to me and probably other.

Regards,
Simeon
--
Simeon Walker,                      email: [EMAIL PROTECTED]
School of Biological Sciences,      phone: +44 (0)1248 383702
University of Wales, Bangor,        fax: +44 (0)1248 382569
Gwynedd, LL57 2UW, UK.              www: http://biology.bangor.ac.uk/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]