Skip to Content
avatar image
Former Member

Issue with JDBC receiver adapter : data not getting inserted in the table

Hi ,

I am facing the below error while trying to insert a row in sql database table :

"JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'dbo.PlannedWorkRaw' (structure 'INSERT_STATEMENT'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'.

Any idea how to resolve this error?

regards,

Vaibhav

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Aug 10, 2017 at 05:33 AM

    Shouldn't the 'access' node be the child node of "dtTablename" ?

    Br,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 10, 2017 at 05:36 AM

    It is data issue. most probably due some special character or negative sign at the end of any number.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I tried inserting the same data into database directly via 'INSERT INTO' statement and record was successfully inserted in the table , so it shouldn't be data issue . Also i have attached the sample xml data that i am sending and the database table screenshot in another comment.

  • Aug 09, 2017 at 07:13 PM

    Hi Vaibhav!

    Wouldn't you at least provide your insert message example?

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 10, 2017 at 07:14 AM

    Ya ..you are correct.

    Add comment
    10|10000 characters needed characters exceeded