Query to be executed at Syn JDBC Receiver
I am facing with this issue, i am passing a Native SQL Query as string from Syn Proxy to Syn JDBC with a key field as place holder.
As per my understanding place holder field should have the same as the once used in Native SQL Query. In the query its prefixed & suffixed with $. Correct ?
Also in the action field i have put SQL_QUERY correct ?
I am passing a Select Query (join query). In the query i have same conversion functions for date manipulations which comes within ' ' (single quotes). This quotes changes to '
What could be the problem. In the Communication channel under Processing tab in SQL Syntax parameters (Escape symbol for apostrophe) what should be given ?
Based on the execution of the Select query some fields are fetcehd from Oracle table. This will be response message from JDBC to Proxy.
But i am getting error as '' Invalid SQL stmt" . What could be the problem. How to rectify.
Please give me soultion for the above questions.
Thanks & Regards