Return-Path: 
 <user-java-return-11419-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 22273 invoked from network); 17 Apr 2007 17:43:53 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 17 Apr 2007 17:43:53 -0000
Received: (qmail 24763 invoked by uid 500); 17 Apr 2007 17:43:56 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 24749 invoked by uid 500); 17 Apr 2007 17:43:56 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 24737 invoked by uid 99); 17 Apr 2007 17:43:56 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Apr 2007 10:43:56 -0700
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 ashish.kulkarni13@gmail.com
 designates 72.14.214.236 as permitted sender)
Received: from [72.14.214.236] (HELO hu-out-0506.google.com) (72.14.214.236)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Apr 2007 10:43:49 -0700
Received: by hu-out-0506.google.com with SMTP id 22so3748844hug
        for <user-java@ibatis.apache.org>;
 Tue, 17 Apr 2007 10:43:28 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed;
        d=gmail.com; s=beta;
        h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
        b=qIsLUCCOPaCyWQQAWxXMRWbIl2Xv/PqX25MzeAFuf2PCb3rb26IZk8QsrM+t2V51FQPzfa1ro93vx05lFVnIFUr7T5aov2h9KK8NQ4ptrj8e4vnrPxTGpGMS7wkUi8CYNEknxDNaPCz3nPWt/VptYiSj8Ef+hX3ZfoWgTE2g12Q=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:mime-version:content-type;
        b=V3d22hA4u1C+evvN2EfOJnh2i3kKcnc1+PMCTx3RJark6UtjHqpkpZ4qQ4O23hAyZtTmfGIQj9ymUbF5ZQsLRqd7R62uQdKczu6snJQz+kxg+UjqcplUBAhZSOXqDCF04SlLMjKMnbA+32v2lfNFKKjOI2KNbTgoVwo44VOAX54=
Received: by 10.82.173.19 with SMTP id v19mr1276435bue.1176831807758;
        Tue, 17 Apr 2007 10:43:27 -0700 (PDT)
Received: by 10.82.155.2 with HTTP; Tue, 17 Apr 2007 10:43:27 -0700 (PDT)
Message-ID: <878c6f8e0704171043y6b73eb75l80f2a314abea2c96@mail.gmail.com>
Date: Tue, 17 Apr 2007 13:43:27 -0400
From: "Ashish Kulkarni" <ashish.kulkarni13@gmail.com>
To: user-java@ibatis.apache.org
Subject: Get XML as resultClass from Ibatis issue
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_54116_24222656.1176831807675"
X-Virus-Checked: Checked by ClamAV on apache.org

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

Hi
I have following definition in my sql-map file

<select id="getINCOTERMSGR" resultClass="xml" parameterClass="
java.math.BigDecimal" xmlResultName="INCOTERMSGR">
    SELECT M009D as INCOTERMDESCGR FROM pu1012 , cf1009 WHERE PCPORD =
#value# and M009KY = '3T1'concat PCINCO
</select>

I run the query as below

List list = sqlMapClient.queryForList("getINCOTERMSGR", new
BigDecimal("20"));

I was expecting that list will be filled with Document objects,  Inside list
is filled String objects.

Is this how it works, or am i doing some thing wrong?


Ashish

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

Hi<br>I have following definition in my sql-map file<br><br>&lt;select id=&quot;getINCOTERMSGR&quot; resultClass=&quot;xml&quot; parameterClass=&quot;java.math.BigDecimal&quot; xmlResultName=&quot;INCOTERMSGR&quot;&gt;<br>
&nbsp;&nbsp;&nbsp; SELECT M009D as INCOTERMDESCGR FROM pu1012 , cf1009 WHERE PCPORD = #value# and M009KY = &#39;3T1&#39;concat PCINCO<br>&lt;/select&gt;<br><br>I run the query as below <br><br>List list = sqlMapClient.queryForList(&quot;getINCOTERMSGR&quot;, new BigDecimal(&quot;20&quot;));
<br><br>I was expecting that list will be filled with Document objects,&nbsp; Inside list is filled String objects.<br><br>Is this how it works, or am i doing some thing wrong?<br><br><br>Ashish<br><br>

------=_Part_54116_24222656.1176831807675--