JDBC Synchronus - receiver

[deva_gembali2]

Hi Experts,

In JDBC synchronous -receiver sceanrio, how it will fetch the records by using sql query ?

Where to use SQL statement ? I hope we don't write SQL Statement inreceiver channel ?

Pls drop your answers .

deva

[Former Member · Accepted solution]

Deva

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

Regards

Raj

[Former Member]

Hi,

To Configure Receiver JDBC Adapter we have to Define the DataType in Specific Structure

While creating the Datatype we Specify Some fields like Action,Access, Key

which built the Query and fetches the data from database

Refer below links for more..

http://www.riyaz.net/blog/jdbc-adapter-configuration/technology/1200/

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

[markangelo_dihiansan]

Hello,

In JDBC synchronous -receiver sceanrio, how it will fetch the records by using sql query ?

First you have to define your XML SQL structure in repository

http://help.sap.com/saphelp_nwpi71/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm

then the jdbc adapter will take care of converting it into a SQL statement. The response (records fetched) would also be in the form of a SQL statement and the adapter will convert it into XML.

Hope this helps,

Mark