updating multpile tables and multiple rows - JDBC adapter

[Former Member]

Hi,

The scenario is like this. i receive an Idoc which has header information and various line items (multiple occurrance of a segment). the hearder details have to be sent to one table, TableA, and all line items has to go to another table, TableB, and for each line item, a new row has to be inserted in TableB.

How can i acheive this using JDBC adapter? how should my data type look like? what are the settings i need to do in adapter config?

Thanks and Regards,

Rashmi

[former_member194786 · Accepted solution]

Hi Rashmi,

You can use the following link for the JDBC adapter call :

http://help.sap.com/saphelp_nw04/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm

You need to provide the JDBC Driver, Connection,User Name and the password.

The data type structure you can take from the Bhavesh blog:

Since you just need to update the tables, take only the sender side of the blog, i.e. the request part and configure the scenario accordingly.

Regards,

Sanjeev.

[Jitendra_Jeswan]

Well I guess its only update to the table..looking at ur requirement your JDBC Receiver Document structure should look like this..

<MT_Table_Update>

<StatementName1>

<TableA action=u201CUPDATE_INSERTu201D>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col3>val2old</col2>

<col4>val4</col4>

</key1>

</TableA>

</StatementName1>

<StatementName2>

<TableB action=u201CUPDATE_INSERTu201D>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col3>val2old</col2>

<col4>val4</col4>

</key1>

</TableB>

</StatementName2>

</MT_Table_Update>

Please see this for more details:

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

[Former Member]

Hi,

You need to go with stored procedures....Iam not sure that we can do it in adapter configuration....

Thanks,

Madhu