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 ?
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 ]
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
SC999
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
