on 06-25-2008 12:01 PM
Hello,
I have scenario from oracle to file.
In JDBC sender adapter I have this statement:
SELECT * FROM OPEN_FRIDAYS_VW WHERE ID =197
I'm looking for the way to insert dynamic ID (instead off the number 197) via web page to communication channel.
Elad
Elad,
Unfortunately sender JDBC channel can not take dynamic values. But you can redesign your interface to achieve your requirement.
Web Appln (HTTP post) -> XI <->JDBC(rcr)->XI->Final target
Remember JDBC receiver channel works in Synch mode.
You need to implement a BPM for this.
Regards,
Jaishnkar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Elad,
for this, you have to map the select statement into a dedicated Message-Typ:
http://help.sap.com/saphelp_erp2005vp/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
Sample:
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:MT_Insert xmlns:ns0="http://xxxxxxxxx">
- <FreeNameForMessageType>
- <dbTableName action="select">
<table>YourTable</table>
- <access>
<ID>MappedValue</ID>
</access>
</dbTableName>
</FreeNameForMessageType>
Regards Mario
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.