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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]
> Sent: Thursday, January 10, 2008 4:40 PM
> To: [email protected]
> 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
