Cursor usage for Oracle JDBC classes12

From: Wil Weterings <weterings_at_schiphol.nl>
Date: Sat, 26 Feb 2000 11:04:39 +0100
Message-ID: <8988gp$f77$1_at_porthos.nl.uu.net>

I recently switch from using the classes111 jdbc 1.0 (jdk 1.1) driver to the classes12 2.0 driver for jdk1.2.

I am developing a JDBC based program that opens the database connection and issue SQL statements based on the open connection. It seems that the classes12 driver opens database cursors en keeps the cursor open until I close the database connection and that is not what I want.

I close the statements based on the connection with no result. It seems as long as the connection is open the database cursor are not closed. Is this a bug ?

I could change the program to close and reopen the connection for every query I want to do, but it seem like overkill.

Is it possible to close the cursors that are no longer used.

Wil.

Please respond to my E-mail weterings_at_schiphol.nl Received on Sat Feb 26 2000 - 11:04:39 CET