on 08-25-2006 9:03 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.