ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Closed: (IBATIS-294) SQL with complex collection properties not executing
Date Mon, 14 Aug 2006 04:48:14 GMT
     [ http://issues.apache.org/jira/browse/IBATIS-294?page=all ]

Clinton Begin closed IBATIS-294.
--------------------------------

    Resolution: Invalid
      Assignee: Clinton Begin

> SQL with complex collection properties not executing
> ----------------------------------------------------
>
>                 Key: IBATIS-294
>                 URL: http://issues.apache.org/jira/browse/IBATIS-294
>             Project: iBatis for Java
>          Issue Type: Bug
>          Components: SQL Maps
>    Affects 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
>         Assigned To: Clinton Begin
>
> 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

        

Mime
View raw message