Db cursors & java webapp

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Db cursors & java webapp

bartroby
Hi,

i have a java webapp (spring 2.5.3 + ibatis 2.3.4.726) with Oracle DB (10gR2).
Transactions are managed by Spring.
The connection pool has 15 connection (500 cursors for each connection).

In production environment we obtain "ORA-0100: Maximum open cursors exceeded".
The "ResultSet" is managed by the framework Spring+iBatis, we never access the "ResultSet" directly.

My question is:
when a DB cursor will be closed by the framework after a select statement?

Thanks