Insert Statements on Databsae to be rolled back in case of failure

[Former Member]

Hi Friends,

We are developing a Scenario where we r supposed to Insert Records in three

Tables.

We have developed three different Interfaces for it.

The Requirement is that even when 1st two Insert Interfaces are successful and

the third interface is failing,we have to Rollback the first two interfaces

How to go abt abt doing it?

Any helpful answer wld be rewarded.

Thanks,

Nilakantan.S

[kkram]

Can you club all the three interfaces in one by using mapping. Then you could use SQL in adapter or stored procedure to insert. I don't see any other way.

KK