I am using CMT in SLSB, from where I invoke a dao which inserts into two tables. The insert into the second table fails due to invalid data, but the transaction is not rolled back, there is a new record in the first table, which should not have been there in case of a successfull rollback. I have tried using setRollbackOnly(), but this too does'nt work. It is the same case if you use bean managed transactions too, the transaction is getting rollback even after calling the rollback() statement.
Any suggesstions.
Mohamed Zafer
-
Transaction does not rollback (2 messages)
- Posted by: mohamed zafer
- Posted on: February 21 2004 12:09 EST
Threaded Messages (2)
- Transaction does not rollback by stephen smithstone on February 21 2004 15:50 EST
- Transaction does not rollback by mohamed zafer on February 23 2004 09:00 EST
-
Transaction does not rollback[ Go to top ]
- Posted by: stephen smithstone
- Posted on: February 21 2004 15:50 EST
- in response to mohamed zafer
what database server you using if its MySQL then make sure your tables are
either BDM or InnoDB -
Transaction does not rollback[ Go to top ]
- Posted by: mohamed zafer
- Posted on: February 23 2004 09:00 EST
- in response to stephen smithstone
I am using Oracle 9