PROXY TO JDBC RECIVER INTERFACE in (SAP XI 3.0)

[Former Member]

Hi Guys,

Please help me on below requirement:

1 . How do we plan to handle data consistency if we do not use transactions?  want to avoid partial updates. If one update-insert fails, I do not want      any of the other update-insert of the same interface to be committed.

     Is that handled automatically in PI ?

Regards,

Vin

[Former Member · Accepted solution]

Hi ,

I'm not 100 % confident on this but here is my suggestion.

When an update fails does the message fails in PI adapter engine ? If yes then i think we can restrict the other message flow by converting into EOIO flow.

Go through the below link 6th point.

http://help.sap.com/saphelp_nwpi71/helpdata/en/b0/676b3c255b1475e10000000a114084/frameset.htm

Regards

Venkat

[Former Member · Accepted solution]

Hi Venkat,

Can you explain anything about Transaction Isolation level in Rec JDBC..?

Regards,

Vin

[iaki_vila · Accepted solution]

Hi all,

The transaction isolation level depends of the DB driver, not all drivers support all the possibilities. Check first the driver specifications.

Regards.

[former_member184720 · Accepted solution]

Hi Vin- Isolation level helps in defining the behavior of how your transaction should be isolated from other transaction on the same tables.

eg : Your transaction is updating the table "A" and at the same time other user is reading the content of the same table.

The output of the select query depends on the isolation level set.

We have pre defined isolation level in the databas and based on your other question i see that you have MS SQL database.

Please refer to the below blog to understand more on the available transaction isolation levels and their behavior..

http://technet.microsoft.com/en-us/library/ms173763.aspx

[Former Member]

Hello,

I think u are repeating same question in multiple threads?

Thanks

Amit Srivastava

[iaki_vila]

Hi Vin,

As far as i know this is a driver problem, not PI. When i have had that problem i usually choose to do a statement procedure and to have the control in the DB.

Regards.

[former_member182455]

Hi,

please check the below link step by step for Proxy to JDBC interface

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0ac1a33-debf-2c10-45bf-fb19f6e15...

Regards