I have the same problem in VisualStudio if a<5 can't compile. "The reason for this error was that the parameter must be surrounded by parenthesis, since it does not happen automatically"
2009/12/14 Darius Damalakas <[email protected]> > I had the same issue just now. The HQL query in question was: > select qg > from QuestionGroup qg > inner join qg.SurveyItems as si > inner join si.SurveyPage as sp > inner join sp.Survey as survey > where survey.ID in :surveyIds > > And i got also NHibernate.Hql.Ast.ANTLR.QuerySyntaxException : > Exception of type 'Antlr.Runtime.NoViableAltException' was thrown. > near line 7, column 23. > > Of course, this type of exception simply does not help to understand > what is actually wrong here. A more specific exception would help. > The reason for this error was that the parameter must be surrounded by > parenthesis, since it does not happen automatically > > The working query looks like this: > select qg > from QuestionGroup qg > inner join qg.SurveyItems as si > inner join si.SurveyPage as sp > inner join sp.Survey as survey > where survey.ID in (:surveyIds) > > > Hope that gives some ideas. > > > > > > On 3 Gruo, 23:23, "Dotan N." <[email protected]> wrote: > > sorry to bring this up but i'm having similar issues with the suggested > fix: > > > > Session.Delete(string.Format("from Tokens where UserId = {0}", userId)); > > > > same exception. any idea? > > > > On Thu, Aug 6, 2009 at 6:17 AM, adressin <[email protected]> wrote: > > > > > Duh... thanks for the extra eyes! > > > > > -Aaron > > > > > On Aug 5, 7:17 pm, Fabio Maulo <[email protected]> wrote: > > > > I have done thisThe exception say " near line 1, column 7" > > > > and I found > > > > "SELECT from" > > > > That is a clear wrong HQL since between "SELECT" and "from" you put > what > > > you > > > > are selecting or you should start directly with "from". > > > > > > 2009/8/5 adressin <[email protected]> > > > > > > > Hello, > > > > > > > I just upgraded to NHibernate 2.1 and am now getting an error on a > > > > > query that use to work. Any ideas? Thanks in advance. > > > > > > > -Aaron > > > > > > > NHibernate.Hql.Ast.ANTLR.QuerySyntaxException: Exception of type > > > > > 'Antlr.Runtime.NoViableAltException' was thrown. near line 1, > column 7 > > > > > [SELECT from Tradewinds.Samms.Core.Domain.TransactionHeader as > tHeader > > > > > where tHeader in ( SELECT DISTINCT tDetail.TransactionHeader from > > > > > Tradewinds.Samms.Core.Domain.TransactionDetail as tDetail where > > > > > tDetail in (select tap.TransactionDetailRecord from > > > > > Tradewinds.Samms.Core.Domain.TransactionApprovalHistory as tap > where > > > > > tap.ApprovalStatus = :approvalStatus and > tap.RouteEntry.User.UsrCode > > > > > = :approver ) )] > > > > > at NHibernate.Hql.Ast.ANTLR.ErrorCounter.ThrowQueryException() > > > > > at NHibernate.Hql.Ast.ANTLR.HqlParseEngine.Parse() > > > > > at NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.Parse(Boolean > > > > > isFilter) > > > > > at NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.DoCompile > > > > > (IDictionary`2 replacements, Boolean shallow, String > collectionRole) > > > > > at NHibernate.Engine.Query.HQLQueryPlan..ctor(String hql, String > > > > > collectionRole, Boolean shallow, IDictionary`2 enabledFilters, > > > > > ISessionFactoryImplementor factory) > > > > > at NHibernate.Engine.Query.HQLQueryPlan..ctor(String hql, Boolean > > > > > shallow, IDictionary`2 enabledFilters, ISessionFactoryImplementor > > > > > factory) > > > > > at NHibernate.Engine.Query.QueryPlanCache.GetHQLQueryPlan(String > > > > > queryString, Boolean shallow, IDictionary`2 enabledFilters) > > > > > at NHibernate.Impl.AbstractSessionImpl.GetHQLQueryPlan(String > > > > > query, Boolean shallow) > > > > > at NHibernate.Impl.AbstractSessionImpl.CreateQuery(String > > > > > queryString) > > > > > > -- > > > > Fabio Maulo > > > --~--~---------~--~----~------------~-------~--~----~ > > > 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]<nhusers%[email protected]> > <nhusers%[email protected]<nhusers%[email protected]> > > > > > For more options, visit this group at > > >http://groups.google.com/group/nhusers?hl=en > > > -~----------~----~----~----~------~----~------~--~--- > > -- > > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > > -- Fabio Maulo -- 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.
