cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in multiple records insertion in Receiver Jdbc.

former_member187437
Contributor
0 Kudos

In receiver jdbc, I insert multiple rows in a table.

My payload for jdbc adapter is

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

- <ns1:FMS_shipmentInfo xmlns:ns1="http://cts.com/fms_update">

- <ShipmentInfo>

- <InsertStmt action="INSERT">

<table>KmFuelTrace</table>

- <access>

<ResourceNo>M1D9GuKVQq</ResourceNo>

<ShipmentNo>0000011087</ShipmentNo>

<Weight>250</Weight>

<StartDate>20070827</StartDate>

<OdometerStart>Constant</OdometerStart>

<OdometerEnd>Constant</OdometerEnd>

<FuelCtrStart>Constant</FuelCtrStart>

<FuelCtrEnd>Constant</FuelCtrEnd>

</access>

</InsertStmt>

- <InsertStmt action="INSERT">

<table>KmFuelTrace</table>

- <access>

<ResourceNo>2h0{sX6MBq</ResourceNo>

<ShipmentNo>0000011081</ShipmentNo>

<Weight>325</Weight>

<StartDate>20071029</StartDate>

<OdometerStart>Constant</OdometerStart>

<OdometerEnd>Constant</OdometerEnd>

<FuelCtrStart>Constant</FuelCtrStart>

<FuelCtrEnd>Constant</FuelCtrEnd>

</access>

</InsertStmt>

</ShipmentInfo>

</ns1:FMS_shipmentInfo>

Eventhough a insertstatement is created for all the records, only one record gets

inserted. Is there anything wrong in the xml structure. or what might be the reason for this?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Aarthi,

If u are operating on the same table and with same action, then use multiple access in a single statement rather than multiple statements.

Regards,

Sudharshan N A

Former Member
0 Kudos

Hello Sudharshan,

Could you please explain it more.

Former Member
0 Kudos

Vidya,

Multiple statements should be used if you want to perform different operations like Inserts,Delete,etc sequentially on the same table in DB or same operation like Insert on different tables in the same DB.

Hope it is clear.

Regards,

Sudharshan N A

Answers (3)

Answers (3)

former_member187437
Contributor
0 Kudos

Thanks for all your responses. My problem is solved now with multiple access nodes within a single insert statement.

Former Member
0 Kudos

hi aarti

see if this helps

regards

'pratibha

Former Member
0 Kudos

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

- <ns1:FMS_shipmentInfo xmlns:ns1="http://cts.com/fms_update">

- <ShipmentInfo>

- <InsertStmt action="INSERT">

<table>KmFuelTrace</table>

- <access>

<ResourceNo>M1D9GuKVQq</ResourceNo>

<ShipmentNo>0000011087</ShipmentNo>

<Weight>250</Weight>

<StartDate>20070827</StartDate>

<OdometerStart>Constant</OdometerStart>

<OdometerEnd>Constant</OdometerEnd>

<FuelCtrStart>Constant</FuelCtrStart>

<FuelCtrEnd>Constant</FuelCtrEnd>

</access>

</InsertStmt>

<b></ShipmentInfo>

<ShipmentInfo></b>- <InsertStmt action="INSERT">

<table>KmFuelTrace</table>

- <access>

<ResourceNo>2h0{sX6MBq</ResourceNo>

<ShipmentNo>0000011081</ShipmentNo>

<Weight>325</Weight>

<StartDate>20071029</StartDate>

<OdometerStart>Constant</OdometerStart>

<OdometerEnd>Constant</OdometerEnd>

<FuelCtrStart>Constant</FuelCtrStart>

<FuelCtrEnd>Constant</FuelCtrEnd>

</access>

</InsertStmt>

</ShipmentInfo>

</ns1:FMS_shipmentInfo>

Try with this XML structure or multiple access nodes with in a single InsertStmt.

Regards,

Jai Shankar