File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes JDBC Cursor Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Cursor Error" Watch "JDBC Cursor Error" New topic

JDBC Cursor Error

faisal mahmood
Ranch Hand

Joined: Nov 30, 2000
Posts: 349
When I try to insert too many entries (5000+) entries using
JDBC I get an error complaining that it ran out of open cursors.
Here I use the same connection to insert and having commit after
each insert statement.
Is there anyone encountered this error or know how to fix it?
Marcos Maia
Ranch Hand

Joined: Jan 06, 2001
Posts: 977
Coul�d you please post the piece of code where you get the connection and then release it. It�ll be easy to help.
But anyway check if you�re closing the statements or anything you�re using to insert as well.
[This message has been edited by Marcos Maia (edited August 21, 2001).]
subject: JDBC Cursor Error