Return-Path: 
 <ibatis-user-java-return-2542-apmail-incubator-ibatis-user-java-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org
Received: (qmail 26033 invoked from network); 27 May 2005 12:55:54 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 27 May 2005 12:55:54 -0000
Received: (qmail 27019 invoked by uid 500); 27 May 2005 12:55:52 -0000
Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org
Received: (qmail 26985 invoked by uid 500); 27 May 2005 12:55:51 -0000
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
List-Help: <mailto:ibatis-user-java-help@incubator.apache.org>
List-Unsubscribe: <mailto:ibatis-user-java-unsubscribe@incubator.apache.org>
List-Post: <mailto:ibatis-user-java@incubator.apache.org>
List-Id: <ibatis-user-java.incubator.apache.org>
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 26972 invoked by uid 99); 27 May 2005 12:55:51 -0000
X-ASF-Spam-Status: No, hits=0.4 required=10.0
	tests=DNS_FROM_RFC_ABUSE,RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of brandon.goodin@gmail.com
 designates 64.233.170.204 as permitted sender)
Received: from rproxy.gmail.com (HELO rproxy.gmail.com) (64.233.170.204)
  by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 27 May 2005 05:55:41 -0700
Received: by rproxy.gmail.com with SMTP id c16so409464rne
        for <ibatis-user-java@incubator.apache.org>;
 Fri, 27 May 2005 05:55:20 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=ACQAPS4TAwshWBeGRjzTp8TuJ3XxGbzN65M8gx788KGyJMH4Nd+0XP3y1/QdH8FwCvngnJfOyNre/Ywpj6gjQJ8VzT++XXvEN9+hBuAVxUMC3jLPzUCqLScD8b3v+iD8tAynEP/d7BL0pYCBr8OMQAMnqhYkhG/cSFzwqhKFwDg=
Received: by 10.38.12.13 with SMTP id 13mr3562147rnl;
        Fri, 27 May 2005 05:55:20 -0700 (PDT)
Received: by 10.38.74.48 with HTTP; Fri, 27 May 2005 05:55:20 -0700 (PDT)
Message-ID: <2fe5ef5b05052705554725f90a@mail.gmail.com>
Date: Fri, 27 May 2005 06:55:20 -0600
From: Brandon Goodin <brandon.goodin@gmail.com>
Reply-To: Brandon Goodin <brandon.goodin@gmail.com>
To: ibatis-user-java@incubator.apache.org
Subject: Re: Question on dynamic Select Columns
In-Reply-To: <MANDEX01GKpRmDSimea00001aba@mandex01.corp.mphasis.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <MANDEX01GKpRmDSimea00001aba@mandex01.corp.mphasis.com>
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hey Ritu,

The dynamic tags examine the parameterMap or parameterClass not the
resultMap. Also, since your select results will potentially differ you
will need to set the remapResults=3D"true" attribute in the <select>.

Brandon

On 5/27/05, Ritu Kedia <ritu.kedia@mphasis.com> wrote:
> =20
> =20
>=20
> Hello All,=20
>=20
>  =20
>=20
> This is my first post to IBatis. We are planning to use IBatis as our
> OR-Mapping tool.=20
>=20
>  =20
>=20
> First of all thanks to all the contributors for this great contribution. =
I
> particularly liked the dynamic SQl feature.=20
>=20
>  =20
>=20
> I have a question on whether the select columns can also be made dynamic?
> Currently I am getting SQLException for Invalid Column Name when the
> framework is trying to map the fetched data to the declared Result Map.=
=20
>=20
>  =20
>=20
> OR Could we bind the ResultMap dynamically to the Select statement? In ot=
her
> words could we have something like:=20
>=20
>       <select id=3D"FindDynamic" resultMap=3D"$resultMap$">=20
>=20
>             SELECT      ID,=20
>=20
>                         NAME=20
>=20
>             <dynamic prepend=3D",">=20
>=20
>                   <isNotNull property=3D"fetchDetails">=20
>=20
>                         DESCRIPTION,=20
>=20
>                   </isNotNull>=20
>=20
>             </dynamic>=20
>=20
>             FROM  SOME_TABLE=20
>=20
>             <dynamic prepend=3D"WHERE">=20
>=20
>                   <isNotNull prepend=3D"AND" property=3D"name">=20
>=20
>                         NAME $name_operator$ #name#=20
>=20
>                   </isNotNull>=20
>=20
>                   <isNotNull prepend=3D"AND" property=3D"description">=20
>=20
>                         DESCRIPTION $description_operator$ #description#=
=20
>=20
>                   </isNotNull>=20
>=20
>             </dynamic>       =20
>=20
>       </select>=20
>=20
> Where $resultMap$ would be passed via the Java API.=20
>=20
>  =20
>=20
> If the resultMap is hard bound to the following:=20
>=20
>       <resultMap id=3D"Detail_ResultMap" class=3D"Some_Detail">=20
>=20
>             <result property=3D"name" column=3D"Name"/>=20
>=20
>             <result property=3D"description" column=3D"Description"/>=20
>=20
>             <result property=3D"id" column=3D"ID"/>=20
>=20
>       </resultMap>=20
>=20
>  =20
>=20
> In the above select if the resultMap=3D"Detail_ResultMap" then when prope=
rty
> "fetchDetails" is not present then I get a SQLException "Invalid Column
> Name" for the Description column.=20
>=20
>  =20
>=20
> Could someone please suggest a way to accommodate the above requirement o=
f
> having dynamic select columns?=20
>=20
>  =20
>=20
> Thanks and Regards,=20
>=20
> Ritu Kedia