Looks good to me, can you enable debugging and see if the statement actually executes? Also, post the select statement that uses the ClueEntry result map and the corresponding Java-code.
Niels -----Original Message----- From: lihh [mailto:[EMAIL PROTECTED] Sent: donderdag 11 oktober 2007 21:14 To: [email protected] Subject: retrieve a list of strings, how? Hi all, I am very new on iBatis and I have searched this forum and followed few of the examples but still not able to get this to work. In my sqlmap I have this <resultMap id="ClueEntry" class="ClueEntry"> ... ... <result property="memberList" column="id" select="getMemberListById" /> </resultMap> <select id="getMemberListById" parameterClass="java.lang.String" resultClass="java.lang.String"> SELECT fullname FROM members where members.specialid = #id# </select> the id is a special id, multiple people can have the same id #, I verified the statement on the sql server and I got a list of 4 names. However, the result for memberList is always null. the ClueEntry class is like this: public ClueEntry { ... ... private List memberList = new ArrayList(); ... ... public List getMemberList () { return this.memberList ; } public void setMemberList (List memberList ) { this.memberList = memberList ; } ... ... } The ClueEntry class also contains other simple primitive types like string and integer and I can get the data into the resultmap without a problem. Can someone point out to me what have I done wrong here? Thank you very much for your help. -- View this message in context: http://www.nabble.com/retrieve-a-list-of-strings%2C-how--tf4609397.html# a13162784 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
