The query runs correctly. Namaspaces looks like correct,?
On 9/9/06, Daniel Pitts <Daniel.Pitts@cnet.com> wrote:
>
> Try executing the query manually in an sql client. Do you get any
> results?
> If not, thats your problem.
> Also, make sure you're using namespaces properly.
>
> ------------------------------
> *From:* Okan Çetin [mailto:okancetin@gmail.com]
> *Sent:* Friday, September 08, 2006 1:12 PM
> *To:* user-java@ibatis.apache.org
> *Subject:* select statement problem
>
> 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
>
--
~
otomatik oluşturuldu:
http://ocetin.net/log
http://linux.beykent.edu.tr
|