Skip to Content

JDBC Adapter multiple Selects

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 20, 2006 at 07:53 AM

    Hi,

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

    Regards,

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Target DB System could not find the person and so

      sql returncode is -4.

      Adapter stop with errorstatus.

  • Jul 20, 2006 at 11:32 AM

    Hi Ralf,

    you should divide your statements via message split.

    Regards,

    Udo

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Udo,

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

      So splitting is not possible

      regards

      Ralf