RE: select statement problem

[Daniel Pitts]

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:[EMAIL PROTECTED]
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