Hah! I *knew* that this had to be basic and expected functionality and that I must have something configured in such a way as to confuse iBATIS. I just could not, for the life of me, see the problem. I did not get from the documentation the idea that specifying both the resultMap and class would be an issue, but in retrospect, it sounds reasonable.
I still have this idea that the InMemoryDataReader() constructor should not be incrementing the result map collection index without setting it back to where it started, but that isn't stopping me right now. Thanks again! Tony -----Original Message----- From: Miika Mäkinen [mailto:[EMAIL PROTECTED] Sent: Thursday, June 07, 2007 10:54 AM To: [email protected] Subject: Re: Exceptions loading an IList with an object graph I was wondering do you need both resultmap and resultclass defined in the select statements? On 6/7/07, Tony Selke <[EMAIL PROTECTED]> wrote: > I seem to be having a lot of trouble sending mail to the list these last > two days. If you see this more than once, I apologize. On my side, it > claims to be bounced due to an unknown user or rejected by a moderator > or it tells me I am not subscribed (at least two of which I don't > believe to be true). > > Tony > > ----- > > Okay, I have a problem that I just don't understand. As always, any > insight or help is *greatly* appreciated. > > The issue is directly related to result map properties or constructor > arguments that are classes (child objects). If I get a list of objects > with no child objects defined in the results, it works fine. If I get a > list of objects with a child object defined, but I limit the records > returned to those which have null values in the FK field, it works fine. > > > However, if my list of returned records contains even one record with an > actual FK value in the column defined in the result map as a child > object, I get the following error: > > System.NotImplementedException was unhandled > Message="The property 'GroupByPropertyNames' is not implemented." > Source="IBatisNet.DataMapper" > > This error is very misleading. I have spent some time combing through > the iBATIS code and I think I see what the problem is, but I don't > understand what's causing it. > > There are two primary symptoms here, of which one or both may be the > root cause (or may point someone with more in-depth iBATIS knowledge to > the root cause). > > My RequestScope._statement.ResultsMap collection contains 2 result maps. > The first one is the one I have defined in my SQL map file (see below). > The second one is of the type > IBatisNet.DataMapper.Configuration.ResultMapping.AutoResultMap, which > does not implement the GroupByPropertyNames property (hence the error > above). I didn't create this second result map and I don't know why it > is being added to the collection. I have included the pertinent SQL map > stuff below, in case someone can spot if/where I am including or > omitting attributes/tags that is causing this to happen. > > Second, when SelectStrategy.GetValue() makes its internal call to > SelectObjectStrategy.GetValue() the IDataReader instance is converted to > an InMemoryDataReader(). During the course of this conversion (in the > constructor), there is a call made to the > DataReaderDecorator.NextResult() function. This causes the next result > map in the RequestScope._statement.ResultsMap to become the current > result map. Since this result map is of type AutoResultMap, it throws > the above exception. > > It seems to me (with very limited insight and knowledge thus far) that I > need to find a way to prevent this AutoResultMap from being added to my > statement and/or the InMemoryDataReader() constructor needs to be > updated to put the current result map pointer back where it found it, > instead of incrementing it unnecessarily. > > Can anyone please provide any insight here? Am I on to something? If > so, what? If this is a problem with my sql maps, can you pointout where > I made the mistake? I am at my wit's end here. :-/ > > Thank you very much for your help! > > Tony > > ------- > C# Call > ------- > > TList<User> u = (TList<User>)_mapper.QueryForList<User>("GetAllUser", > null); > > ---------- > User Types > ---------- > > <alias> > <typeAlias alias="UserClass" > type="Entities.User, Entities" /> > <typeAlias alias="UserList" > type="Entities.TList`1[Entities.User], Entities" /> > </alias> > > ----------- > User Select > ----------- > > <select id="GetAllUser" resultMap="UserResult" > resultClass="UserClass" listClass="UserList"> > <![CDATA[ > SELECT USER_ID, > FIRST_NAME, > LAST_NAME, > DEPARTMENT_ID, > FACILITY_ID, > EMP_ID > FROM USER_T > ]]> > </select> > > --------------- > User Result Map > --------------- > > <resultMap id="UserResult" class="UserClass"> > <constructor> > <argument argumentName="userId" column="USER_ID" /> > <argument argumentName="firstName" column="FIRST_NAME" /> > <argument argumentName="lastName" column="LAST_NAME" /> > <argument argumentName="departmentId" column="DEPARTMENT_ID" > /> > <argument argumentName="facility" column="FACILITY_ID" > select="GetFacilityByPrimaryKey" /> > <argument argumentName="empId" column="EMP_ID" /> > </constructor> > </resultMap> > > -------------- > Facility Types > -------------- > > <alias> > <typeAlias alias="FacilityClass" > type="Entities.Facility, Entities" /> > <typeAlias alias="FacilityList" > type="Entities.TList`1[Entities.Facility], Entities" /> > </alias> > > ------------------- > Facility Result Map > ------------------- > > <resultMap id="FacilityResult" class="FacilityClass"> > <constructor> > <argument argumentName="facilityId" column="FACILITY_ID" /> > <argument argumentName="name" column="NAME" /> > <argument argumentName="description" column="DESCRIPTION" /> > </constructor> > </resultMap> > > ---------------------- > Facility Parameter Map > ---------------------- > > <parameterMap id="FacilityPkParams"> > <parameter property="FacilityId" column="FACILITY_ID" /> > </parameterMap> > > --------------- > Facility Select > --------------- > > <select id="GetFacilityByPrimaryKey" parameterMap="FacilityPkParams" > resultMap="FacilityResult" resultClass="FacilityClass" > listClass="FacilityList"> > <![CDATA[ > SELECT FACILITY_ID, > NAME, > DESCRIPTION > FROM FACILITY_T > WHERE FACILITY_ID = ? > ]]> > </select> > > > > > > > > >
