[ 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
