In case when I have used
{doc.*} - no errors but duplicates that I should clear manually (not
found way how to do this over config).
In case when I have tried
<sql-query name="ByIds">
<return alias="msg" class="Message"/>
<return-join alias="doc" property="msg.Documents"/>
SELECT msg.MESSAGE_ID as {msg.Id},
msg.SUBJECT as {msg.Subject},
doc.DOCUMENT_ID as {doc.element.Id},
doc.RECORD_ID as {doc.element.ParentId},
doc.FILE_NAME as {doc.element.FileName}
FROM TBL_MESSAGE msg
LEFT JOIN
TBL_DOCUMENT doc ON doc.RECORD_ID = msg.MESSAGE_ID
ORDER BY msg.SUBJECT
</sql-query>
following exception occurs (seem to me it needs some data for keys
selection but I don't know what kind of data)
[System.IndexOutOfRangeException] {"RECORD2_0__"}
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String
fieldName)
at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
at NHibernate.Driver.NHybridDataReader.GetOrdinal(String name)
NHybridDataReader.cs:line 363\
at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String
name) in NullableType.cs:line 236
at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String[]
names, ISessionImplementor session, Object owner) in
NullableType.cs:line 195
at
NHibernate.Persister.Collection.AbstractCollectionPersister.ReadKey(IDataReader
dr, String[] aliases, ISessionImplementor session)
at NHibernate.Loader.Loader.ReadCollectionElement(Object
optionalOwner, Object optionalKey, ICollectionPersister persister,
ICollectionAliases descriptor, IDataReader rs, ISessionImplementor
session)
at NHibernate.Loader.Loader.ReadCollectionElements(Object[] row,
IDataReader resultSet, ISessionImplementor session)
at NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet,
ISessionImplementor session, QueryParameters queryParameters,
LockMode[] lockModeArray, EntityKey optionalObjectKey, IList
hydratedObjects, EntityKey[] keys, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session,
QueryParameters queryParameters, Boolean returnProxies)
at
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor
session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoList(ISessionImplementor session,
QueryParameters queryParameters)
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
