3 Replies Latest reply on Sep 17, 2007 8:59 AM by darrylburke

    Error : [ODBC Microsoft Access Driver]Invalid transaction state

    807600
      Hi,
      When i am working with the Database connection in Java, I set conn.setAutoCommit(false). After completion of some task, when i try to close the connection object ( conn.close()) , it throws an SQLException as
      java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Invalid transaction state.

      But, at last when i set conn.setAutoCommit(true), it didn't throws an Error.

      Can anyone explain why it throws this error when setAutoCommit(false)??