ORA-01000: maximum open cursors exceeded

[Riz]

Hi,
I am using Spring for DAO connectivity

import org.springframework.jdbc.core.JdbcOperations;
private static JdbcOperations jdbcTemplate;
String sql = "select .....";
jdbcTemplate.query(sql, myMapper);

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 ?

Please help
Thanks
Riz

[karldmoore]

This is one of the good reasons to use Spring, it manages these boiler plate activities for you. Is it possible to see the rest of the code you are having problems with and also the configuration? This time [code] [ /code] tags would be a good idea. It would also be a good idea to write a unit test that tries to expose this problem.