cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic SQL Statements with an JDBC Adapter

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

this is not possible with JDBC Receiver adapter . you need to have Java Server-proxy.

Regards

Sreeram.G.Reddy