need clarification on adapter transaction

, ,
1

Hi All
i was developed my flow in this way…
MAIN…
Start Transaction
try…
Insert
update
delete service {Thes e is treated as a single unit and alll the operations perform on the same data base }

commit
catch…
roll back

If for example update transaction failed,is it roll backs insert to prevous state?

Can any body clarify on this…
hope for the positive response.

2

Hello,

Just try putting the StartTransaction outside the main Try Sequence.

For more information refer JDBC documentation.

Cheers,
Sasanka

3

Hi Sasanka,
Thanks for ur reply…

In try block i am calling two notification services

1.Insert Notification service(Successed)
2.update Notification service(Failed)

It will rollback only the Failed Update transaction or it will rollback both the transactions…
Can any one clarify this point.

4

Hello,

In a transaction context, either all the database operations are committed or all database operations are rolled back. No partial commit or rollback is possible.

Cheers,
Sasanka

5

Thanks sasanka,

Now i got it.