cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Synchronus - receiver

deva_gembali2
Participant
0 Kudos
58

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Deva

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

Regards

Raj

Answers (2)

Answers (2)

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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