ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tomoiaga, Alin" <alin.tomoi...@ttu.edu>
Subject RE: linked server with list parameter
Date Mon, 06 Oct 2008 21:51:46 GMT
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

Mime
View raw message