Skip to Content
0
Former Member
Mar 10, 2009 at 06:57 PM

JDBC Receiver error

27 Views

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" ?>

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