Please post the SQL in "Member.selectMemberWithDependentsById", I don't understand why setting the nullValue attribute would be of any relevance to the exception you're getting.
Niels -----Original Message----- From: top de castro [mailto:[EMAIL PROTECTED] Sent: Thursday, January 10, 2008 5:03 PM To: [email protected] Subject: RE: nullValue for Boolean wrapper class property 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
