on 06-18-2007 11:24 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.