JDBC Receiver error

[Former Member]

Hi,

I am doing a IDOC ->JDBC scenario , when I rum it I get an error

Unable to execute statement for table or stored procedure. 'dbTableName' (Structure 'Statement1') due to java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'dbTableName'.

The SQL Query generated fails.

The SQL payload is as follows,

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

<ns0:PartDetails_Request xmlns:ns0="http://xxx.com/target">

<Statement1>

<dbTableName action="INSERT">

<Tablename>Table1</Tablename>

<Access>

<field1>APO_F_MAT</field1>

</Access>

</dbTableName>

</Statement1>

</ns0:PartDetails_Request>

Can anyone suggest me where I am going wrong.

Thanks,

Venu

Edited by: Venu Kudupudi on Mar 10, 2009 8:00 PM

[former_member181985 · Accepted solution]

Try this...............

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

<ns0:PartDetails_Request xmlns:ns0="http://xxx.com/target">

<Statement1>

<dbTableName action="INSERT">

<table>Table1</table>

<Access>

<field1>APO_F_MAT</field1>

</Access>

</dbTableName>

</Statement1>

</ns0:PartDetails_Request>

[Former Member · Accepted solution]

Thanks Praveen ...its sollved the problem

[Former Member]

Hi

You should use correct case for XML tags, ie:

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

check documentation: http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm