Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Cursor Error

 
faisal mahmood
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
 
Marcos Maia
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