Transaction Attribute

[Grishma Dube]

Hi All,

Suppose I've 4 transactions...if any error occurs i want to roll back 1,2 and 4th transaction to rollback but not the 3rd one...how can i achieve this?

Is it possible to do so? if yes,which transaction attribute, i should specify?

TAI

Grishma

[sawan parihar]

Hi,
Yes you can do this by starting a new transaction from 3. like suppose we have function f1 transaction t1
f1(){
f2();--> joins t1
f3()--->Start a new transaction here

f4()---> joins t1

}

you can give transaction attributes accordingly..

cheers

[Grishma Dube]

if i specify RequireNew attribute for third transaction will it work??



TAI

Grishma

[sawan parihar]

Yes specify transaction attribute as RequiresNew and it will start a new transaction and let other transactions join the existing one.



cheers.

[Grishma Dube]

Thanx a lot