Error msg with the JDBC Adapter

Former Member — Fri, 15 Dec 2006 16:49:36 GMT

My scenario is sending data from RFC to JDBC. While testing this scenario I am getting system error. Here is the message when I checked in SXMB_MONI

<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'dwprod.LSAP_CSKS' (structure 'Statement'): java.sql.SQLException: ORA-00928: missing SELECT keyword</SAP:AdditionalText>

CSKS is the table in SAP and LSAP_CSKS is the table in JDBC. I am doing the action INSERT.

Thanks

Re: Error msg with the JDBC Adapter

MichalKrawczyk — Fri, 15 Dec 2006 16:57:39 GMT

hi,

apart from your error are you doing a direct insert to an SAP DB???

if so please don't do it as it's the worst practice ever

you have many other options to send data to SAP tables

(rfc, bapi, abap proxies, IDOCs)

Regards,

michal

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

topic Error msg with the JDBC Adapter in Application Development and Automation Discussions

Error msg with the JDBC Adapter

Re: Error msg with the JDBC Adapter