jdbc cursors

Hi, I'm using the oracle 8.0.4 JDBC drivers and have a loop which invokes a method to insert a row. The insert method creates a prepared statement and executes the update.

I'm getting a SQLException from the Oracle driver indicating that the max cursors have been reached. It seems each execute is allocaing a new cursor. I'm done with the statement after each insert.

How do I clean up the cursors?

...ed Received on Sat Dec 26 1998 - 13:29:59 CST