aspose file tools*
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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Cursor Error" Watch "JDBC Cursor Error" New topic
Author

JDBC Cursor Error

faisal mahmood
Ranch Hand

Joined: Nov 30, 2000
Posts: 349
Hi,
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?
Thanks,
Faisal
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).]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Cursor Error