Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rollback on transaction failes

843854Jan 16 2003 — edited Jan 16 2003

Hi,

I have got a problem when I try to rollback a transaction using a JDBC driver, but I don't understand why. Maybe someone can help me.

My problem is as follows:

on a connection with AutoCommit set to true, I define some INSERT actions on a certain table. Hereafter I do a commitTransaction(). This generates a SQLException, which I catch. In this catch I do a connection.rollback(). This results in the following error:

[SQLServer JDBC Driver]Not in local manual transaction mode

Does anyone know what this means and what causes this?

Regards,

Onno Kievit

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2003

Added on Jan 16 2003

#java-database-connectivity-jdbc

3 comments

326 views