ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: linked server with list parameter
Date Mon, 06 Oct 2008 20:30:26 GMT
Have you enabled logging to see what statement is being generated?  It
would probably help.

Jeff Butler

On Mon, Oct 6, 2008 at 2:50 PM, Tomoiaga, Alin <alin.tomoiaga@ttu.edu> wrote:
> Hi,
>
>         My previous statement was missing a quotation mark. I fixed it
> below, but my initial problem remains.
>
>
>
> <statement id="linkedServerWithListParameter" parameterClass="list"
>
> resultMap="correctResultMap">
>
>             select  * from openquery(LINKED_SERVER,
>
> 'select  ID  from REMOTE_TABLE
>
> <dynamic prepend="      where ">
>
>             <iterate open=" NAME in(" close=")" conjunction=",">
>
>             #[]#
>
>             </iterate>
>
> </dynamic>
>
> ')  RT
>
> left outer join LOCAL_TABLE LT on (RT.ID = LT.ID)
>
> <statement>
>
>
>
> Thank you,
>
> Alin
>
>
>
>
>
> ________________________________
>
> From: Tomoiaga, Alin [mailto:alin.tomoiaga@ttu.edu]
> Sent: Friday, October 03, 2008 4:31 PM
> To: user-java@ibatis.apache.org
> Subject: linked server with list parameter
>
>
>
> Hi,
>
>             I am trying to join two tables across a linked server while
> iterating through a list parameter .
>
>
>
>             I haven't been able to find the right syntax for this to work.
>
>             The below statement is not working:
>
>
>
> <statement id="linkedServerWithListParameter" parameterClass="list"
> resultMap="correctResultMap">
>
>             select  * from openquery(LINKED_SERVER,
>
> 'select  ID  from REMOTE_TABLE
>
> <dynamic prepend="      where ">
>
>             <iterate open=" NAME in(" close=") conjunction=",">
>
>             #[]#
>
>             </iterate>
>
> </dynamic>
>
> )  RT
>
> left outer join LOCAL_TABLE LT on (RT.ID = LT.ID)
>
> <statement>
>
>
>
>
>
>             I tried different combinations of quotes and apostrophes, but it
> didn't fix it.
>
>             Due to my system configuration, "openquery" has to be used for
> the remote query (cannot use a four-part name).
>
>
>
>             Does anyone know how to accomplish this? Any help would be
> appreciated.
>
>
>
> Thank you,
>
> Alin
>
> Texas Tech University

Mime
View raw message