I have a simple class
public class User {
private String name;
private List<String> roles;
//getters and setters
}
and want to populate a list of these it with the equally simple query
SELECT name,role FROM users LEFT JOIN roles USING (name)
I want to have some form of result map like this.
<resultMap id="full-user" class="user" groupBy="name" >
<result property="name" column="name"/>
<result property="roles" resultMap="User.role" />
</resultMap>
<resultMap id="role" class="string">
<result property=? column="role" />
</resultMap>
How do you define the property for the role column ?
It would be easy if the my roles List was something more complex than
List<String>, but I can't find any indication in the docs of how to deal with
this simple case
--
Alan Chandler
http://www.chandlerfamily.org.uk
Open Source. It's the difference between trust and antitrust.
