Sorry, missed this reply. The SQL looks fine, try to reproduce the error with a minimalistic query, remove the includes and parameters and try it again. You could also try to reproduce it using plain JDBC.
Niels -----Original Message----- From: top de castro [mailto:[EMAIL PROTECTED] Sent: Thursday, January 10, 2008 6:22 PM To: [email protected] Subject: RE: nullValue for Boolean wrapper class property Here is the information on the select statement, less the sqlFragments which contain the column names. <select id="selectMemberWithDependentsById" parameterClass="java.util.HashMap" resultMap="memberWithDependents"> select <include refid="SqlFragment.memberFieldFragment"/>, <include refid="SqlFragment.dependentFieldFragment"/> from member, depend where mb_key = #memberId# and mb_key = dp_mb_key </select> --- top de castro <[EMAIL PROTECTED]> wrote: > 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 > > > ________________________________________________________________________ ____________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
