on 05-17-2011 8:27 AM
Hai Experts!
I want to the Configuration steps for the following requirement.
SOAP to JDBC
One source structure should be mapped to two different tables with diffrent stucture.
here in the design part i am having Two message mapping and two Operation mapping.
i want to know how i want to configure for this scenario.
Thanks in advance.
regard's
preethi.
Thanks for every one
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
first change design,
you dont required two message mappings and two operation mappings.
Create JDBC receiver data type with two statements and one statemmnet for one table and other one for 2nd table.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
One source structure should be mapped to two different tables with diffrent stucture.
here in the design part i am having Two message mapping and two Operation mapping.
i want to know how i want to configure for this scenario.
The configuration should be standard: 1 Receiver Det, 1 Interface Det, 1 Sender Agreement, 2 receiver agreements. Use xPath in your interface determination to filter which operation mapping will be used at runtime.
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.
Hai!
I followed the same steps that u have mentioned.
>>>>>Use xPath in your interface determination to filter which operation mapping will be used at runtime.
BUt, in the interface determination i have added both the Operation mapping,both should happen one by one.
but now the First operation mapping is done correctly and an Exception at runtime error is thrown fo rthe second OM.
How to solve this.
Regard's
Preethi.
refer below link,
http://help.sap.com/saphelp_nwpi71/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm
Regards,
Raj
Your requirement is too simple. Use SOAP adapter on the sender side. Refer SDN for it. Regarding JDBC two statment structure, create two statement for different table in one data structure..
Create structure something as below....
<DT_JDBCReceiver>
<StatementName1>
<dbTableName action=u201DACTION> // INSERT OR UPDATE OR SO
<table>realDbTableName</table> // FIRST TABLE NAME
<access>
<field1>val1</field1>
<field2>val2</field2>
</access>
<key> //IF YOU HAVE PRIMARY KEY IN THIS TABLE OTHERWISE KEY IS NOT REQUIRED
<field3>val2old</field3>
</key>
</dbTableName>
</StatementName1>
<StatementName2>
<dbTableName action=u201DACTION> // INSERT OR UPDATE OR SO
<table>realDbTableName</table> // SECOND TABLE NAME
<access>
<field1>val1</field1>
<field2>val2</field2>
</access>
<key> //IF YOU HAVE PRIMARY KEY IN THIS TABLE OTHERWISE KEY IS NOT REQUIRED
<field3>val2old</field3>
</key>
</dbTableName>
</StatementName2>
</DT_JDBCReceiver>
Hello Mr Preethi,
Take a look to this Blog Article, this may be helpful to solve your issue:
/people/luis.melgar/blog/2008/05/13/synchronous-soap-to-jdbc--end-to-end-walkthrough
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.