<select id="gah" resultclass="int"> select blah as value from sometable </select>
On 11/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi all let's consider a very simple select whose purpose is to extract a column of basic type. E.g. select MY_COLUMN from MY_TABLE for a list of values such as... 24 19 20 24 30 25 ... ( a set if the distinct specification would be used) (MY_COLUMN in this case is either of INTEGER or NUMERIC type) How should I define the SQL map? I've just read the "Implicit Result Maps" in the developer guide but I have not found any similar example (single column selection). All examples report cases of select * or select COLUMN_1, COLUMN_2, ... It's not a primitive result but, instead, a list (or set) of primitive results. Instinctively I would exclude an HashMap, because, definitively, return values are not named and cannot be accessed via keys. Should I anyway define a single property class / result map and use it along with queryForList? Or is there any simpler way? ciao
