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

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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).]
Consider Paul's rocket mass heater.
subject: JDBC Cursor Error
Similar Threads
ResultSet is not updateable.
Io Exception : Broken Pipe
ClassPath Problem
How Do I Insert records in multiple tables thru 1 SQL Query
Use default value of SQL