Need information regarding setAutoCommit(false) in oracle otd

Hi All,

I need to insert data to two oracle tables. If data insertion to both tables are success then connection should commit else it should not commit.

Hence for this i set

1) oracleOtd.setAutoCommit(false);

The i inserted value to first table. During insertion to second table it

gave exception for me.

But when i checked database the data has been inserted to database

even though there is an exception.

I believe this oracleOtd.setAutoCommit(false) doesn't have any effect.

Please leet me know if i need to do some additional settings.

Regards

Venkatesh.S

[645 byte] By [VenkateshSampoornama] at [2007-11-27 10:29:49]

# 1

I use this same function (using JavaCAPS 5.1.1) and, admittedly, the opportunity to "test" this hasn't come up.

However, consider putting a rollback call in your catch-block.

oracleOtd.rollback();

Dave

dlevya at 2007-7-28 17:59:41 >

Java Enterprise System Hot Topic