这个错误怎么解决，高手进来。
用户代码未处理 NHibernate.Exceptions.GenericADOExceptionMessage=could not execute query
[ SELECT TOP (@p0) ID3_, Title3_, Body3_, Creator3_, DateCrea5_3_, Publisher3_, DateLast7_3_, Statuses3_, Resource9_3_, Resourc10_3_, Resourc11_3_ FROM (select comment0_.ID as ID3_, comment0_.Title as Title3_, comment0_.Body as Body3_, comment0_.Creator as Creator3_, comment0_.DateCreated as DateCrea5_3_, comment0_.Publisher as Publisher3_, comment0_.DateLastPublished as DateLast7_3_, comment0_.Statuses as Statuses3_, comment0_.ResourceKey as Resource9_3_, comment0_.ResourceOwnerKey as Resourc10_3_, comment0_.ResourceNodeType as Resourc11_3_, ROW_NUMBER() OVER(ORDER BY comment0_.DateCreated DESC) as __hibernate_sort_row from Comments comment0_ where comment0_.ResourceKey=@p1 and comment0_.Statuses=@p2) as query WHERE query.__hibernate_sort_row > @p3 ORDER BY query.__hibernate_sort_row ]
Name:p1 - Value:2013050716303200002 Name:p2 - Value:2 Name:p3 - Value:0 Name:p4 - Value:10
[SQL: SELECT TOP (@p0) ID3_, Title3_, Body3_, Creator3_, DateCrea5_3_, Publisher3_, DateLast7_3_, Statuses3_, Resource9_3_, Resourc10_3_, Resourc11_3_ FROM (select comment0_.ID as ID3_, comment0_.Title as Title3_, comment0_.Body as Body3_, comment0_.Creator as Creator3_, comment0_.DateCreated as DateCrea5_3_, comment0_.Publisher as Publisher3_, comment0_.DateLastPublished as DateLast7_3_, comment0_.Statuses as Statuses3_, comment0_.ResourceKey as Resource9_3_, comment0_.ResourceOwnerKey as Resourc10_3_, comment0_.ResourceNodeType as Resourc11_3_, ROW_NUMBER() OVER(ORDER BY comment0_.DateCreated DESC) as __hibernate_sort_row from Comments comment0_ where comment0_.ResourceKey=@p1 and comment0_.Statuses=@p2) as query WHERE query.__hibernate_sort_row > @p3 ORDER BY query.__hibernate_sort_row]
Source=NHibernate
SqlString=SELECT TOP (@p0) ID3_, Title3_, Body3_, Creator3_, DateCrea5_3_, Publisher3_, DateLast7_3_, Statuses3_, Resource9_3_, Resourc10_3_, Resourc11_3_ FROM (select comment0_.ID as ID3_, comment0_.Title as Title3_, comment0_.Body as Body3_, comment0_.Creator as Creator3_, comment0_.DateCreated as DateCrea5_3_, comment0_.Publisher as Publisher3_, comment0_.DateLastPublished as DateLast7_3_, comment0_.Statuses as Statuses3_, comment0_.ResourceKey as Resource9_3_, comment0_.ResourceOwnerKey as Resourc10_3_, comment0_.ResourceNodeType as Resourc11_3_, ROW_NUMBER() OVER(ORDER BY comment0_.DateCreated DESC) as __hibernate_sort_row from Comments comment0_ where comment0_.ResourceKey=@p1 and comment0_.Statuses=@p2) as query WHERE query.__hibernate_sort_row > @p3 ORDER BY query.__hibernate_sort_row
StackTrace:
在 NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
在 NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
在 NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
在 NHibernate.Hql.Ast.ANTLR.Loader.QueryLoader.List(ISessionImplementor session, QueryParameters queryParameters)
在 NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor session, QueryParameters queryParameters)
在 NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters queryParameters, ISessionImplementor session, IList results)
在 NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression, QueryParameters queryParameters, IList results)
在 NHibernate.Impl.AbstractSessionImpl.List(IQueryExpression queryExpression, QueryParameters parameters)
在 NHibernate.Impl.ExpressionQueryImpl.List()
在 NHibernate.Linq.DefaultQueryProvider.ExecuteQuery(NhLinqExpression nhLinqExpression, IQuery query, NhLinqExpression nhQuery)
在 NHibernate.Linq.DefaultQueryProvider.Execute(Expression expression)
在 NHibernate.Linq.DefaultQueryProvider.Execute[TResult](Expression expression)
在 Remotion.Linq.QueryableBase`1.GetEnumerator()
在 System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
在 System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
在 Apworks.Repositories.NHibernate.NHibernateRepository`1.DoFindAll(ISpecification`1 specification, Expression`1 sortPredicate, SortOrder sortOrder, Int32 pageNumber, Int32 pageSize) 位置 D:\MyWork\Projects2013\Frameworks\Apworks\Apworks.2.5\Repositories\Apworks.Repositories.NHibernate\NHibernateRepository.cs:行号 185
在 Apworks.Repositories.Repository`1.FindAll(ISpecification`1 specification, Expression`1 sortPredicate, SortOrder sortOrder, Int32 pageNumber, Int32 pageSize) 位置 D:\MyWork\Projects2013\Frameworks\Apworks\Apworks.2.5\Apworks\Repositories\Repository.cs:行号 756
在 NSmart.Modules.Comments.Impl.CommentApplicationImpl.GetCommentsByResourceKeyWithPaging(String resourceKey, Expression`1 sortPredicate, SortOrder sortOrder, Int32 pageNo, Int32 pageSize, Int32& total)
在 NSmart.MVC.Controllers.CoreFrontController.ListComments(String viewName, String resourceKey, Int32 pageNo, Int32 pageSize)
在 lambda_method(Closure , ControllerBase , Object[] )
在 System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
在 System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
在 System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
在 System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12()
在 System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
InnerException: System.InvalidOperationException
Message=阅读器关闭时尝试调用 Read 无效。
Source=System.Data
StackTrace:
在 System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
在 System.Data.SqlClient.SqlDataReader.Read()
在 NHibernate.Driver.NHybridDataReader.Read()
在 NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
在 NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
在 NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
InnerException:
--------------------编程问答-------------------- 用户代码未处理 NHibernate.Exceptions.GenericADOException
Message=could not execute query
无法执行查询 将语句提出来放到数据库执行看看。 --------------------编程问答-------------------- HQL查询语句有问题。。
代码呢？ --------------------编程问答-------------------- 主要原因是 参数索引不正确， sql 中需要从@p0开始，但是 hibernate自己生成的参数列表却从@p1 开始了。 --------------------编程问答-------------------- 用户代码未处理 NHibernate.Exceptions.GenericADOException
Message=could not execute query
[ SELECT TOP (@p0) ID3_, Title3_, Body3_, Creator3_, DateCrea5_3_, Publisher3_, DateLast7_3_, Statuses3_, Resource9_3_, Resourc10_3_, Resourc11_3_ FROM (select comment0_.ID as ID3_, comment0_.Title as Title3_, comment0_.Body as Body3_, comment0_.Creator as Creator3_, comment0_.DateCreated as DateCrea5_3_, comment0_.Publisher as Publisher3_, comment0_.DateLastPublished as DateLast7_3_, comment0_.Statuses as Statuses3_, comment0_.ResourceKey as Resource9_3_, comment0_.ResourceOwnerKey as Resourc10_3_, comment0_.ResourceNodeType as Resourc11_3_, ROW_NUMBER() OVER(ORDER BY comment0_.DateCreated DESC) as __hibernate_sort_row from Comments comment0_ where comment0_.ResourceKey=@p1 and comment0_.Statuses=@p2) as query WHERE query.__hibernate_sort_row > @p3 ORDER BY query.__hibernate_sort_row ]
Name:p1 - Value:2013050716303200002 Name:p2 - Value:2 Name:p3 - Value:0 Name:p4 - Value:10 --------------------编程问答-------------------- 不要沉了。。。
补充：.NET技术 , ASP.NET
