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