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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > 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, > > [EMAIL PROTECTED] > > > > "The cruellest lies are often told in silence." > -- Filipe David Manana, [EMAIL PROTECTED] "The cruellest lies are often told in silence."
