Skip to Content
0
Former Member
Nov 07, 2007 at 05:14 AM

JDBC Adapter throws error for Null Data

104 Views

Hi All,

I am running a interface Proxy to JDBC. But in case if proxy has no new data, the message which goes to the database is:

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

- <ns1:MT_Material xmlns:ns1="urn:sce-com:xi:fi:UnitEstimateData">

- <Insert_Material>

- <dbTableName action="INSERT">

<table>SCEI_UE_MATERIALS</table>

</dbTableName>

</Insert_Material>

</ns1:MT_Material></b>

and I get the error in RWB as <b>Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SCEI_UE_MATERIALS' (structure 'Insert_Material'): java.sql.SQLException: FATAL ERROR document format in structure 'Insert_Material': expected 'access' tag(s) not found</b>.

Is there a way so that the JDBC adapter doesn't throw any error if there is no access node??

Pls advice...

XIer