It's not a secret anymore!
The moose likes Object Relational Mapping and the fly likes iBatis SQLMap Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "iBatis SQLMap" Watch "iBatis SQLMap" New topic

iBatis SQLMap

Arjun Reddy
Ranch Hand

Joined: Nov 10, 2007
Posts: 629
Hi All,

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


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

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


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?


Be Humble... Be Nice.
Arjun Reddy
Ranch Hand

Joined: Nov 10, 2007
Posts: 629
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.


I agree. Here's the link:
subject: iBatis SQLMap
It's not a secret anymore!