You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Jeff Butler (JIRA)" <ib...@incubator.apache.org> on 2006/06/08 19:40:30 UTC
[jira] Commented: (IBATIS-294) SQL with complex collection
properties not executing
[ 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