Return-Path: 
 <user-java-return-14277-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 76595 invoked from network); 2 May 2008 03:41:13 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 2 May 2008 03:41:13 -0000
Received: (qmail 82053 invoked by uid 500); 2 May 2008 03:41:08 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 82036 invoked by uid 500); 2 May 2008 03:41:08 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 82025 invoked by uid 99); 2 May 2008 03:41:08 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 May 2008 20:41:08 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [63.249.95.37] (HELO mail.cruzio.com) (63.249.95.37)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 May 2008 03:40:15 +0000
Received: from [192.168.0.103] (dsl-63-249-97-217.cruzio.com [63.249.97.217])
	by mail.cruzio.com with ESMTP id m423eZ7M095291
	for <user-java@ibatis.apache.org>; Thu, 1 May 2008 20:40:35 -0700 (PDT)
Message-ID: <481A8DD4.60407@cruzio.com>
Date: Thu, 01 May 2008 20:43:16 -0700
From: Richard Yee <ryee@cruzio.com>
User-Agent: Thunderbird 1.4 (Windows/20050908)
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: DAO class not getting values from query
References: <004401c8abac$2a040410$13ed51c7@corp.ds.fedex.com>
In-Reply-To: <004401c8abac$2a040410$13ed51c7@corp.ds.fedex.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

David,
Since you are doing a join on the tables, I suggest either using column or columnIndex in your result tags but not both.
If you use column, you should change the select to 
<select id="getAirportList" resultMap="result">
	SELECT
		AIRPORT.AIRPORT_ID AS AIRPORT_ID,
		AIRPORT.IATA_CODE AS IATA_CODE,
		AIRPORT.ICAO_CODE AS ICAO_CODE,
		AIRPORT.LATITUDE AS LATITUDE,
		AIRPORT.LONGITUDE AS LONGITUDE,
		AIRPORT.START_DATE AS START_DATE,
		AIRPORT.END_DATE AS END_DATE,
		AIRPORT_NAME.NAME AS NAME
	FROM AIRPORT, AIRPORT_NAME
	WHERE AIRPORT.AIRPORT_ID = AIRPORT_NAME.AIRPORT_ID
		AND AIRPORT_NAME.MAIN_FLG = 1
	</select>


<sqlMap namespace="Airport">
	<resultMap id="result" class="domain.Airport">
		<result property="id" javaType="Integer" jdbcType="NUMBER"
column="AIRPORT_ID"/>
		<result property="iataCode" javaType="String"
jdbcType="CHAR(3)" column="IATA_CODE"/>
		<result property="icaoCode" javaType="String"
jdbcType="CHAR(4)" column="ICAO_CODE"/>
		<result property="latitude" javaType="Integer"
jdbcType="NUMBER" column="LATITUDE"/>
		<result property="longitude" javaType="Integer"
jdbcType="NUMBER" column="LONGITUDE"/>
		<result property="startDate" javaType="String"
jdbcType="TIMESTAMP" column="START_DATE"/>
		<result property="endDate" javaType="String"
jdbcType="TIMESTAMP" column="END_DATE"/>
		<result property="name" javaType="String"
jdbcType="VARCHAR2" column="NAME"/>
	</resultMap>

Use of the jdbcType attribute is also not really necessary in this case either.

-Richard



