on 03-06-2007 3:24 PM
Hello,
i have a simple scenario:
A WebService calls SAP XI and XI has convert this request into an dynamic SQL for a particular DB-Table.
Two Questions:
1. Can this done with an JDBC-Receiverchannel or do i have to write a Java Server-Proxy?
2. How do i bring dynamic SQL Stratement into the JDBC Receiver-Adapter?
Regard
Gunnar
I think you should be able to achieve this using the SQL_QUERY / SQL_DML action in the JDB receiver adapter...
The SQL string can be dynamically created....
see the help link on different document types with JDBC receiver adapater....look for statement6...
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm
**********************************************************************************
<StatementName6>
<anyName action= SQL_QUERY | SQL_DML>
<access>SQL-String with optional placeholder(s)</access>
<key>
<placeholder1>value1</placeholder1>
<placeholder2>value2<placeholder2>
</key>
</anyName >
</StatementName6>
**********************************************************************************
Thanks,
Renjith
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
this is not possible with JDBC Receiver adapter . you need to have Java Server-proxy.
Regards
Sreeram.G.Reddy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.