I am using Spring for DAO connectivity
private static JdbcOperations jdbcTemplate;
String sql = "select .....";
This opens a cursor. I have other similar such methods that open cursors and then i get the exception ORA-01000: maximum open cursors exceeded.
If I had used JDBC I could have close my Preparedstatements and ResultSets and got rid of it. but what do I do in Spring as I dont have a close method ?