Menu

#187 getAllDependentTables ORA-01000: maximum open cursors exceed

closed-accepted
None
5
2008-07-10
2008-07-10
pasha z
No

when try receive list of tables:
String[] depTableNames =TablesDependencyHelper.getAllDependentTables( dbUnitconnection, "TABLENAME" );

Exception appear:
java.sql.SQLException: ORA-01000: maximum open cursors exceeded

Parameter 'open_cursors' at server contains value=300.

If in AbstractMetaDataBasedSearchCallback.getNodes(int type, Object node, Connection conn,
String schema, DatabaseMetaData metaData, SortedSet edges)

insert rs closing (rs.close();), all work fine.

Discussion

  • matthias g

    matthias g - 2008-07-10
    • assigned_to: nobody --> gommma
    • status: open --> closed-accepted
     
  • matthias g

    matthias g - 2008-07-10

    Logged In: YES
    user_id=1803108
    Originator: NO

    Hi pasha_z,

    thanks a lot for this report. I fixed it in the SVN repository (rev. 708/trunk) - it is really an obvious bug that nobody seems to have noticed until now.

    Regards,
    mat

     

Log in to post a comment.