Return-Path: 
 <user-cs-return-2018-apmail-ibatis-user-cs-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-cs-archive@www.apache.org
Received: (qmail 99293 invoked from network); 28 Nov 2006 11:34:52 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 28 Nov 2006 11:34:52 -0000
Received: (qmail 9437 invoked by uid 500); 28 Nov 2006 11:35:02 -0000
Delivered-To: apmail-ibatis-user-cs-archive@ibatis.apache.org
Received: (qmail 9244 invoked by uid 500); 28 Nov 2006 11:35:01 -0000
Mailing-List: contact user-cs-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-cs-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-cs-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-cs@ibatis.apache.org>
List-Id: <user-cs.ibatis.apache.org>
Reply-To: user-cs@ibatis.apache.org
Delivered-To: mailing list user-cs@ibatis.apache.org
Received: (qmail 9230 invoked by uid 99); 28 Nov 2006 11:35:01 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 28 Nov 2006 03:35:01 -0800
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of jakub.scheibe@gmail.com
 designates 66.249.82.235 as permitted sender)
Received: from [66.249.82.235] (HELO wx-out-0506.google.com) (66.249.82.235)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 28 Nov 2006 03:34:48 -0800
Received: by wx-out-0506.google.com with SMTP id t14so1957724wxc
        for <user-cs@ibatis.apache.org>; Tue, 28 Nov 2006 03:34:28 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=ovAJqvQQaqUR8YqxP2thQ4A4/wQwiPKWBxTDjKhGWd2j6BvDFk8iiVYsE5gwjCC2o7cWzzF7745Q8lTiS4N/3GtTgcjICKtYx4TYoP26ZGbtUVNJTUGN/EnIUXR9P3jDBkgDXCHP4p2J6xvlIyzWAN1GQlLwBsl/Tn13lekaw9Q=
Received: by 10.70.131.20 with SMTP id e20mr1514652wxd.1164713668011;
        Tue, 28 Nov 2006 03:34:28 -0800 (PST)
Received: by 10.70.105.7 with HTTP; Tue, 28 Nov 2006 03:34:27 -0800 (PST)
Message-ID: <32163a230611280334h3d88bffv5fa0d08307a2c0e9@mail.gmail.com>
Date: Tue, 28 Nov 2006 11:34:27 +0000
From: "Jakub Scheibe" <jakub.scheibe@gmail.com>
To: user-cs@ibatis.apache.org
Subject: Re: Dynamic ResultMaps
In-Reply-To: 
 <ACEC0E8E588A6A40BD2026CA63D74966865DD4@v2mailserver.in.v2solutions.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_4063_22559287.1164713667974"
References: 
 <ACEC0E8E588A6A40BD2026CA63D74966865DD4@v2mailserver.in.v2solutions.com>
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_4063_22559287.1164713667974
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Here is my class

    public class MyClass
    {

        private string _ID;
        public string ID
        {
            get { return _ID; }
            set { _ID = value; }
        }

        private string _Name;
        public string Name
        {
            get { return _Name; }
            set { _Name = value; }
        }
    }

here is my sql

        <select id="Select" parameterclass="MyClass" resultclass="MyClass">
            select
            <dynamic>
                <isEqual property="Id" compareValue="1">
                    ID
                </isEqual>
                <isEqual property="Name" compareValue="true" prepend=",">
                    NAME
                </isEqual>
            </dynamic>
            from MYTBL
        </select>

As a result I have only nulls.
Can u verify what may be wrong?
May be I'm blind or too something but I don't have any clue what's wrong
with that ...

Cheers,
Jakub.