David Momper wrote:
> Hi all,
> I have a page that displays a list or airports from a database query.  The
> page displays the correct database values from some fields, null values from
> others. Through debugging, I have figured out that the fields that display
> as null are never set to begin with, but as best I can tell, they should be.
>
> Some of the fields with problems are identical in structure to fields with
> no problems. Latitude/longitude, and airport id are all Integers in my java
> class, and are NUMBER in Oracle.  Lat/lon get proper values, id remains
> null.  Of the fields I query, only latitude, longitude, and name get
> non-null values.  I have verified that if I directly perform the query
> against the database, all proper values are returned, so the query is not my
> problem.  I suspect that the problem lies in my resultMap, but I haven't
> been able to figure out what is wrong there.
>
> I use Ibatis and Spring, with an Oracle 10g database. Relevant code is
> included below.  Any help would be greatly appreciated.
>
> The SQL map xml file:
> <sqlMap namespace="Airport">
> 	<resultMap id="result" class="domain.Airport">
> 		<result property="id" javaType="Integer" jdbcType="NUMBER"
> column="AIRPORT_ID" columnIndex="1"/>
> 		<result property="iataCode" javaType="String"
> jdbcType="CHAR(3)" column="IATA_CODE" columnIndex="2"/>
> 		<result property="icaoCode" javaType="String"
> jdbcType="CHAR(4)" column="ICAO_CODE" columnIndex="3"/>
> 		<result property="latitude" javaType="Integer"
> jdbcType="NUMBER" column="LATITUDE" columnIndex="4"/>
> 		<result property="longitude" javaType="Integer"
> jdbcType="NUMBER" column="LONGITUDE" columnIndex="5"/>
> 		<result property="startDate" javaType="String"
> jdbcType="TIMESTAMP" column="START_DATE" columnIndex="6"/>
> 		<result property="endDate" javaType="String"
> jdbcType="TIMESTAMP" column="END_DATE" columnIndex="7"/>
> 		<result property="name" javaType="String"
> jdbcType="VARCHAR2" column="NAME" columnIndex="8"/>
> 	</resultMap>
> 	<select id="getAirportList" resultClass="domain.Airport">
> 	SELECT
> 		AIRPORT.AIRPORT_ID,
> 		AIRPORT.IATA_CODE,
> 		AIRPORT.ICAO_CODE,
> 		AIRPORT.LATITUDE,
> 		AIRPORT.LONGITUDE,
> 		AIRPORT.START_DATE,
> 		AIRPORT.END_DATE,
> 		AIRPORT_NAME.NAME
> 	FROM AIRPORT, AIRPORT_NAME
> 	WHERE AIRPORT.AIRPORT_ID = AIRPORT_NAME.AIRPORT_ID
> 		AND AIRPORT_NAME.MAIN_FLG = 1
> 	</select>
> </sqlMap>
>
> AirportSqlMapDao class has:
> public List<Airport> getAirportList() {
> 	return
> (List<Airport>)getSqlMapClientTemplate().queryForList("getAirportList");
> }
>
> The fields from the Airport class.  Getter/setter methods are typical
> getter/setters.
> private Integer id;
> 	private String name;
> 	private String iataCode;
> 	private String icaoCode;
> 	private Integer latitude;
> 	private Integer longitude;
> 	private String startDate, endDate;
>
>
> My manager class:
> public class SimpleAirportManager implements AirportManager {
> private AirportDao airportDao;
>     public List<Airport> getAirports() {
>         return airportDao.getAirportList();
>     }
>     public void setAirportDao(AirportDao airportDao) {
>         this.airportDao = airportDao;
>     }
> }
>
> My controller has the code:
> public ModelAndView handleRequest(HttpServletRequest request,
> HttpServletResponse response) throws ServletException, IOException {
>         Map<String, Object> myModel = new HashMap<String, Object>();
>         myModel.put("airports", this.airportManager.getAirports());
>         return new ModelAndView("hello", "model", myModel);
> }
>
> This is the code from the display page:
> <table border=1>
> <tr><td>ID</td><td>Name</td><td>IATA code</td><td>ICAO
> code</td><td>Latitude</td><td>Longitude</td><td>Start Date</td><td>End
> Date</td></tr>
> <c:forEach items="${model.airports}" var="arpt">
> <tr>
> <td><c:out value="${arpt.id}"/></td>
> <td><c:out value="${arpt.name}"/></td>
> <td><c:out value="${arpt.iataCode}"/></td>
> <td><c:out value="${arpt.icaoCode}"/></td>
> <td><c:out value="${arpt.latitude}"/></td>
> <td><c:out value="${arpt.longitude}"/></td>
> <td><c:out value="${arpt.startDate}"/></td>
> <td><c:out value="${arpt.endDate}"/></td>
> </tr>
> </c:forEach>
> </table>
>
>
>