JDBC Receiver

[Former Member]

Hi Experts

I am doing IDOC to JDBC Asynchronous .My requriment is

1.Insert the records in to one SQL table1

2. there is trigger on the new record it will insert the new records in to anohter table Table2 .

Problem: without second step i can able to insert the records into table1 .With second condtion

I am facing following error in JDBC Receiver adapter.

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'IDBADGES' (structure 'SacsHrMasterData'): com.microsoft.sqlserver.jdbc.SQLServerException: A result set was generated for update.

Please help on this

Thanks &Regards

Upendra

[Former Member]

Hi,

Have you tried with multiple XML query statments while inserting ?

XML
 ST1
  ACTION-->INSERT
  TABLE-->1
  ACCESS
   FEILD1
   ......
  KEY
   KEY1
 ST2
  ACTION-->INSERT
  TABLE-->2
  ACCESS
   FEILD1
   .....
  KEY
   KEY1
XML

I have not tried this but multiple select from different DB tables is working fine for me.

Regards,

Sunil.

[former_member200962]

check this (almost) similar discussion:

Regards,

Abhishek.