As I have told you in my previous post, I was trying to read from a table within a loop. I am opening a new connection, new statement and firing the query to get the resultset. It was working fine for a few records, finally it dies with this exception
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
Alas, I forgot to close the resultset!!