a build from the current trunk seems to have fixed this. On Tue, Jan 13, 2009 at 10:22 PM, Jan Limpens <[email protected]> wrote: > Since recently (trunk), now and then queries throw an error that > earlier never did: > > public IList<Category> GetCategoriesOfGroupWithKey(string key) > { > var hql = > "select distinct cats " + > "from Article as a " + > "left outer join a.Categories as cats " + > "where a.ProductGroup.Key = :key " + > "and a.IsDiscontinued = 0 " + > "and a.IsActive = 1"; > > var list = Session.CreateQuery(hql) > .SetString("key", key) > .List<Category>(); > return list; > } > > ADOException > > Message: > could not execute query > [ select distinct category2_.CategoryID as CategoryID4_, > category2_.Name as Name4_, category2_.BusinessKey as Business3_4_, > category2_.Description as Descript4_4_, category2_.Visible as > Visible4_ from xxx2.dbo.[Article] article0_ left outer join > xxx2.dbo.ArticleCategory categories1_ on > article0_.ArticleID=categories1_.ArticleID left outer join > xxx2.dbo.Category category2_ on > categories1_.CategoryID=category2_.CategoryID, xxx2.dbo.[ProductGroup] > productgro3_ where (productgro3_.businessk...@p1 and > article0_.ProductGroupID=productgro3_.ProductGroupID)and(article0_.IsDiscontinued=0 > )and(article0_.InStock=1 ) ] > Name:key - Value:adesivos > [SQL: select distinct category2_.CategoryID as CategoryID4_, > category2_.Name as Name4_, category2_.BusinessKey as Business3_4_, > category2_.Description as Descript4_4_, category2_.Visible as > Visible4_ from xxx2.dbo.[Article] article0_ left outer join > xxx2.dbo.ArticleCategory categories1_ on > article0_.ArticleID=categories1_.ArticleID left outer join > xxx2.dbo.Category category2_ on > categories1_.CategoryID=category2_.CategoryID, xxx2.dbo.[ProductGroup] > productgro3_ where (productgro3_.businessk...@p1 and > article0_.ProductGroupID=productgro3_.ProductGroupID)and(article0_.IsDiscontinued=0 > )and(article0_.InStock=1 )] > > > StackTrace: > at NHibernate.Loader.Loader.DoList(ISessionImplementor session, > QueryParameters queryParameters) in > c:\data\nhibernate\trunk\nhibernate\src\NHibernate\Loader\Loader.cs:line > 1713 > at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor > session, QueryParameters queryParameters) in > c:\data\nhibernate\trunk\nhibernate\src\NHibernate\Loader\Loader.cs:line > 1628 > at NHibernate.Loader.Loader.List(ISessionImplementor session, > QueryParameters queryParameters, ISet`1 querySpaces, IType[] > resultTypes) in > c:\data\nhibernate\trunk\nhibernate\src\NHibernate\Loader\Loader.cs:line > 1622 > at NHibernate.Hql.Classic.QueryTranslator.List(ISessionImplementor > session, QueryParameters queryParameters) in > c:\data\nhibernate\trunk\nhibernate\src\NHibernate\Hql\Classic\QueryTranslator.cs:line > 1287 > at NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters > queryParameters, ISessionImplementor session, IList results) in > c:\data\nhibernate\trunk\nhibernate\src\NHibernate\Engine\Query\HQLQueryPlan.cs:line > 226 > at NHibernate.Impl.SessionImpl.List(String query, QueryParameters > queryParameters, IList results) in > c:\data\nhibernate\trunk\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line > 517 > at NHibernate.Impl.SessionImpl.List[T](String query, > QueryParameters parameters) in > c:\data\nhibernate\trunk\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line > 496 > at NHibernate.Impl.QueryImpl.List[T]() in > c:\data\nhibernate\trunk\nhibernate\src\NHibernate\Impl\QueryImpl.cs:line > 94 > at xxx.Data.ProductGroupDao.GetCategoriesOfGroupWithKey(String key) > in C:\data\xxx\xxx.Data\ProductGroupDao.cs:line 88 > at xxx.Web.Site.MVC.Controllers.ProductGroupsController.DetailByKey(String > key, String[] categoryKeys, Decimal priceRangeUntil, Int32 pageOffset, > Int32 itemsPerPage) in > C:\data\xxx\xxx.Web.Site.MVC\Controllers\ProductGroupsController.cs:line > 61 > at xxx.Web.Site.MVC.Controllers.ProductGroupsController.DetailByKey(String > key) in > C:\data\xxx\xxx.Web.Site.MVC\Controllers\ProductGroupsController.cs:line > 22 > > Inner exception: > > SqlException > > Message: > Must declare the scalar variable "@p1". > > Does not seem to me I am doing something wrong here. Usually I can fix > that by using positional params, but it's akward, nonetheless. > Is this expected behavior? If I use this query directly in the > console, it works just nicely. Mind that it is angry about some > _scalar_ variable... >
-- Jan --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
