Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

iBatis SQLMap

 
Arjun Reddy
Ranch Hand
Posts: 629
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 629
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.



 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic