Unable to execute statement for table or stored procedure

[deviprasad_pothireddy]

Hi all,

While i was doing the file to jdbc scenario. I have seen this error( message monitoring- receiver end).

Unable to execute statement for table or stored procedure. "Student" due to java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near ')'.

and there no error in Integration Engine. This was the message that i found in IE(Response )

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

- <ns:student_mt2 xmlns:ns="http://practice1/File2Jdbc">

- <STATEMENTNAME>

- <TEST action="INSERT">

<TABLE>Student</TABLE>

</TEST>

- <access>

<stuName>Rahul</stuName>

<stuNumber>3434</stuNumber>

<stuMarks>56</stuMarks>

<stuAddress>India123</stuAddress>

</access>

</STATEMENTNAME>

</ns:student_mt2>

Please help me where can i see the Line1(syntax error) and also help me to solve this problem.

[Former Member · Accepted solution]

Hi ,

This is the correct structure......

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

- <ns:student_mt2 xmlns:ns="http://practice1/File2Jdbc">

- <STATEMENTNAME>

- <TEST action="INSERT">

<TABLE>Student</TABLE>

- <access>

<stuName>Rahul</stuName>

<stuNumber>3434</stuNumber>

<stuMarks>56</stuMarks>

<stuAddress>India123</stuAddress>

</access>

<b></TEST></b>

</STATEMENTNAME>

</ns:student_mt2>

[Former Member]

Hi Deviprasad,

download the payload as a XML file and open it with internet explorer.

internet explorer will show you where the error is.

Regards Mario

[prabhu_s2]

ur strucutre shud be like in the below format:

  <StatementName2>

<dbTableName action=”INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName>  

  </StatementName2>