Skip to Content

JDBC Receiver Channel Pars Error in PO 7.5

Dear Experts-

I am working on a scenario using PO 7.5 in which need to send the data to AS400 database. So I have configured the following data structure to send the data to AS400 database. When it is executed the data is getting populated meaning mapping is executed fine but on the receiver, the channel is seeing the following error.

JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. ' (structure STATEMENT): java.sql.SQLException: [SQL0104] Token 1 was not valid. Valid tokens: FOR USE SKIP WAIT WITH FETCH LIMIT ORDER UNION EXCEPT for OFFSET.

I have read some of the blogs which dealt with the same issue in past but it is not helping me. Please, it would be really appreciated if anyone can provide me thoughts on what am missing.

Data structure

Action: UPDATE_INSERT

Table name has been provided as of now. (Meaning hard coded not parameterized)

<root>

<StatementName1>

<dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName1>

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 04, 2017 at 11:15 PM

    Hari,

    ACCESS and key field structure should be child node of TABLENAME in your case they are sibling try correcting that.

    Br,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded