cancel
Showing results for 
Search instead for 
Did you mean: 

How to Insert all Records together using JDBC Receiver Adapter.

Former Member
0 Kudos

Hi,

Suppose, I have to send 5 records and from R/3

(using client Proxy) using XI and insert/update all these records in a database.

In case I want to update all the 5 records else mark it as fail and return the response synchronously to R/3, what should be my approach?

Can we do it using native sql querries, if yes could you plese tell me how to do so.

I have never used native sql queries.

Thanks in advance.

Regards

Pushkar

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Michael,

If I use standard synch JDBC config, I will just get a response with no of records updated.

I want this update to fail if, even a single record update is failed.

In short I want to update all the records together.

Regards

Pushkar

udo_martens
Active Contributor
0 Kudos

Hi Pushkar,

put all updates into one statement, you ll get them all updated or nothing.

Regards,

Udo

Former Member
0 Kudos

Hi Pushkar,

If you are using the standard JDBC formats, map the occurences of the source to the access node in the target structure.

Karen..

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

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

Go through this.

regards

Reward points if find helpful

MichalKrawczyk
Active Contributor
0 Kudos

hi,

>>>>Can we do it using native sql querries, if yes could you plese tell me how to do so.

why don't use use standard jdbc adapter and standard jdbc document formats?

the sync jdbc call will return the number of affected /deleted rows

Regards,

michal