ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: select statement problem
Date Fri, 08 Sep 2006 21:20:12 GMT
You do not have a resultClass in your <select> element.

Larry


On 9/8/06, Okan Çetin <okancetin@gmail.com> wrote:
> Hello;
> I could not getting something from db. list object does not contain any
> value.  Do you have any idea ?
> The code and xml map files:
>
> 1) Code
>
>             List list;
>             Reader reader =
> Resources.getResourceAsReader("com/data/SqlMapConfig.xml");
>             SqlMapClient sqlMapper =
> SqlMapClientBuilder.buildSqlMapClient (reader);
>             reader.close();
>
> //usr=(User)sqlMapper.queryForObject("selectAllUsers");
>             list=sqlMapper.queryForList("selectAllUsers");
>
>  2) User.xml
>
> <?xml version="1.0" encoding="UTF-8" ?>
>
>  <!DOCTYPE sqlMap
>     PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
>      "http://ibatis.apache.org/dtd/sql-map-2.dtd">
>
>  <sqlMap namespace="User">
>
>   <!-- Use type aliases to avoid typing the full classname every time. -->
>   <typeAlias alias="User" type="com.domain.User"/>
>
>    <!-- Result maps describe the mapping between the columns returned
>        from a query, and the class properties.  A result map isn't
>        necessary if the columns (or aliases) match to the properties
>         exactly. -->
>     <!--    <resultMap id="UserResult" class="User">
>          <result property="firstname" column="firstname"/>
>       </resultMap>
>    -->
>
>   <!-- Select with no parameters using the result map for Account class. -->
>   <select id="selectAllUsers" >
>     select firstname from PUBLIC.user
>   </select>
>
>  </sqlMap>
>
> 3) User.java
>
>  public class User {
>       private String firstname;
>       // getter, setter methods..
>
> Thanks for reply.
>
> --
> ~
> otomatik oluşturuldu:
> http://ocetin.net/log
>  http://linux.beykent.edu.tr
Mime
View raw message