Error in JDBC Receiver

[venky_b]

Hi All,

I am doing Proxy to JDBC scenario. I am getting the following error at receiver side.

"JDBC Message processing failed, due to Error processing request in sax parser: Error when executing statement for table/stored proc. 'Table' (structure 'Statement'): java.sql.SQLException: [SQL0199] Keyword WHERE not expected. Valid tokens: (."

I am see this message at receiver end. I am using as/400 database.

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

- <ns0:MT_MATCHEDRECEIPT_SAP xmlns:ns0="http://practice.com/PI/JDA">

- <Statement>

- <Table action="INSERT">

<Table_Name>MM4R6DVL.SAPMRPF</Table_Name>

- <access>

<MRPONO>0123536523</MRPONO>

<MRRCVR>123536523</MRRCVR>

<MRINVN>5105600480</MRINVN>

<MRINUM>000000000123536520</MRINUM>

<MRINVQ>20</MRINVQ>

</access>

</Table>

</Statement>

</ns0:MT_MATCHEDRECEIPT_SAP>

Please let me know what could be the problem.

Thanks,

Venkatesh

[Former Member · Accepted solution]

Hi,

Check the difference.

Your structure:

<ns0:MT_MATCHEDRECEIPT_SAP xmlns:ns0="http://practice.com/PI/JDA">
- <Statement>
- <Table action="INSERT">
<Table_Name>MM4R6DVL.SAPMRPF</Table_Name> 
- <access>
<MRPONO>0123536523</MRPONO> 
<MRRCVR>123536523</MRRCVR>

Required structure:

}<ns0:MT_MATCHEDRECEIPT_SAP xmlns:ns0="http://practice.com/PI/JDA">

- <Statement>

- <SAPMRPF action="INSERT">

<Table>MM4R6DVL.SAPMRPF</Table>

- <access>

<MRPONO>0123536523</MRPONO>

<MRRCVR>123536523</MRRCVR>{

Regards,

Prakasu.M

Edited by: prakasu on May 21, 2009 6:00 PM

Edited by: prakasu on May 21, 2009 6:02 PM

[venky_b]

Hi All,

Thanks for all your useful inputs, The problem is solved.

<Table_Name>MM4R6DVL.SAPMRPF</Table_Name>

In above statement I used <Table_Name> instead of <table>. So I replace <Table_Name> with <table> tags. Scenario starts working

Thanks,

Venkatesh

[mf_haq]

Hi Venkat,

1.First thing is your XML structure is wrong,pls check it first.

2.SAX parser unable to process your structure bcoz of your using WHERE condition in SP.(Dont use it and check).

Your DB structure should be like this...just follow the below structure

<root>

<StatementName1>

<dbTableName action=u201DUPDATEu201D | u201CUPDATE_INSERTu201D>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName1>

All D Best

Rgds,

MFH

[Former Member]

Hi,

This error dur to passing wrong structure, your stucture look like this

<StatementName>

<dbTableName action=u201DINSERTu201D>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName>

</StatementName>

Abid Mazhar

[Former Member]

Hi,

Your structure is wrong..Check with the below link..

[http://help.sap.com/saphelp_nw70/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm]

Regards,

Prakasu.M

[venky_b]

Hi prakasu ,

What is the problem with my structure. Up to my knowledge my structure is correct. Please let me know.

Thanks,

Venkatesh