Getting error in jdbc receiver while Inserting multiple records

[vishnu_pallamreddy]

Hi All,

My scenario is proxy to jdbc receiver using stored procedure.

We have developed the scenario and it is working fine for single record insertion.

But while trying to insert multiple records we are getting the following error.

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SAP.usp_InsertLeaveBalance' (structure 'Statement'): java.sql.SQLException: ERROR: Invalid XML document format for stored procedure: 'type="<SQL-type>"' attribute is missing for element 'Table' (Setting a SQL-type (e.g. INTEGER, CHAR, DATE etc.) is mandatory !)

Message Mapping.

Thanks in Advance,

vishnu pallamreddy

[baskar_gopalakrishnan2]

You might want to see this blog to create message structure for the stored procedure ....

http://scn.sap.com/people/thorsten.nordholmsbirk/blog/2009/04/23/xml-result-from-jdbc-adapter-stored...

[Former Member]

Hi,

You have used wrong cardinalities. Cross check ur structure and check my reply in below thread:

http://scn.sap.com/thread/3181452

Thanks

Amit Srivastava

[zameerf]

Hi,

Change the occurrence of EmployeeLeavesData node to 1..1.

This should solve the issue, as you call the StoredProcedure only once.

Also, make the Statement node to 1..unbounded

[former_member184681]

Hi,

This error is caused by the fact that your mapping doesn't fill the "TABLE" field in all occurrences of your output structure. You can use for instance the following mapping to fix it:

source                     ->

EmployeeLeaveData -> useOneAsMany -> TABLE

EmployeeLeaveData ->

Regards,

Greg