Skip to Content
Former Member
Nov 19, 2013 at 12:51 PM

JDBC lookup error with nvarchar


Hello experts.

I have PI 7.3.

I have a scenario where I need to do a lookup to a table in an MSSQL 2008 server.

The column is defined to contain nvarchar (UTF encoded text)

noramlly to do an INSERT - I need to enclose the text in the message mapping with N'<text>'

However - when I try to do the same with the input of the lookup I get the following error:

... 57 more

Caused by: Error

when calling an adapter by using the communication channel

JDBC_RECEIVER_I_ORDERS (Party: , Service: MSDS, Object ID:

c79e34058bea38fb94a866818d62f68d) XI AF API call failed. Module exception: (No

information available). Cause Exception: 'Error processing request in sax

parser: Error when executing statement for table/stored proc. 'table' (structure

'statement'): Incorrect syntax

near 'ישראל'.'.





... 62 more

If I don't include the N'<text>' around the text - then the lookup is successful only for english letters. any other language such as hebrew return nothing and I get back NULL from the lookup.

Please assist.