RECEIVER JDBC ADAPTER----ROLLBACK IN XI

[Former Member]

Hi Gurus,

I have a scenario with the receiver as JDBC adapter.If there is any error in updating to Database during the interface flow,how do Rollback occurs in XI???

Please help......

Regards,

Sriparna

[shivhare]

you need to monitor receiver communication channel . and you can also track error in Request Message Mapping and Technical Routing in MONI.

Regards,

Amit

[Former Member]

can we have series of SQL Query statements and after that Commit or a rollback depending on the successfull / unsuccessful execution of the statments

[kenny_scott]

Hi Sripam1,

select SQL statement 'batch mode' ,

i.e,

see

8. Defining Parameters in Advanced Mode

6. If you want to collect SQL statements in a batch, select Batch Mode.

of the SAP online help

[Configuring the Receiver JDBC Adapter|http://help.sap.com/saphelp_nwpi711/helpdata/en/48/465581929734d9e10000000a42189d/content.htm]

Also ensure that 'Database Auto-Commit-Enabled (No Transaction Handling)' is not enabled.

Regards

Kenny

[Former Member]

Hi,

you could also build a SQL-XML statement (see SAP help) which can consist of several INSERT/UPDATE Statements. If an error occurs, the whole message will automatically be rolled back, otherwise it is commited against the database. Leave the Auto-commit option off, this is only needed for databases, which don't have transaction handling (or better for the database drivers used to access the db).

Regards

Sven