hey all, i think i'm not doing something correctly. excuse me for the trace
but does anyone have an idea where i should start looking?
System.IndexOutOfRangeException: clazz_
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
at NHibernate.Driver.NHybridDataReader.GetOrdinal(String name)
at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name)
at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name,
ISessionImplementor session, Object owner)
at NHibernate.Loader.Loader.GetInstanceClass(IDataReader rs, Int32 i,
ILoadable persister, Object id, ISessionImplementor session)
at NHibernate.Loader.Loader.InstanceNotYetLoaded(IDataReader dr, Int32 i,
ILoadable persister, EntityKey key, LockMode lockMode, EntityKey
optionalObjectKey, Object optionalObject, IList hydratedObjects,
ISessionImplementor session)
at NHibernate.Loader.Loader.GetRow(IDataReader rs, ILoadable[] persisters,
EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey,
LockMode[] lockModes, IList hydratedObjects, 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)
NHibernate.ADOException: could not execute query
[
with Hierachy(Id, Title,
Summary,Purpose,IsDeleted,CreatedAt,Owner,Parent, Level)
as
(
select Id, Title,
Summary,Purpose,IsDeleted,CreatedAt,Owner,Parent, 0 as Level
from Items e
where e.Id = ?
union all
select e.Id, e.Title,
e.Summary,e.Purpose,e.IsDeleted,e.CreatedAt,e.Owner,e.Parent, eh.Level
+ 1
from Items e
inner join Hierachy eh
on e.Parent = eh.Id
)
select Id, Title,
Summary,Purpose,IsDeleted,CreatedAt,Owner,Parent
from Hierachy
where Level > 0 AND Title like ?
]
Name:rootid - Value:57 Name:searchtext - Value:%Title%
[SQL:
with Hierachy(Id, Title,
Summary,Purpose,IsDeleted,CreatedAt,Owner,Parent, Level)
as
(
select Id, Title,
Summary,Purpose,IsDeleted,CreatedAt,Owner,Parent, 0 as Level
from Items e
where e.Id = ?
union all
select e.Id, e.Title,
e.Summary,e.Purpose,e.IsDeleted,e.CreatedAt,e.Owner,e.Parent, eh.Level
+ 1
from Items e
inner join Hierachy eh
on e.Parent = eh.Id
)
select Id, Title,
Summary,Purpose,IsDeleted,CreatedAt,Owner,Parent
from Hierachy
where Level > 0 AND Title like ?
]
at NHibernate.Loader.Loader.DoList(ISessionImplementor session,
QueryParameters queryParameters)
at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session
, QueryParameters queryParameters)
at NHibernate.Loader.Loader.List(ISessionImplementor session,
QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session,
QueryParameters queryParameters)
at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery,
QueryParameters queryParameters, IList results)
at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec,
QueryParameters queryParameters, IList results)
at NHibernate.Impl.SessionImpl.List<T>(NativeSQLQuerySpecification spec,
QueryParameters queryParameters)
at NHibernate.Impl.SqlQueryImpl.List<T>()
thanks.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
