Max open cursors exceeded

You might come across this exception ORA-01000: maximum open cursors exceeded while using JDBC. This usually happens when you have too many ResultSet and Statement objects in a loop fetching thousands of rows.

To avoid this error, close every ResultSet and Statement before using it again. These are closed automatically when you close the connection but you don’t want to re-open the connection every time you iterate through the loop.