ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Commented: (IBATIS-294) SQL with complex collection properties not executing
Date Thu, 08 Jun 2006 17:40:30 GMT
    [ http://issues.apache.org/jira/browse/IBATIS-294?page=comments#action_12415383 ] 

Jeff Butler commented on IBATIS-294:
------------------------------------

This looks like you are using iBATIS 1.x (or at least the 1.x DTD).  I'd recommend upgrading
to the latest version first to see if it fixes the problem.  There are test cases working
similary to this in iBATIS right now.


> 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


Mime
View raw message