Return-Path: 
 <user-java-return-14217-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 85103 invoked from network); 21 Apr 2008 16:36:41 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 21 Apr 2008 16:36:41 -0000
Received: (qmail 12413 invoked by uid 500); 21 Apr 2008 16:36:39 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 12400 invoked by uid 500); 21 Apr 2008 16:36:39 -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 12389 invoked by uid 99); 21 Apr 2008 16:36:39 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Apr 2008 09:36:39 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of larry.meadors@gmail.com
 designates 66.249.92.174 as permitted sender)
Received: from [66.249.92.174] (HELO ug-out-1314.google.com) (66.249.92.174)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Apr 2008 16:35:47 +0000
Received: by ug-out-1314.google.com with SMTP id e2so691058ugf.21
        for <user-java@ibatis.apache.org>;
 Mon, 21 Apr 2008 09:26:08 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        bh=ekbKzyfMuSq3QZ2b+cxo54J7NjXPk2GmtschPXjI8ck=;
        b=HuSQT3+TJHcyGlJQhhDin4CAvgoOUoXdkYN5wIQ6qTBowId0UBWUh4Um4bB0MhhyGSCaRlxFQINFJGanVbxT6gXCwTbAjoP/B1m/7x29h6tMqNCs3udELnjtOrihzOyUw+hTcTCghwdkHHgkezI4u1VYpTno4Xiw8pdve/CpoR0=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=Xu3AZ6cqvIawzyNZoFxpBUdCGuNrhfeUbP+D9m4f++Bt0f5p4xksuAbow9CUpgWD03OH7yrrBq/SOuZ8QZqJNRNpiUNDHUbqAj8LC8iEgeY4pxWRDlS84LVaeRh1wlUCh7hoXGoV4b5ZxEvKy4Uf9sI7G91+zh0jIR0Ddu5wGpI=
Received: by 10.67.115.4 with SMTP id s4mr4494992ugm.1.1208794561360;
        Mon, 21 Apr 2008 09:16:01 -0700 (PDT)
Received: by 10.66.248.19 with HTTP; Mon, 21 Apr 2008 09:16:01 -0700 (PDT)
Message-ID: <a10a823c0804210916m320db2efj8ad0ab41f34cee1b@mail.gmail.com>
Date: Mon, 21 Apr 2008 10:16:01 -0600
From: "Larry Meadors" <larry.meadors@gmail.com>
Reply-To: larry.meadors@gmail.com
To: user-java@ibatis.apache.org, fdmanana@ieee.org
Subject: Re: select multiple fields query
In-Reply-To: <cadf1c690804210743s6e8beeacsc8b80798db5cd9a8@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <cadf1c690804210621jafd6cf0s49d0dceeb0f133c0@mail.gmail.com>
	 <a10a823c0804210659u2138560bif67263f323227f68@mail.gmail.com>
	 <cadf1c690804210743s6e8beeacsc8b80798db5cd9a8@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org

Depends on the driver, some will let you use "double quotes" to control that.

Larry


On Mon, Apr 21, 2008 at 8:43 AM, Filipe David Manana <fdmanana@ieee.org> wrote:
> Thanks, it works nice :)
> I notice the Map's keys are always strings in uppercase. Is it possible to
> control the case?
>
> cheers
>
>
>
> On Mon, Apr 21, 2008 at 3:59 PM, Larry Meadors <larry.meadors@gmail.com>
> wrote:
>
> > You can't currently get a list of lists, but you can get a list of maps:
> >
> > <select id="getClusterNames" resultClass="hashmap">
> >
> > Larry
> >
> >
> >
> >
> >
> > On Mon, Apr 21, 2008 at 7:21 AM, Filipe David Manana <fdmanana@ieee.org>
> wrote:
> > > Hi,
> > >
> > > I am a beginner regarding iBATIS (Java version). I want to map a select
> > > query that returns rows of 2 fields. My sql map is:
> > >
> > >   <select id="getClusterNames" resultClass="String">
> > >      SELECT DISTINCT clustername, clustertype
> > >     FROM vwhost
> > >   </select>
> > >
> > > Using this mapping I get a List of Strings, but only values for the
> > > clustername field.
> > > I would like to get, for example, a List of Lists (each inner list would
> > > have exactly 2 strings).
> > >  Using "List" as the resultClass I get a List of empty Lists :(
> > > How can I get the 2 columns?
> > >
> > > cheers
> > >
> > > --
> > > Filipe David Manana,
> > > fdmanana@ieee.org
> > >
> > >  "The cruellest lies are often told in silence."
> >
>
>
>
> --
>
> Filipe David Manana,
> fdmanana@ieee.org
>
> "The cruellest lies are often told in silence."