ORA-01000 maximum open cursors exceeded
I am getting the following java sql exception error on jsp page :
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
This page connects with database and performs a query whose resultset is displayed on the page.The page get's refreshed every 55 secs or so.After a particular time period I get this error.
On searching the net I found that when the number of open cursors exceed such an error and the solution lies in properly closing these opened cursors.
So I tried to close the resultset after execution of the statement (ResultSet.close() ) but the problem still persists after a particular time usually 15 minutes or so I get this error.
Advice would be appreciated.
Thanks & Regards,