A bit of clarification, noticed that my previous reply was a bit hard to follow :)
The place where I need to create a Map result object is not in the Java DAO, but when setting the Map property of a POJO in a resultMap. Currently I know how to do this with fixed names of the keys in the map to populate, but I would-like / have-to create dynamic keys in the Map. Any pointers how this could be accomplished are greatly appreciated, if I can provide more information please let me know. Cheers, Mike On 05/04/07, Daniel Pitts <[EMAIL PROTECTED]> wrote:
I think its called queryForMap :-) ------------------------------ *From:* Mikael Andersson [mailto:[EMAIL PROTECTED] *Sent:* Thursday, April 05, 2007 6:28 AM *To:* [email protected] *Subject:* Mapping reuslt to to java.util.Map with dynamic key(from column), possible? Hi I wonder if it is possible to populate a Map via a resultMap so that the key is the value from a column and the value the value of another column? I read how about to create a Map with pre specified key values in the PDF documentation, but I couldn't find how to use dynamic key value. public class MyVO{ private int id; private Map<String,String> properties; // getters and setters ... } Table design : ID | type | value | ------------------------ 1 | xx | val1 | 1 | xy | val2 | 1 | yx | val3 | 1 | yy | val4 | <resultMap class="MyVO" id="map1"> <result property="id" column="ID"/> <result property="properties" resultMap="map2"/> </resultMap> <resultMap class="java.util.Map" id="map2"> ????? </resultMap> With the above table data I would like to have one MyVO object with a map containing the following (type column dictates map key): [ key="xx" value="val1" key="xy" value="val2" key="yx" value="val3" key="yy" value="val4" ] Cheers, Mike
