Proxy to jdbc Synchronous

[Former Member]

Hi,

how to retrieve jdbc data by sending primary key(through proxy).

please help me.

[Former Member]

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

[manoj_khavatkopp]

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 ?

[manoj_khavatkopp]

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

[Former Member]

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