Return-Path: 
 <user-java-return-6463-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 51696 invoked from network); 21 Mar 2006 17:33:25 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 21 Mar 2006 17:33:25 -0000
Received: (qmail 47366 invoked by uid 500); 21 Mar 2006 17:33:23 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 47339 invoked by uid 500); 21 Mar 2006 17:33:23 -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 47327 invoked by uid 99); 21 Mar 2006 17:33:23 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Mar 2006 09:33:23 -0800
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [83.247.21.91] (HELO wis.nl) (83.247.21.91)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Mar 2006 09:33:18 -0800
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Complex property question
X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0
Date: Tue, 21 Mar 2006 18:32:40 +0100
Message-ID: <50CA25BD6EEA954FA592C097399942E30E4638E2@CM1.wis.local>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Complex property question
Thread-Index: AcZMRVsSO5QLQ5eqSlWLhoLJrZN7ngAC0AcgAAWunyAABSbCYAAi6VcQAAEhR4A=
From: "Niels Beekman" <n.beekman@wis.nl>
To: "Voorhoeve, Niels {PBG}" <niels.voorhoeve@pepsi.com>
Cc: <user-java@ibatis.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hi,

You defined the following:

<resultMap class=3D"PurchaseHeader" id=3D"PurchaseHeader-report"
extends=3D"PurchaseHeader-result">
  <result property=3D"shipToAddress" column=3D"ship_to_address"
select=3D"PurchaseHdrAddr.getPurchaseHdrAddr_shipTo"/>
... some more
</resultMap>

When you access the 'shipToAddress' property, iBATIS passes the value of
the specified column 'ship_to_address' to the specified select query '
PurchaseHdrAddr.getPurchaseHdrAddr_shipTo'. This value is as far as I
can see a java.lang.String.

The definition of 'PurchaseHdrAddr.getPurchaseHdrAddr_shipTo' specifies
'PurchaseHdrAddr' as parameterClass, this is not correct and should be
java.lang.String, hence iBATIS complains about not being able to access
property 'orderNo' from your java.lang.String parameter.

Changing value of parameterClass should fix the problem, or if you need
that select to get shipping address of a PurchaseHdrAddr-class,
introduce a new select.

Niels

BTW 'single column could be the source
for several properties' should work just fine...

-----Original Message-----
From: Voorhoeve, Niels {PBG} [mailto:niels.voorhoeve@pepsi.com]=20
Sent: dinsdag 21 maart 2006 17:56
To: Niels Beekman
Subject: RE: Complex property question

What's up Niels?  I was hoping that a single column could be the source
for several properties, but it seems not.  Sometimes it seems like the
documentation is a bit lacking as far as proscribing the limits of what
can be accomplished.  Here's the subselect nonetheless:

Cheers,
Niels

    <resultMap class=3D"PurchaseHdrAddr" id=3D"PurchaseHdrAddr-result" >
        <result=20
                property=3D"orderNo"=20
                javaType=3D"java.lang.String"
                column=3D"order_no"=20
        />
        <result=20
                property=3D"addressType"=20
                javaType=3D"java.lang.String"
                column=3D"address_type"=20
        />
	  ...
    </resultMap>


    <select id=3D"getPurchaseHdrAddr_shipTo"=20
    	parameterClass=3D"PurchaseHdrAddr"=20
    	resultMap=3D"PurchaseHdrAddr-result"=20
    	cacheModel=3D"PurchaseHdrAddr-cache">
        select * from PURCHASE_HDR_ADDR where address_type =3D 3
        <dynamic>
        	<isNotEmpty prepend=3D"and" property=3D"orderNo">
        		order_no =3D #orderNo#
        		</isNotEmpty>
        </dynamic>
    </select>=20

<snip>