• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

open cursor error

 
chandru
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,
we are facing the error :"MAX number of open cursors exceed 1000",
the solutions are close resultset , close statements ,close connection.
I think this error is because of resultsets only
but my pm don't agree with me.
but some can tell me why this error is ?
My assumption is right ?
 
rajesh kumar jhaver
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think you are using Oracle. In oracle you have limitation to open cursor. Ask your database administrator to increase the size of open cursor.

still you will get the error if the open cursors are exceeded(number which u have mentioned).
incoporate connection pooling mechanism to avoid such type of errors.
[ March 26, 2003: Message edited by: rajesh kumar jhaver ]
 
chandru
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
but can u confrim this
in java implicit curosrs are opened only when resultset is getting called , in case of select queries , Not even in update and insert .
Statement have not at all relation with cursors
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic