JDBC adapter error : ora-00933 SQL command not properly ended

[Former Member]

but I am quite sure to my configuration for jdbc was correct ,however it worked fine sometime, if is it the jdbc driver version problem? now the version is 9.2.0

[Former Member]

below is the message what I wanna send through SOAP to JDBC:

- <ns1:MT_JDBC_KELVIN xmlns:ns1="urn:kelvin.com.xi.jdbc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/">

- <Statement>

- <ZXI_MATERIAL action="">

<table>1</table>

- <access>

<MATNR>119</MATNR>

<MTART>1</MTART>

<WERKS>1</WERKS>

<LGORT>1</LGORT>

<LGPBE>1</LGPBE>

<MAKTX>1</MAKTX>

<MEINS>1</MEINS>

<MATKL>1</MATKL>

<EXTWG>1</EXTWG>

<PRDHA>1</PRDHA>

<GROES>1</GROES>

<BISMT>1</BISMT>

<BKLAS>1</BKLAS>

<QKLAS>1</QKLAS>

<PRCTR>1</PRCTR>

<XCHPF>1</XCHPF>

<UPDATED>1</UPDATED>

</access>

- <key1>

<MATNR>119</MATNR>

</key1>

</ZXI_MATERIAL>

</Statement>

</ns1:MT_JDBC_KELVIN>

[bhavesh_kantilal]

Hi Kevin,

You have not given any bvalue for the ACTION attribute ansd that is why the error.

ACTION = INSERT --> Allows u to insert rows into the table.

ACTION = INSERT|UPDATE --> Allows u to insert / update the table.

Just check this link for the same,

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

Bhavesh

[bhavesh_kantilal]

Hi Kevin,

can you give the strucutre of the message that is passsed to the JDBC adapter.?? I think this error has occured as the the document format of your JDBC adapter is not correct.

Regards,

Bhavesh

[Former Member]

What type of statement you are trying to execute?

Oracle documentation says that

[ORA-00933: SQL command not properly ended]

Occurs when you try to execute an SQL statement with an inappropriate clause.

Rgds,

Amol