on 2009 Mar 10 6:57 PM
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
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.