Rollback : Enterprise Integrator 4.5.1/ Oracle Adapter(Intel

, ,
1

Hi,
We are using Enterprise Integrator 4.5.1 / Oracle Adapter(Intelligent)

When my SQL statement, say an INSERT statement which is in a try block fails, do i need to do a “explicit ROLLBACK” in my catch block if i want to rollback any of my previous SQL INSERT operations?.
Is it adviced to throw an exception explicitly in the catch block so that webMethods itself will ROLLBACK its previous SQL operations?.

Any Help would be appreciated.

Regards,
Gopal.K.

2

It’s good to add a CustomSQL template and assign a constant value “ROLLBACK” for “sql” variable in