Hello I could use some help. I am trying to load an idbag using a custom loader, and am having an issue with the syntax. The idbag has a Setting class which has two properties, a Value and a SettingDefinition.
SettingDefinition is a class which has some other properties. From what I can tell I should be using a load-collection for setting, and a return-join for the definition.
I am getting an error about the alias I am using in the return-join. Any help would be greatly appreciated
Hibernate version: 2.0.0 GA
Mapping documents:Code:
<idbag name="PersistedSettings" table="OrganizationSetting" generic="true" cascade="save-update" inverse="false" >
<collection-id column="Id" type="int">
<generator class="identity"/>
</collection-id>
<key column="OrganizationId" >
<column not-null="false" name="OrganizationId" />
</key>
<composite-element class="xxx.Setting, Cutter">
<property column="SettingValue" name="Value"/>
<many-to-one class="xxx.SettingDefinition" column="SettingId" name="Definition"/>
</composite-element>
<loader query-ref="Organization_GetSettings"/>
</idbag>
Code:
<sql-query name="Organization_GetSettings">
<load-collection alias="s" role="Organization.PersistedSettings">
<return-property name="element" column="OrganizationId"/>
<return-property name="element.id" column="OrganizationId"/>
</load-collection>
<return-join alias="sd" property="Definition" ></return-join>
SELECT {s}.Value as {s.Value}, {s}.Id as {s.Id},isnull({s}.OrganizationId,:Organizationid) as {s.OrganizationId},
{sd}.SettingId as {sd.SettingId}, {sd}.SettingKey as {sd.Key}, {sd}.Scope as {sd.Scope},{sd}.DefaultValue as {sd.Default}
FROM Setting {sd}
LEFT JOIN OrganizationSetting {s}
ON {sd}.SettingId={s}.SettingId
WHERE ISNULL(OrganizationId,:OrganizationId)=:OrganizationId
</sql-query>
</hibernate-mapping>
Full stack trace of any exception that occurs:
Quote:
Test method xxx.MembershipServiceTest.TestUserPersistanceBackingStore threw exception: NHibernate.MappingException: Role attribute for sql query return [alias=sd] not formatted correctly {owningAlias.propertyName}.
Quote:
NHibernate.Cfg.XmlHbmBinding.ResultSetMappingBinder.CreateJoinReturn(HbmReturnJoin returnJoinSchema)
NHibernate.Cfg.XmlHbmBinding.ResultSetMappingBinder.CreateQueryReturn(Object item, Int32 count)
NHibernate.Cfg.XmlHbmBinding.ResultSetMappingBinder.Create(String name, Object[] items)
b__0(IDictionary`2 )
NHibernate.Cfg.Configuration.SecondPassCompile()
NHibernate.Cfg.Configuration.BuildSessionFactory()
...
....
Name and version of the database you are using:MS SqlServer 2005
Login
FAQ
Search