Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC XML SQL error

Hi experts,

Please, can anyone help me with an issue regarding JDBC XML SQL?

I'm trying to insert data into Oracle database using JDBC Adapter.

The payload is:

<?xml version="1.0" encoding="UTF-8" ?> 
- <ns1:MT_MyMessageType xmlns:ns1="urn:company-com:xpt:comp">
- <Statement>
- <TB_MYORACLETABLE action="INSERT">
- <access>
  <FIELDNAME1>SA</FIELDNAME1> 
  <FIELDNAME2>SAP7</FIELDNAME2> 
  </access>
  </TB_MYORACLETABLE>
  </Statement>
  </ns1:MT_MyMessageType>

And I'm geting this error:

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. 'TB_MYORACLETABLE' 
(structure 'Statement'): java.sql.SQLException: ORA-01861: literal does not match format string

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question