iBatis SQLMap

[Arjun Reddy]

Hi All,

I am new to iBatis. Can someone please tell me what the bolded ones do in the below example?

1).
<sqlMap>

<resultMap id="map1" class="com.xyz.Messages">
<result property="fileName" column="FILE_NAME"/>
<result property="title" column="TITLE"/>
</resultMap>

<select id="getMessages" parameterClass="java.lang.String" resultMap="map1">
some select query
</select>

<sqlMap>

What is map1? Does the query result get stored in a map something? How do I view it or retrieve it? When I did search file for map1 (Took map1 here as an example) on Eclipse in my entire source code, I am unable to find it.

2). getSqlMapClientTemplate().queryForList(getMessages, key);

I know that the getMessages is the query name and using which a particular query is identified. But how is the key used? Can someone give a simple example?

Thanks

[Arjun Reddy]

Ok, For the first question, From what I read, resultMap is the one used to map our class's instance variables to the database columns. I used to think that the resultset values from executing the query will be stored in a map something. which is wrong.

For the second question,
key is used in the where clause of the query statement.

Please correct me if I am wrong.

Thanks.