Updating multiple tables using JDBC Adapter

[Former Member]

Hi,

I am trying to insert/update multiple tables using one message via JDBC adapter. The following is the message being posted. However, only the first statement was executed. Anything wrong?

Thanks in advance!

Hart

<?xml version="1.0" encoding="UTF-8"?>

<ns0:DeliveryDBUpdate xmlns:ns0="http://test.com/r3_integration"><DeliveryData><DelHeader action="UPDATE_INSERT"><table>DelHeader</table><access><DelNo>0080000230</DelNo><DelType>LF</DelType><XOverwrite>X</XOverwrite><ShipTo>0000000026</ShipTo><SoldTo>0000000026</SoldTo><Priority>00</Priority><DocDate>02/17/2007</DocDate><GText>CIF Test</GText><DelDate>02/20/2007</DelDate><PickDate>02/20/2007</PickDate><ShipPoint>NO02</ShipPoint><PackCount>00000</PackCount></access><key><DelNo>0080000230</DelNo></key></DelHeader>

<DelItem action="INSERT"><table>DelItem</table><access><DelNo>0080000230</DelNo><ItemNo>000010</ItemNo><GText>10# GRAN-GREAT VALUE</GText><Material>G04410G611</Material><Plant>6005</Plant><SLoc>6005</SLoc><RefDoc>mmenon32</RefDoc><RefItem>00000000</RefItem><DelQty>5.000</DelQty><UOM>BL</UOM></access><access><DelNo>0080000230</DelNo><ItemNo>000020</ItemNo><GText>25# GRAN- GREAT VALUE</GText><Material>G04025G611</Material><Plant>6005</Plant><SLoc>6005</SLoc><RefDoc>mmenon32</RefDoc><RefItem>00000000</RefItem><DelQty>5.000</DelQty><UOM>BG</UOM></access></DelItem></DeliveryData></ns0:DeliveryDBUpdate>

[bhavesh_kantilal · Accepted solution]

Hi,

You need 2 STATEMENT level tags,

<?xml version="1.0" encoding="UTF-8"?>

<ns0:DeliveryDBUpdate xmlns:ns0="http://test.com/r3_integration">

<b><DeliveryData1></b>

<DelHeader action="UPDATE_INSERT">

<table>DelHeader</table>

<access>

<DelNo>0080000230</DelNo>

<DelType>LF</DelType>

<XOverwrite>X</XOverwrite>

<ShipTo>0000000026</ShipTo>

<SoldTo>0000000026</SoldTo>

<Priority>00</Priority>

<DocDate>02/17/2007</DocDate>

<GText>CIF est</GText>

<DelDate>02/20/2007</DelDate>

<PickDate>02/20/2007</PickDate>

<ShipPoint>NO02</ShipPoint>

<PackCount>00000</PackCount>

</access>

<key>

<DelNo>0080000230</DelNo>

</key>

</DelHeader>

<b><DeliveryData1></b>

<b><DeliveryData2></b>

<DelItem action="INSERT">

<table>DelItem</table>

<access>

<DelNo>0080000230</DelNo>

<ItemNo>000010</ItemNo>

<GText>10# GRAN-GREAT VALUE</GText>

<Material>G04410G611</Material>

<Plant>6005</Plant>

<SLoc>6005</SLoc>

<RefDoc>mmenon32</RefDoc>

<RefItem>00000000</RefItem>

<DelQty>5.000</DelQty>

<UOM>BL</UOM>

</access>

<access>

<DelNo>0080000230</DelNo>

<ItemNo>000020</ItemNo>

<GText>25# GRAN- GREAT VALUE</GText>

<Material>G04025G611</Material>

<Plant>6005</Plant>

<SLoc>6005</SLoc>

<RefDoc>mmenon32</RefDoc>

<RefItem>00000000</RefItem>

<DelQty>5.000</DelQty>

<UOM>BG</UOM>

</access>

</DelItem>

<b></DeliveryData2></b>

</ns0:DeliveryDBUpdate>

Try with such a strcuture and let us know if it works.

Regards

Bhavesh

[Former Member]

Hello everyone,

Thanks a lot for all the responses! I had reviewed all the help links before I posted this message, unfortunately I did not notice that I was using the same statement for both updates. This is exactly what I was missing.

Best regards,

Hart

[former_member192343]

yes, you need separate statement for everu query

and look here about document format for JDBC reciever adapter http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

[Former Member]

Hi,

You need to create more than one statement to execute more than one query. So you can change the structure such that there are 2 statements "statement1" and "statement2" to execute 2 queries.

Regards,

P.Venkat

[Former Member]

Hi,

Please see the below link

multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards

Chilla..

[Former Member]

Hart,

Can you check the status of msg in commn channel monitoring and message monitoring? The msg structure looks good. Also, wait for some time, refresh the table and check again. Because, the first table is updated, the others should also get updated. If there was any error, none of the tables would have got updated. Check if the ststus is waiting or uccesful in cc and msg monitoring. If it is success, then open the table again and check.

Regards,

Jai Shankar

[Former Member]

Hi Hart,

Can u post each query separately...its a little bit unreadable...also did u check the comm channel in Adapter monitor...r u getting any kind of error in SXMB_MONI

Regards,

Akshay