cancel
Showing results for 
Search instead for 
Did you mean: 

SOAP to JDBC

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Thanks for every one

rajasekhar_reddy14
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hai!

I have tried the two statement Structure and it is working fine.Thanks for your suggestion.

Regard's

Preethi.

markangelo_dihiansan
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

markangelo_dihiansan
Active Contributor
0 Kudos

Hello,

If the mapping will happen one by one, it would be best to go with Raja's suggestion.

Hope this helps,

Mark

Former Member
0 Kudos

I agree.

Follow Raja's suggestion, n.2 statements structure message.

Former Member
0 Kudos

hai !

Can anyone give any Blogs related to this -->two statement structure for Receiver JDBC.

it will help me more.

regard's

Preethi.

rajasekhar_reddy14
Active Contributor
Former Member
0 Kudos

Is too easy to achive. You need only to duplicate statement occurs in message, and map the 1° statement with TableName1 and 2° Statement with TableName2

Former Member
0 Kudos

Hai

Thank u

i am process of trying this sure i will reply.

regard's

Preethi

baskar_gopalakrishnan2
Active Contributor
0 Kudos

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>

Former Member
0 Kudos

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