Return-Path: 
 <dev-return-2672-apmail-ibatis-dev-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-dev-archive@www.apache.org
Received: (qmail 92183 invoked from network); 12 May 2006 01:28:25 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 12 May 2006 01:28:25 -0000
Received: (qmail 55134 invoked by uid 500); 12 May 2006 01:28:05 -0000
Delivered-To: apmail-ibatis-dev-archive@ibatis.apache.org
Received: (qmail 53653 invoked by uid 500); 12 May 2006 01:27:40 -0000
Mailing-List: contact dev-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@ibatis.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@ibatis.apache.org>
List-Post: <mailto:dev@ibatis.apache.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: dev@ibatis.apache.org
Delivered-To: mailing list dev@ibatis.apache.org
Received: (qmail 53067 invoked by uid 99); 12 May 2006 01:27:31 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 May 2006 18:27:31 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received: from [209.237.227.198] (HELO brutus.apache.org) (209.237.227.198)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 May 2006 15:17:28 -0700
Received: from brutus (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id 6263D7142E8
	for <dev@ibatis.apache.org>; Thu, 11 May 2006 22:17:08 +0000 (GMT)
Message-ID: <29711520.1147385828400.JavaMail.root@brutus>
Date: Thu, 11 May 2006 22:17:08 +0000 (GMT+00:00)
From: "Mark H. Land (JIRA)" <ibatis-dev@incubator.apache.org>
To: dev@ibatis.apache.org
Subject: [jira] Created: (IBATIS-294) SQL with complex collection properties
 not executing
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

SQL with complex collection properties not executing
----------------------------------------------------

         Key: IBATIS-294
         URL: http://issues.apache.org/jira/browse/IBATIS-294
     Project: iBatis for Java
        Type: Bug

  Components: SQL Maps  
    Versions: 2.1.7    
 Environment: Windows XP, Java 1.4.2_09, AMD Athlon 2500+, 1GB ram, MS SQL Server 2000
    Reporter: Mark H. Land


As noted in the snippet below, all of the SQL statements to generate the beans are being executed EXCEPT for the "noteList" property.  No SQL is reaching the server for this.  The itemResult is being populated correctly in the application except for the collection of notes (defined with proper getters and setters in the ItemBean as     private Collection noteList; ).


>From this result-map definition:
    <result-map 
		name="itemWithDependentObjectsResult" 
		class="com.esm.model.expense.ItemBean" 
		extends="itemResult">
<!-- generated SQL statement below not executing! -->
			<property 
				name="noteList" 
				column="{targetUid=uid, relType=itemType1}" 				
				mapped-statement="EventLog.getEventLogListByTargetUid" 
				lazy-load="false" />
<!-- generated SQL statements below are executing -->
			<property 
				name="department" 
				column="groupDepartmentUidFk" 
				mapped-statement="Item.getItemGroupByUid" 
				lazy-load="false" />
			<property 
				name="division" 
				column="groupDivisionUidFk" 
				mapped-statement="Item.getItemGroupByUid" 
				lazy-load="false" />
			<property 
				name="paymentMethod" 
				column="groupPaymentMethodUidFk" 
				mapped-statement="Item.getItemGroupByUid" 
				lazy-load="false" />
			<property 
				name="vendorCompany" 
				column="companyVendorUidFk" 
				mapped-statement="Company.getCompanyByUid" 
				lazy-load="false" />
			<property 
				name="clientCompany" 
				column="companyClientUidFk" 
				mapped-statement="Company.getCompanyByUid" 
				lazy-load="false" />
			<property 
				name="category" 
				column="generalCategoryUidFk" 
				mapped-statement="Category.getCategoryByUid" 
				lazy-load="false" />
			<property 
				name="project" 
				column="projectUidFk" 
				mapped-statement="Item.getItemProjectByUid" 
				lazy-load="false" />
    </result-map>

The mapped-statement for noteList is:

    <mapped-statement 
		name="getEventLogListByTargetUid" 
		result-map="eventLogResult">
			select targetUid, 
			   actorUid, 
			   eventType, 
			   relType, 
			   eventDate, 
			   notes, 
			   createDate, 
			   modifiedDate, 
			   modifiedBy
			  from tblEventLog 
			where targetUid = #targetUid# 
			and relType = #relType# 
			order by eventDate
			-- getEventLogListByTargetUid
    </mapped-statement>	




-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira