Search Again: ORACLE cursors release with JDBC From: Fabien Sanglard Date: Friday, October 24, 2003 Time: 2:18:16 am Hi, I'm a new Oracle/JAVA developper. I'm currently encountring a problem that i can"t solve despite my search within documentation and forums. I'm calling Oracle stored function from a Java Servlet. From a connection, i get a CallableStatement....the call i processesing with no problem....but, it seems that closing the CallableStatement with the "close()" message doesn't release the Oracle Cursor. So, after a long time period or during a intense access, i get ORACLE error : "too many cursor opened". Solution that i've found is to close the connexion before reach the cursor limit ( closing connection release cursors), but it's a dirty temporary solution. So, is there any way to close a cursor with JDBC ?! Do you think the problem can occure because i use CallableStatement instead of OracleCallableStatement ?! Thxs for any contribution ;) Fabien

Messages In This Thread: ORACLE cursors release with JDBC by Fabien Sanglard on Oct 24, 2003 at 2:18:16 am