To many cursors ? JDBC

From: Clemens Pott <clemens_at_intrasystems.de>
Date: Thu, 5 Aug 2004 10:34:43 +0200
Message-ID: <cesrff$hc5$02$1@news.t-online.com>

Hi,

i ve got a problem with too many open cursors. I`m using the oracle 9.0.2 jdbc driver. I create a stament, execute it and then I close it , then I close the connection. But after a wile there are too many open cursor. I think, if my java brakes down or something else happens, the garbage collector destroys the objects but the cursor will stay open??? Is there a way to find all open cusors and close them in the finally method of my object ? And what happens if the connection brakes down and the cursor are still open ?

Many Thanks
Clemens Received on Thu Aug 05 2004 - 03:34:43 CDT