Skip to Content
author's profile photo Former Member
Former Member

DB Insert failed through JDBC Adapter

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 21, 2005 at 11:31 PM

    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...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 09, 2005 at 11:29 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.