Skip to Content
0

Proxy to JDBC error

Mar 30 at 07:52 AM

31

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Evgeniy Kolmakov Mar 30 at 09:13 AM
0

Hi!

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

Regards, Evgeniy.

Share
10 |10000 characters needed characters left characters exceeded
D. Pattanaik Mar 30 at 01:15 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded