hi all i'm using 2 different CMP methods in a same method and want to rollback the transaction should any thing wrong occurs. using "required" as transaction attribute for 1st CMP and "mandatory" for hte 2nd. now whts happening tht if any sql related error comes (like duplicate key found, data mismatch etc) then it roll backs correctly. but if some other error comes like number format exception etc thn it commits instead of rollback. any help woudl realy be appriciated. thnx in advance. rgds