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 <[EMAIL PROTECTED]> 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 <[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."
