Skip to Content
avatar image
Former Member

Proxy to JDBC error

In a proxy to JDBC synchronous scenario, while exceuting Select query, I am getting the below error : Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. SHIPMENT_DIFF (structure StatementName): com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-199, SQLSTATE=42601, SQLERRMC=WHERE;, FROM INTO, DRIVER=3.67.27

Can anyone help me with this? Have anyone worked before to solve the above issue?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 30 at 09:13 AM

    Hi!

    It seems that you try to execute SQL query using incorrect syntax. Wouldn't you provide your SQL statement's text?

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 30 at 01:15 PM

    Select x,y,z from Shipment_diff where y=value from source node.

    I will need the xml structure for this for both request and response as my scenario is synchronous

    Add comment
    10|10000 characters needed characters exceeded