« Return to Thread: select multiple fields query

select multiple fields query

by Filipe David Manana-2 :: Rate this Message:

Reply to Author | View in Thread

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@...

"The cruellest lies are often told in silence."

 « Return to Thread: select multiple fields query