On 28/11/06, Nikhil Vaghela <nikhil.vaghela@in.v2solutions.com> wrote:
>
>  Make sure that your public property name and the columns which you are
> retrieving from the query has got same names. Then it definitely works.
>
>
>
> Nikhil Vaghela
>
> V2Solutions
>
> A New Vision to Solutions
>
> India: +91-22-56733201 ext 619
>
> US : 1-408-454-6051  ext 219
>
> http://www.v2solutions.com
>
> TZ : +5:30 GMT
>
>
>  ------------------------------
>
> *From:* Jakub Scheibe [mailto:jakub.scheibe@gmail.com]
> *Sent:* Tuesday, November 28, 2006 4:54 PM
> *To:* user-cs@ibatis.apache.org
> *Subject:* Re: Dynamic ResultMaps
>
>
>
> When I'm using my class as a resultclass i'm only getting
> null values :(
>
> On 28/11/06, *Nikhil Vaghela* < nikhil.vaghela@in.v2solutions.com> wrote:
>
> Hi ,
>
>
>
> In such situation you can use resultClass instead of resultMap , and in
> that case you should have your property [in your custom objects] names same
> as your query's fields name.
>
>
>
> Nikhil.
>  ------------------------------
>
> *From:* Jakub Scheibe [mailto:jakub.scheibe@gmail.com]
> *Sent:* Tuesday, November 28, 2006 4:42 PM
> *To:* user-cs@ibatis.apache.org
> *Subject:* Dynamic ResultMaps
>
>
>
> Hi,
>
> Is there any way to create dynamic resultmaps?
> In this moment i'm preparing dynamic sql statement but I don't know how to
> prepare dynamic resultmap
>
> Here is how i'm doing this:
>
>         <select id="Select" parameterclass="MyClass" resultmap="MyResMap">
>
>             select
>             <dynamic>
>                 <isEqual property="Id" compareValue="1">
>                     ID
>                 </isEqual>
>                 <isEqual property="Name" compareValue="true" prepend=",">
>                     NAME
>                 </isEqual>
>             </dynamic>
>             from MYTBL
>         </select>
>
> if I use following resultmap it working ok but i need to use both Id and
> Name in Select
>
>         <resultMap id="MyResMap">
>                 <result property="Id" column="ID"/>
>                 <result property="Name" column="Name"/>
>         </resultMap>
>
> Regards,
> Jakub
>
>
>

------=_Part_4063_22559287.1164713667974
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Here is my class<br><br>&nbsp;&nbsp;&nbsp; public class MyClass<br>&nbsp;&nbsp;&nbsp; {<br>&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; private string _ID;<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; public string ID<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; get { return _ID; }<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; set { _ID = value; }<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; }<br>
<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; private string _Name;<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; public string Name<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; get { return _Name; }<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; set { _Name = value; }<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; }<br>&nbsp;&nbsp;&nbsp; }<br><br>here is my sql<br><br><span class="e" id="q_10f2e51c59864230_3">
<span><font face="Times New Roman" size="3"><span style="font-size: 12pt;">
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;select id=&quot;Select&quot;
parameterclass=&quot;MyClass&quot; resultclass=&quot;MyClass&quot;&gt; <br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; select<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;dynamic&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;isEqual property=&quot;Id&quot; compareValue=&quot;1&quot;&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; ID<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;/isEqual&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;isEqual property=&quot;Name&quot; compareValue=&quot;true&quot;
prepend=&quot;,&quot;&gt; <br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; NAME<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;/isEqual&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;/dynamic&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; from MYTBL<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;/select&gt;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; <br>
</span></font></span></span><br>As a result I have only nulls.<br>Can u verify what may be wrong? <br>May be I'm blind or too something but I don't have any clue what's wrong with that ...<br><br>Cheers,<br>Jakub.<br><br>
<br><div><span class="gmail_quote">On 28/11/06, <b class="gmail_sendername">Nikhil Vaghela</b> &lt;<a href="mailto:nikhil.vaghela@in.v2solutions.com">nikhil.vaghela@in.v2solutions.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">













<div link="blue" vlink="blue" lang="EN-US">

<div>

<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Make sure that your public property name
and the columns which you are retrieving from the query has got same names. Then
it definitely works.</span></font></p>

<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">&nbsp;</span></font></p>

<div><pre><font color="black" face="Verdana" size="2"><span style="font-size: 10pt; font-family: Verdana;">Nikhil Vaghela</span></font></pre><pre><font color="black" face="Verdana" size="2"><span style="font-size: 10pt; font-family: Verdana;">
V2Solutions </span></font></pre><pre><font color="black" face="Verdana" size="2"><span style="font-size: 10pt; font-family: Verdana;">A New Vision to Solutions </span></font></pre><pre><font color="black" face="Verdana" size="2">
<span style="font-size: 10pt; font-family: Verdana;">India</span></font><font face="Verdana"><span style="font-family: Verdana;">: +91-22-56733201 ext 619</span></font></pre><pre><font color="black" face="Verdana" size="2">
<span style="font-size: 10pt; font-family: Verdana;">US : 1-408-454-6051&nbsp; ext 219</span></font></pre><pre><font color="black" face="Verdana" size="2"><span style="font-size: 10pt; font-family: Verdana;"><a href="http://www.v2solutions.com" title="http://www.v2solutions.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.v2solutions.com</a> </span></font></pre><pre><font color="black" face="Verdana" size="2"><span style="font-size: 10pt; font-family: Verdana;">TZ : +5:30 GMT</span></font></pre></div>

