JDBC Adapter Query

[former_member189440]

Hello Friends

can we send the data using single receiver jdbc adapter using multiple message types.

[Former Member · Accepted solution]

Hi

Yes you can send. JDBC receiver can be used by more than one Message type. Only thing is just maintain the Document format to avoid errors.

If you have any particular requirement do share to solve furthur.

Thanks

Gaurav

[former_member189440 · Accepted solution]

Hi bhargava,

waht i need is that i have a data having multiple details customer details supplier details and so on what i need is that i have to send the data to concerned nodes using jdbc adapter to multiple tables can we use the same adapter for it

[Former Member · Accepted solution]

yes. it is possible. Just make sure u have proper doc format.. Just ur db name changes...and you will have multiple Message Type depending on the structure u want.

E.g

<root>

<StatementName1>

<dbTableName action=u201DUPDATEu201D | u201CUPDATE_INSERTu201D>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName1>

<StatementName2>

<dbTableName action=u201DINSERTu201D>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</dbTableName>

</StatementName2>

</root>

[Former Member · Accepted solution]

Hi Uday

Yes you can do that. You can use the same adapter for multiple calls

multiple details customer details supplier details and so on 

Follow the standard given in help

http://help.sap.com/saphelp_nw70/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm

Here they have given one complete <StatementName1> under a Root node

Add more statement in same format under the Root for referring to various table and use it for all details you wanted to insert or update.

Thanks

Gaurav