Announcement Announcement Module
No announcement yet.
ORA-01000: maximum open cursors exceeded Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • ORA-01000: maximum open cursors exceeded

    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

  • #2
    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.
    Last edited by karldmoore; Aug 27th, 2007, 03:07 PM.