Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Error msg with the JDBC Adapter

Former Member

‎12-15-2006 4:49 PM

0 Kudos

Hi

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

1 REPLY 1

MichalKrawczyk
Active Contributor

‎12-15-2006 4:57 PM

0 Kudos

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>