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
