JDBC receiver adapter can't escape a single apostrophe

[Former Member]

Hi All,

In ANY adapter --> JDBC senario,when I input the data where an element have only an apostrophe.

(I mean <element1>'</element1>) JDBC error happens.

I have set up '' as <i>Escape Symbol for Apostrophe</i>in JDBC adapter parameter (default).

But it doesn't work.

I guess JDBC adapter can't escapte a single apostorophe,and it's bug of XI.

Please tell me whether this symptom occurs in your enviroment.

I use XI3.0 SP16 and conect SQL Server 2000 and it.

Thanks,

Yuuki

[bhavesh_kantilal · Accepted solution]

Hi,

Use the attribute <b>hasQuot</b>,

<element1 <b>hasQuot=NO</b>>'</element1>

<i>hasQuot= YES|NO During construction of the WHERE condition of the SQL statement, the table column type determines whether the default is to set the values in quotation marks (text column types) or not (numerical column types). In a few cases (for example, when using functions), it may be necessary to override this. This attribute enables you to do this. If YES, quotation marks are always set round the values for which this attribute is set in the SQL syntax. If NO, quotation marks are never set. Only use this attribute in individual cases.</i>

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi,Bhavesh

Thanks for your message.

If you adopt your solution,you have to set <b>hasQuat=NO</b> in all elements of all mappings that may be inputed the data which contains '(single appostorohe).

But it's too difficult,please another solution.

Yuuki.

[bhavesh_kantilal · Accepted solution]

Hi,

I dont think there is another solution that is possible.

Regards,

Bhavesh