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

Reply via email to