Response in JDBC - update_count

[Former Member]

hey all,

I trying to update table in the SQL server.

the update is success but in the response message i get a different

response, i get 0/1/2/30 in the update_count field, although that just 1 record was update.

ex:

req:

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

- <ns1:QMFlags_MT xmlns:ns1="http://tara.co.il:pppi:QMFlags">

- <QMFlags>

- <dbTableName action="UPDATE">

<table>OrderPhases</table>

- <access>

<QMFlagLab>1</QMFlagLab>

</access>

- <key>

<Plant>0300</Plant>

<SAPOrder>000001028326</SAPOrder>

<ParentMaterialNo>000000000001398000</ParentMaterialNo>

<PhaseNumber>0130</PhaseNumber>

</key>

</dbTableName>

</QMFlags>

</ns1:QMFlags_MT>

res:

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

- <ns1:QMFlags_MT_response xmlns:ns1="http://tara.co.il:pppi:QMFlags">

- <QMFlags_response>

<update_count>1</update_count>

</QMFlags_response>

</ns1:QMFlags_MT_response>

ex1:

req:

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

- <ns1:QMFlags_MT xmlns:ns1="http://tara.co.il:pppi:QMFlags">

- <QMFlags>

- <dbTableName action="UPDATE">

<table>OrderPhases</table>

- <access>

<QMFlagOpr>1</QMFlagOpr>

</access>

- <key>

<Plant>0300</Plant>

<SAPOrder>000001028326</SAPOrder>

<ParentMaterialNo>000000000001398000</ParentMaterialNo>

<PhaseNumber>0130</PhaseNumber>

</key>

</dbTableName>

</QMFlags>

</ns1:QMFlags_MT>

res:

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

- <ns1:QMFlags_MT_response xmlns:ns1="http://tara.co.il:pppi:QMFlags">

- <QMFlags_response>

<update_count>0</update_count>

</QMFlags_response>

</ns1:QMFlags_MT_response>

some one can help?

tanks,

shelly

[Former Member]

hi,

the problem is, when the 1 record is update some time i get zero in update_count field.

shelly

[bhavesh_kantilal]

Hi,

Have never encountered this issue.

Are you able to resimulate this error. What I feel would have happened is that the you would have had another scenario already updating the Table and then when your current scenario is trying to execute the same, it finds no rows to Update!

Would suggest that you recheck the same and then maybe turn on the Trace of your DB to see when the updating to the database is happening and check against your XI scenario's runtime,

Regards

Bhavesh

[Former Member]

Shelly,

That is quite strange. Are you sure, there is a record getting updated? Coz, if the request structure can not find any record that matches the condition in key tag, table will not be affected. In this case you may get 0 in update_count field.

Regards,

Jai Shankar

[bhavesh_kantilal]

Hi,

Can you give more details? The Request and Response XML seem to be correct.

Regards

Bhavesh

[Former Member]

Shelly,

I do not understand your problem. I can see the XML file in the required format. Do clarify this for more inputs...

Regards,

JaiShankar