<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">&nbsp;</span></font></p>

<div>

<div style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">

<hr align="center" size="2" width="100%">

</span></font></div>

<p><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;"> Jakub Scheibe
[mailto:<a href="mailto:jakub.scheibe@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">jakub.scheibe@gmail.com</a>] <br>
<b><span style="font-weight: bold;">Sent:</span></b> Tuesday, November 28, 2006
4:54 PM<span class="q"><br>
<b><span style="font-weight: bold;">To:</span></b> <a href="mailto:user-cs@ibatis.apache.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">user-cs@ibatis.apache.org</a><br></span>
<b><span style="font-weight: bold;">Subject:</span></b> Re: Dynamic ResultMaps</span></font></p>

</div><div><span class="e" id="q_10f2e51c59864230_3">

<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">&nbsp;</span></font></p>

<p style="margin-bottom: 12pt;"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">When I'm using my class
as a resultclass i'm only getting<br>
null values :(</span></font></p>

<div>

<p><span><font face="Times New Roman" size="3"><span style="font-size: 12pt;">On 28/11/06, <b><span style="font-weight: bold;">Nikhil
Vaghela</span></b> &lt;<a href="mailto:nikhil.vaghela@in.v2solutions.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
nikhil.vaghela@in.v2solutions.com</a>&gt; wrote:</span></font></span></p>

<div link="blue" vlink="purple">

<div>

<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Hi , </span></font></p>

<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">&nbsp;</span></font></p>

<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">In such situation you can use resultClass instead of
resultMap , and in that case you should have your property [in your custom
objects] names same as your query's fields name.</span></font></p>

<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">&nbsp;</span></font></p>

<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Nikhil.</span></font></p>

<div>

<div style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">

<hr align="center" size="2" width="100%">

</span></font></div>

<p><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;"> Jakub Scheibe [mailto:
<a href="mailto:jakub.scheibe@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">jakub.scheibe@gmail.com</a>]
<br>
<b><span style="font-weight: bold;">Sent:</span></b> Tuesday, November 28, 2006
4:42 PM<br>
<b><span style="font-weight: bold;">To:</span></b> <a href="mailto:user-cs@ibatis.apache.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">user-cs@ibatis.apache.org</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> Dynamic ResultMaps</span></font></p>

</div>

<div><span>

<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">&nbsp;</span></font></p>

<p style="margin-bottom: 12pt;"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Hi,<br>
<br>
Is there any way to create dynamic resultmaps?<br>
In this moment i'm preparing dynamic sql statement but I don't know how to
prepare dynamic resultmap<br>
<br>
Here is how i'm doing this:<br>
<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;select id=&quot;Select&quot;
parameterclass=&quot;MyClass&quot; resultmap=&quot;MyResMap&quot;&gt; <br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; select<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;dynamic&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;isEqual property=&quot;Id&quot; compareValue=&quot;1&quot;&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; ID<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;/isEqual&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;isEqual property=&quot;Name&quot; compareValue=&quot;true&quot;
prepend=&quot;,&quot;&gt; <br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; NAME<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;/isEqual&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;/dynamic&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; from MYTBL<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;/select&gt;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; <br>
<br>
if I use following resultmap it working ok but i need to use both Id and Name
in Select <br>
<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;resultMap id=&quot;MyResMap&quot;&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;result property=&quot;Id&quot; column=&quot;ID&quot;/&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;result property=&quot;Name&quot; column=&quot;Name&quot;/&gt; <br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;/resultMap&gt;<br>
<br>
Regards,<br>
Jakub</span></font></p>

</span></div>

</div>

</div>

</div>



<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">&nbsp;</span></font></p>

</span></div></div>

</div>



</blockquote></div><br>

------=_Part_4063_22559287.1164713667974--