Return-Path: 
 <user-java-return-6605-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 45363 invoked from network); 4 Apr 2006 13:50:13 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 4 Apr 2006 13:50:13 -0000
Received: (qmail 22291 invoked by uid 500); 4 Apr 2006 13:50:05 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 22014 invoked by uid 500); 4 Apr 2006 13:50:03 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 22002 invoked by uid 99); 4 Apr 2006 13:50:03 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Apr 2006 06:50:03 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of larry.meadors@gmail.com
 designates 66.249.82.194 as permitted sender)
Received: from [66.249.82.194] (HELO xproxy.gmail.com) (66.249.82.194)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Apr 2006 06:50:02 -0700
Received: by xproxy.gmail.com with SMTP id i31so1001035wxd
        for <user-java@ibatis.apache.org>;
 Tue, 04 Apr 2006 06:49:41 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=sa0c1aiGzZab/1EuZ8yed96svCsrKBe6kT/riq6RamncWSRTAxLDagz0k34LXvQXKFuhdiXn24Wt0dqG/6mzjxRcM0OGh4nTMK0UWfePNU6+KUZNLqFAZmPSeBn4itfZQI2ZLtnkAu3wXpKb6Pwo+4ud0tQ9snvJxzGfdyRwlR0=
Received: by 10.70.105.4 with SMTP id d4mr2598830wxc;
        Tue, 04 Apr 2006 06:49:41 -0700 (PDT)
Received: by 10.70.74.19 with HTTP; Tue, 4 Apr 2006 06:49:41 -0700 (PDT)
Message-ID: <a10a823c0604040649g32aa74d6s799549487b7b064f@mail.gmail.com>
Date: Tue, 4 Apr 2006 07:49:41 -0600
From: "Larry Meadors" <lmeadors@apache.org>
Reply-To: lmeadors@apache.org
Sender: larry.meadors@gmail.com
To: user-java@ibatis.apache.org
Subject: Re: Complex Property is null
In-Reply-To: <15304.1144153535@www025.gmx.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <20291.1144152247@www025.gmx.net>
 <15304.1144153535@www025.gmx.net>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Very good debugging, and thanks for posting the solution. :-)

Larry


On 4/4/06, D. Richter <dr-ibatis@gmx.de> wrote:
> Ok, I found the mistake by myself. It is a type mismatch
> in the Person-Select. The db-type of id ist varchar, so the
> parameterClass must be string. Unfortunately no error or warning
> points to the mistake.
>
> Dennis
>
> > --- Urspr=FCngliche Nachricht ---
> > Von: "D. Richter" <dr-ibatis@gmx.de>
> > An: user-java@ibatis.apache.org
> > Betreff: Complex Property is null
> > Datum: Tue, 4 Apr 2006 14:04:07 +0200 (MEST)
> >
> > Hi,
> >
> > I have two classes:
> >
> > public class EMail
> > {
> >   private String id;
> >   private String subject;
> >   private Person from;
> >   ...
> > }
> >
> > public class Person
> > {
> >   private String id;
> >   private String name;
> >   ...
> > }
> >
> > and a configfile
> >
> > ...
> > <sqlMap namespace=3D"EMail">
> >
> > <resultMap id=3D"getEMailByIdResult" class=3D"EMail">
> >  <result property=3D"id" column=3D"id"/>
> >  <result property=3D"subject" column=3D"subject"/>
> >  <result property=3D"from" column=3D"from" select=3D"getPersonById"/>
> > </resultMap>
> >
> > <resultMap id=3D"getPersonByIdResult" class=3D"Person">
> >  <result property=3D"id" column=3D"id"/>
> >  <result property=3D"name" column=3D"name"/>
> > </resultMap>
> >
> > <select id=3D"getEMailById" resultMap=3D"getEMailByIdResult"
> > parameterClass=3D"int">
> >  SELECT id, subject, from
> >  FROM email
> >  WHERE id =3D #id#
> > </select>
> >
> > <select id=3D"getPersonById" resultMap=3D"getPersonByIdResult"
> > parameterClass=3D"int">
> >  SELECT id, name
> >  FROM person
> >  WHERE id =3D #id#
> > </select>
> >
> > </sqlMap>
> >
> > When I call queryForObject, I get the following logs:
> >
> > Created connection 17627854.
> > {conn-100000} Connection
> > {pstm-100001} PreparedStatement: SELECT id, subject, from FROM email WH=
ERE
> > id =3D ?
> > {pstm-100001} Parameters: [1]
> > {pstm-100001} Types: [java.lang.Integer]
> > {rset-100002} ResultSet
> > {pstm-100003} PreparedStatement: SELECT id, name FROM person WHERE id =
=3D ?
> > {pstm-100003} Parameters: [96]
> > {pstm-100003} Types: [java.lang.Integer]
> > {rset-100004} ResultSet
> > {rset-100002} Header: [mata_id, mata_vbetrag, mata_vwbezk, mata_zpkey]
> > {rset-100002} Result: [1, A_subject, 96]
> > Returned connection 17627854 to pool.
> >
> > No error/exception occurs, but the property 'from' in the instance of
> > 'EMail' is still null. Can anyone help me to find the mistake?
> >
> > Thank you
> > Dennis
> >
> > --
> > Analog-/ISDN-Nutzer sparen mit GMX SmartSurfer bis zu 70%!
> > Kostenlos downloaden: http://www.gmx.net/de/go/smartsurfer
> >
>
> --
> "Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ...
> Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail
>