Problem sending Single Quote (') to Oracle DB via J2SEE

[Former Member]

Hi All,

We have a case here where we are connecting a Oracle DB located in different region and hence we are sending the data with the help of J2SEE adapters.

When we are sending data with single quotes (') we are receiving the below error:

Error parsing message content: Technical description "java.sql.SQLException: ORA-00917: missing comma

We are using the DB parameter: db.apostropheEsc=\' to escape the quotes. But this does not help.

When we remove the single quotes from the message it process successfully even though we have single quotes in date fields where we are using TO_DATE function.

Can some one help us here?

Thanks for your help in advance!

[subhro_de · Accepted solution]

Hi Biswajit,

Try putting two double quotes in sql query where you need quotes - for example :

SQL> SELECT 'ABC''S' name FROM DUAL;

this will evaluate to ABC'S

What is the Oracle version.

Regards

Subhro

[Former Member]

This works fine!

Thank you for your help.

Regards,

Biswajit

[subhro_de]

Biswajit,

Great - could you please close the thread and mark it as answered.

Regards

Subhro

[anupam_ghosh2]

Hi Biswajit,

                   Could you please post the exact query string you are sending ?

Also pls check this thread http://scn.sap.com/message/7822733

Regards

Anupam