escape character for apostrophe ' in JDBC receiver channel

[Former Member]

Hi all,

We have Proxy to JDBC scenario in our project. This interface is working fine with unicode data but when there is an apostrophe( ' ) coming in any of the field values ( ex: DOWTHERM 'J' MODEL19QAGB1G ) , the message is failing in receiver JDBC channel.

can anyone please tell us how to handle single quote in JDBC receiver channel.

I have read in SAP help documentation that apostrophe is a reserved character in SQL syntax and is therefore replaced by an escape character if it occurs within value strings. There is a option to JDBC receiver communication channel under "SQL SYNTAX PARAMETER" to specify the escape character for apostrophe.

Can any please tell us which value needs to be maintained in the channel to avoid this error.

Regards

Jagruthi

[Former Member]

Hi,

Refer this blog...

/people/community.user/blog/2008/05/05/implementing-a-java-mapping-in-sap-pi-to-remove-escape-sequences-from-a-file

Hope this might be helpful for you!!

Regards,

Sainath Chutke

[Sakshi_T]

Hi,

[Sakshi_T]

Hi, I'm getting same error but with (,) in SAP CPI. Can you help me with the resolution?