Return-Path: 
 <user-java-return-5436-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 71851 invoked from network); 6 Jan 2006 12:16:47 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 6 Jan 2006 12:16:47 -0000
Received: (qmail 79244 invoked by uid 500); 6 Jan 2006 12:16:43 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 78998 invoked by uid 500); 6 Jan 2006 12:16:41 -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 78701 invoked by uid 99); 6 Jan 2006 12:16:40 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Jan 2006 04:16:40 -0800
X-ASF-Spam-Status: No, hits=0.6 required=10.0
	tests=NO_REAL_NAME
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [141.228.156.166] (HELO oplss0036.barcap.com) (141.228.156.166)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Jan 2006 04:16:37 -0800
Received: from oplss0036.barcap.com (localhost [127.0.0.1])
	by oplss0036.barcap.com (8.12.10/8.11.4) with ESMTP id k06C3Prm002041
	for <user-java@ibatis.apache.org>; Fri, 6 Jan 2006 12:03:25 GMT
Received: from ldnpsmeg012.INTRANET.BARCAPINT.COM
 (ldnpsmeg012.nat.barcapint.com [172.23.1.202])
	by oplss0036.barcap.com (8.12.10/8.11.4) with ESMTP id k06C3MOc001977
	for <user-java@ibatis.apache.org>; Fri, 6 Jan 2006 12:03:22 GMT
Received: from LDNPSMEH004.INTRANET.BARCAPINT.COM (unverified) by
    ldnpsmeg012.INTRANET.BARCAPINT.COM (Content Technologies SMTPRS 4.3.10)
    with ESMTP id <T75ac0dfda31efd043bbf4@ldnpsmeg012.INTRANET.BARCAPINT.COM>
    for <user-java@ibatis.apache.org>; Fri, 6 Jan 2006 12:16:11 +0000
Received: from LDNPCMEU301VEUA.INTRANET.BARCAPINT.COM ([10.65.12.17]) by
    LDNPSMEH004.INTRANET.BARCAPINT.COM with Microsoft SMTPSVC (5.0.2195.6713)
    ; Fri, 6 Jan 2006 12:16:11 +0000
X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Struggling to load a complex property from a secondary table (a 1:N
    problem)
Date: Fri, 6 Jan 2006 12:16:11 -0000
Message-ID: 
 <D4E105722D20344AA9F50C624B1C24EE01105580@LDNPCMEU301VEUA.INTRANET.BARCAPINT.COM>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Struggling to load a complex property from a secondary table
    (a 1:N problem)
Thread-Index: AcYSuvsjjlSIyQujRB+UiMvQNsI4/w==
From: <Paul.Smith3@barclayscapital.com>
To: <user-java@ibatis.apache.org>
X-OriginalArrivalTime: 06 Jan 2006 12:16:11.0640 (UTC)
    FILETIME=[FB535F80:01C612BA]
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hi,

I am struggling with the following scenario. Basically I'm trying to get
iBatis to load a complex property (a list of int) from a secondary
table.

I have two tables, User and Permission. The pk of the User table
(UserId) is a fk in the Permission table, and there are many Permission
rows for each UserId. I am trying to get iBatis to perform the select
from the Permission table whenever a select is performed on the User
table, but I always get a 'Invalid column name' from the underlying jdbc
driver. I can't work out what query iBatis is trying to perform that is
yielding this error.

My SqlMap is setup so that the permissions property (a java.util.List of
java.lang.Integer) of the User resultMap is as follows:

<resultMap id=3D"UserResultMap" class=3D"User">
	<result property=3D"userId" column=3D"UserId"/>
	<result property=3D"permissions" column=3D"permissionId"
select=3D"findPermissionByUserId"/>
</resultMap>

The "findPermissionByUserId" select is defined as:

<select id=3D"findPermissionByUserId" parameterClass=3D"int"
resultClass=3D"int">
	select PermissionId as permissionId from Permissions where
UserId =3D #value#
</select>

The select is initaited from a "findUserById" select which is defined
as:

<select id=3D"findUserById" parameterClass=3D"int"
resultMap=3D"UserResultMap">
	select * from User where UserId =3D #value#
</select>

Any help is greatly appreciated.

Regards,

Paul Smith



------------------------------------------------------------------------
For more information about Barclays Capital, please
visit our web site at http://www.barcap.com.


Internet communications are not secure and therefore the Barclays=20
Group does not accept legal responsibility for the contents of this=20
message.  Although the Barclays Group operates anti-virus programmes,=20
it does not accept responsibility for any damage whatsoever that is=20
caused by viruses being passed.  Any views or opinions presented are=20
solely those of the author and do not necessarily represent those of the=20
Barclays Group.  Replies to this email may be monitored by the Barclays=20
Group for operational or business reasons.

------------------------------------------------------------------------