Hi. Thank you for your answer.
I enabled debugging and the quotes seem to go through to the database ('select ID ...'):
select * from openquery(LINKED_SERVER,
'select ID from REMOTE_TABLE
where NAME in( ?, ?)
') RT
left outer join LOCAL_TABLE LT on (RT.ID = LT.ID)
I am guessing there is indeed a problem with the quotes, but rather when the parameter list
gets applied (?, ? ) and I don't know if CDATA would help then.
Please let me know if I misunderstood your observation.
Alin
________________________________
From: Nicholoz Koka Kiknadze [mailto:kiknadze@gmail.com]
Sent: Monday, October 06, 2008 3:33 PM
To: user-java@ibatis.apache.org
Subject: Re: linked server with list parameter
Should not you use CDATA sections to get quotation marks intact in your SQL ? And like Jeff
pointed out, look at the generated statements in your log
|