Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 18771 invoked from network); 6 Oct 2008 21:52:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 6 Oct 2008 21:52:56 -0000 Received: (qmail 21893 invoked by uid 500); 6 Oct 2008 21:52:48 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 21873 invoked by uid 500); 6 Oct 2008 21:52:48 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 21862 invoked by uid 99); 6 Oct 2008 21:52:48 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Oct 2008 14:52:48 -0700 X-ASF-Spam-Status: No, hits=2.1 required=10.0 tests=DNS_FROM_SECURITYSAGE,HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of alin.tomoiaga@ttu.edu designates 129.118.1.216 as permitted sender) Received: from [129.118.1.216] (HELO euphorbus.net.ttu.edu) (129.118.1.216) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Oct 2008 21:51:45 +0000 Received: from hoplodamus.net.ttu.edu (129.118.1.213) by euphorbus.net.ttu.edu (129.118.1.216) with Microsoft SMTP Server (TLS) id 8.1.291.1; Mon, 6 Oct 2008 16:52:20 -0500 Received: from CALYPSO.ttu.edu ([129.118.1.207]) by hoplodamus.net.ttu.edu ([129.118.1.213]) with mapi; Mon, 6 Oct 2008 16:51:46 -0500 From: "Tomoiaga, Alin" To: "user-java@ibatis.apache.org" Date: Mon, 6 Oct 2008 16:51:46 -0500 Subject: RE: linked server with list parameter Thread-Topic: linked server with list parameter Thread-Index: Ackn8t31dbn8WW0mRh+Asf6X8X42tgACf1qg Message-ID: <66390E48B31F66448941A152B09301DC05154F48@CALYPSO.ttu.edu> References: <66390E48B31F66448941A152B09301DC05154E40@CALYPSO.ttu.edu> <66390E48B31F66448941A152B09301DC05154F1D@CALYPSO.ttu.edu> <536e8800810061333w1b9af1a8p791ae52e28986df2@mail.gmail.com> In-Reply-To: <536e8800810061333w1b9af1a8p791ae52e28986df2@mail.gmail.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_66390E48B31F66448941A152B09301DC05154F48CALYPSOttuedu_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_66390E48B31F66448941A152B09301DC05154F48CALYPSOttuedu_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi. Thank you for your answer. I enabled debugging and the quotes seem to go through to the database ('sel= ect ID ...'): select * from openquery(LINKED_SERVER, 'select ID from REMOTE_TABLE where NAME in( ?, ?) ') RT left outer join LOCAL_TABLE LT on (RT.ID =3D LT.ID) I am guessing there is indeed a problem with the quotes, but rather when th= e 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 --_000_66390E48B31F66448941A152B09301DC05154F48CALYPSOttuedu_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi. Thank you for your answer.

I enabled debugging and the quotes see= m to go through to the database ('select ID ̷= 0;’):

select * from openquery(LINKED_SERVER,

'select ID= from REMOTE_TABLE

where NAME= in( ?, ?)

') RT=

left outer join LOCAL_= TABLE LT on (RT.ID =3D LT.ID)

I am guessing there is indeed a proble= m with the quotes, but rather when the parameter list gets applied (?, ? ) an= d 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, 20= 08 3:33 PM
To: user-java@ibatis.apache.org
Subject: Re: linked server w= ith 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 l= og

--_000_66390E48B31F66448941A152B09301DC05154F48CALYPSOttuedu_--