ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From top de castro <rocieldecas...@yahoo.com>
Subject RE: nullValue for Boolean wrapper class property
Date Thu, 10 Jan 2008 16:03:19 GMT
Niels,

Thanks for the response.  

This exception is from the select query.  Here is the
method:

	public ArrayList
selectMemberWithDependentsById(String memberId) throws
DatabaseException {
		
		logger.debug("START -
selectMemberWithDependentsById");
		
		ArrayList members = null;
		String sql =
"Member.selectMemberWithDependentsById";
		
		Map map = new HashMap();
		map.put("memberId", memberId);
		
		try {
			members = (ArrayList)
SASqlMapClientFactory.getSqlMapClient().queryForList(sql,
map);
		} catch (SQLException sqlException){
			logger.error(sqlException.getMessage(),
sqlException);
			throw new DatabaseException("SQLException caught in
MemberDAOImpl.selectMemberWithDependentsById.",
sqlException);
		}
			
		logger.debug("END -
selectMemberWithDependentsById");
		
		return members;
	}

--- Niels Beekman <n.beekman@wis.nl> wrote:

> The code you posted is from a result map, the
> exception you're getting
> is probably coming from an insert or update, can you
> post the Java code
> involved and all relevant SQL?
> 
> Niels
> 
> -----Original Message-----
> From: top de castro
> [mailto:rocieldecastro@yahoo.com] 
> Sent: Thursday, January 10, 2008 4:40 PM
> To: user-java@ibatis.apache.org
> Subject: nullValue for Boolean wrapper class
> property
> 
> 
> I am using a TypeHandlerCallback to map a Boolean
> property to a DB2 character(1) field that contains
> 'T'
> or 'F'.   
> 
> I cannot get the nullValue property to return the
> value "F" when the database field value is NULL. 
> The
> exception is: 
> 
>     java.sql.SQLException: Unexpected value null
> found
> where T or F was expected. 
> 
> Neither of these work: 
>   <result property="cardRequested" column="dp_card"
> nullValue="F"/> 
>   <result property="cardRequested" column="dp_card"
> javaType="Boolean" jdbcType="CHARACTER"
> nullValue="F"/> 
> 
> Any help would be much appreciated! 
> 
> 
> 
>  
>
________________________________________________________________________
> ____________
> Looking for last minute shopping deals?  
> Find them fast with Yahoo! Search.
>
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
> 



      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ



Mime
View raw message