JDBC Adapter multiple Selects

[ralf_zimmerningkat3]

Hi all,

we have multiple select statements in one message.

like this:

  <?xml version="1.0" encoding="UTF-8" ?> 
<ns1:SP10530T_MT xmlns:ns1="urn:lsv.de/TEST/SP10530T/SAPIDMS">
 <ChangeCustomer>
 <TPLSVXI_SP10530T action="SELECT">
  <table>TPLSVXI.SP10530T</table> 
 <access>
  <ADSMSG /> 
  <SSRC /> 
  <EL_MES_CODE /> 
  </access>
 <key1>
  <MITARBEITER_ID>1111111</MITARBEITER_ID> 
  </key1>
  </TPLSVXI_SP10530T>
  </ChangeCustomer>
 <ChangeCustomer>
 <TPLSVXI_SP10530T action="SELECT">
  <table>TPLSVXI.SP10530T</table> 
 <access>
  <ADSMSG /> 
  <SSRC /> 
  <EL_MES_CODE /> 
  </access>
 <key1>
  <MITARBEITER_ID>12232323</MITARBEITER_ID> 
  </key1>
  </TPLSVXI_SP10530T>
  </ChangeCustomer>
 <ChangeCustomer>
 <TPLSVXI_SP10530T action="SELECT">
  <table>TPLSVXI.SP10530T</table> 
 <access>
  <ADSMSG /> 
  <SSRC /> 
  <EL_MES_CODE /> 
  </access>
 <key1>
  <MITARBEITER_ID>33333333</MITARBEITER_ID> 
  </key1>
  </TPLSVXI_SP10530T>
  </ChangeCustomer>
  </ns1:SP10530T_MT>

the problem ist if statement 2 produce an error statement 3 will never execute!

i think the adapter have to send statement 3 too??

regards

ralf

[udo_martens]

Hi Ralf,

you should divide your statements via message split.

Regards,

Udo

[Former Member]

Hi Udo,

due tue performance reasons one message with many statements should be used.

So splitting is not possible

regards

Ralf

[bhavesh_kantilal]

Hi,

What kind of error are you talking? Can you please elaborate?

Regards,

Bhavesh

[Former Member]

Target DB System could not find the person and so

sql returncode is -4.

Adapter stop with errorstatus.