Hello, I am using Oracle ODBC for my application, while performing some operation it gives be exception : [Microsoft][Oracle ODBC]Invalid Transaction state.
Can any one tell me that is the cause of this exception?
I want that if data is inserted in database the it slould be reflected in all tables, and if any exception occur then no change should be reflected i any table. So, before starting insertion statement I have made connection.setAutoCommit(false);
And, if all process works fine (i.e. no exception occured then I set connection.commit() ).
Can anyone give me a solution?
posted 10 years ago
YOur approach sounds okay. It might have something to do with the way the code has been written. Could you post it to give some idea?