DB Insert failed through JDBC Adapter

[Former Member]

Hi all,

My system is on the latest patches of XI3.0 SP9. I am trying to insert some records into a database through JDBC adapter. The XML arriving at JDBC adapter is:

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

<ns:MaterialDataUpdate_Msg xmlns:ns="http://acsis.com/ManufacturingManagement">

<MaterialData>

<TMP_MAT_SERIAL action="INSERT">

<table>TMP_MAT_SERIAL</table>

<access>

<MATNO>0000000012</MATNO>

<BATCH>32151</BATCH>

<ITM_SERIAL>453176587769</ITM_SERIAL>

<WEIGHT>12.34</WEIGHT>

<T_TIME>2005-01-21 13:21:34.432</T_TIME>

</access>

</TMP_MAT_SERIAL>

</MaterialData>

</ns:MaterialDataUpdate_Msg>

The connection to the database looks ok. My JDBC adapter config is pointing to "jdbc:microsoft:sqlserver://sapsrv03:1433;databaseName=JDE".

In rwb, I got the following error:

Unable to execute statement for table or stored procedure. "TMP_MAT_SERIAL" due to java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'TMP_MAT_SERIAL'.

I have checked the database "JDE", and the table 'TMP_MAT_SERIAL' does exist.

Does anyone have any idea about this error?

Thanks a lot for helping!

Hart

[Former Member]

Hi Hart Liu,

My system is on the latest patches of XI3.0 SP9. I am trying to insert some records into a database through JDBC adapter.

We have been facing with problem XSD structure in the jdbc side. We r manually created XSD structure. In the adapter engine we don’t have any action item. In u r mail

U r structure contains action attribute.

Can u plz help me out to generate the right XSD structure?

We have one more doubt, is there any automatically structure-generated option? plz let us know.......

We r waiting for u r reply....

Plz help me!!!!!!!!

Regards,

Anil

[Former Member]

Just solved the problem. The logon user has to be the owner of the table or at least has the permission. The error returned is kind of misleading...