on 07-26-2016 5:32 PM
Hi,
how to retrieve jdbc data by sending primary key(through proxy).
please help me.
Thanks for your replay
I configured as per above link , when i execute Response is empty, In sxmb_moni and rwb it is showing success , what may be the reason
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Does your select query with primary key has data against in DB i.e in DB whether the data exist or not for the condition for your select query.
In case if you have third party tool squirrel/toad try connecting DB through these and execute the SQl select query which you see in your receiver channel in the tool and see if this retrieves any data or not ?
Harish,
This is a simple PROXY<-->JDBC sync interface
Request mapping:
1. ECC will be sending you the primary key in one of the request field you map this to target JDBC structure with action "Select" or even you can build a complete SQL query and pass as a constant to the target structure.
2.Map the response from DB to proxy structure.
Check below blogs :
step by step RFC to JDBC scenario - Process Integration - SCN Wiki
Br,
Manoj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
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.