File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Author

iBatis SQLMap

Arjun Reddy
Ranch Hand

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


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

Joined: Nov 10, 2007
Posts: 627
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
 
subject: iBatis SQLMap
 
Similar Threads
Bean creation Exception
Struts 2 - Ibatis - complex collection
Metro-iBATIS Problem while deploying web service using iBatis as mapping techonlogy.
iBatis and Bidirectional Association
Struts 2 - IBatis - MySQL combination