cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Exception

Former Member
0 Kudos

Hi All,

I am getting the following error in JDBC Adapter.

<i><b>Error: TransformException error in xml processor class: Error processing request in sax parser: Error when executing statement for table/stored proc. 'JDBCTEST' (structure 'STATEMENTNAME'): java.sql.SQLException: [SQL0104] Token , was not valid. Valid tokens: DAY PATH YEAR LABEL MONTH OPTION RESULT CONNECTION TRANSACTION.</b></i>

Please help me with this issue.

Thanks.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi ,

Make sure that your target database JDBCTEST is accessible and the column names are correctly defined.ALL columns are CASE SENSITIVE...

check your reciever data type structure also.

Sekhar

bhavesh_kantilal
Active Contributor
0 Kudos

Can you give us the datatype format being passes to the JDBC adapter..Will help get the reson for your error.

Regards,

Bhavesh

Former Member
0 Kudos

I am getting error as

<b>Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'NSADDTA.NSAPOLP' (structure 'STATEMENTNAME'): java.sql.SQLException: [SQL0104] Token ) was not valid. Valid tokens: DAY PATH YEAR LABEL MONTH OPTION RESULT CONNECTION TRANSACTION.</b>

For below XML message/payload.

<?xml version="1.0" encoding="UTF-8" ?>

- <ns2:MT_POcreate_Interface xmlns:ns2="http://nmhg.com/nsa0012/PoProcessing:srm_to_gil">

- <STATEMENTNAME>

- <TEST action="INSERT">

<table>NSADDTA.NSAPOLP</table>

</TEST>

- <access>

<POLDU>2006-08-30</POLDU>

<POLSH>2006-08-30</POLSH>

<POLFL>A</POLFL>

<POLID>2006-08-30</POLID>

<POLUM>EA</POLUM>

</access>

</STATEMENTNAME>

</ns2:MT_POcreate_Interface>

bhavesh_kantilal
Active Contributor
0 Kudos

Sheetal,

Your datatype format is incorrect. This is how it should be,

<?xml version="1.0" encoding="UTF-8" ?>

- <ns2:MT_POcreate_Interface xmlns:ns2="http://nmhg.com/nsa0012/PoProcessing:srm_to_gil">

- <STATEMENTNAME>

- <TEST action="INSERT">

<table>NSADDTA.NSAPOLP</table>

- <access>

<POLDU>2006-08-30</POLDU>

<POLSH>2006-08-30</POLSH>

<POLFL>A</POLFL>

<POLID>2006-08-30</POLID>

<POLUM>EA</POLUM>

</access>

<b></TEST></b>

</STATEMENTNAME>

</ns2:MT_POcreate_Interface>

Regards,

Bhavesh

moorthy
Active Contributor
0 Kudos

Hi,

This error may be because of your XML message structure which goes into JDBC adapter .

WHat is the scenario ?

Also check this document format for the JDBC adapter-

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

Regards,

Moorthy