Synchronous JDBC Adapter - All or none

[Former Member]

Hi

I want to make a synchronous call to MS SQL Server.

There are two conditions to be satisified.

1. Either all records has to be updated or nothing should be updated.

2. A response message has to be send back to R3 to show it in the Sender application

How can i achieve all or none and send a proper response back. to R3

I can use a file scenario also and achieve all or none. But the response back has to be send synchronously.

Please suggest a solution or a work around for this problem

Thanks

Sebin

[udo_martens]

Hi Sebin,

>>>Either all records has to be updated or nothing should be updated

This is standard

>>>

2. A response message has to be send back to R3 to show it in the Sender application

You will get a response message with no of changed rows. In case of exception use fault message, which you map back to ERP.

Regards,

Udo

[Former Member]

Hi Udo,

You mean if am sending 10 records then all will be inserted together or none will be inserted.. You mean to say that...

[udo_martens]

Hi Sebin,

yes, you only have to put that into one statement.

Regards,

Udo

[Former Member]

hi,

Go through this

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

Regards

Hemant

If find helpful plz award points