• Post Reply Bookmark Topic Watch Topic
  • New Topic

JDBC Cursor Error  RSS feed

 
Ranch Hand
Posts: 349
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 977
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).]
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!