I have created a set of entity beans and sessions beans that access the database using standard JBDC calls.
I make sure that every result set, prepared statement, and connection are closed after ever call to the database.
The problem is that the number of open cursors to the database is constantly increasing, even after I explicitly "clean-up" the database resources. [I am also aware that Jonas manages the connections in the background, and doesn't explicitly close the connections when I issue an explicit connection.close ()].
The following query returns a list of open cursors in Oracle 8i:
select user_name, status, osuser, machine, a.sql_text
from v$session b,
v$open_cursor a
where a.sid = b.sid
Ever invocation to my entity beans increases the number of open cursors. Eventually, the cursor limit is reached, and Oracle throws an ORA-01000 maximum open cursors exceeded exception.
I'd really appreciate any help with regards to this problem.
I am currently running Jonas with Oracle 8.1.7 using the oci8 jdbc driver.
Thanks,
William
