I know why this exception is generated, but I can not go through all the code and figure out where the connections, statements and resultsets are not properly closed because I had been given a task to figure out some one else's problem and the code is composed of 736 jsp and couple of hundred servlets , so it is almost impossible to go through all the statements..


Please tell me some trick or tip by which i could fix this bug with minimum navigation....


your help will be greatly appreciated...

Answer:


Cause : A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursor per user.

Action:
Modify the program to use fewer cursors. if this errors occur offen ,shutdown Oracle,increase the value of OPEN_CURSORS, and then restarted Oracle

Answer:


Cause : A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursor per user.

Action:
Modify the program to use fewer cursors. if this errors occur offen ,shutdown Oracle,increase the value of OPEN_CURSORS, and then restarted Oracle

besides increasing the open_cursors value, try to use business components, like hibernate of adf bc, for your sql statements. it makes your code more object-oriented