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 11 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?
We're all out of roofs. But we still have tiny ads:
the new thread boost feature: great for the advertiser and smooth for the coderanch user