on 09-14-2011 5:09 AM
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
Deva
Check this blog : /people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step
Regards
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
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.