org.hibernate.hql.ast.QuerySyntaxError: unexpected token: ( near line 1, column 49 [FROM Message AS msg GROUP BY month(msg.datecreated)

Hibernate JIRA | Christophe Gimenez | 1 decade ago
  1. 0

    [Closed] expecting IDENT, found '.' - Genuitec

    genuitec.com | 10 months ago
    org.hibernate.hql.ast.QuerySyntaxError: expecting IDENT, found ‘.’ near line 1, column 56 [from com.movilogic.hibernate.mappings.Planes p where p..codigo_servicio = ’12’ ]
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    org.hibernate.hql.ast.QuerySyntaxError: unexpected token:

    Coderanch | 4 years ago | raj chopra
    org.hibernate.hql.ast.QuerySyntaxError: unexpected token: ( near line 1, column 26 [select ORGNAME,VAL from ( select(count(o.organizationId ) * 100/ (select count(b.comp_id.bidId) from com.syntel.sb.appl.bo.vendor.SBBid b where b.client.clientId = 166 and b.deletionMark <>1 and b .bid_status_code = 50 )) as VAL ,org,o.organizationName as ORGNAME from com.syntel.sb.appl.bo.client.SBOrganization o , com.syntel.sb.appl. bo.client.SBMember m,com.syntel.sb.appl.bo.vendor.SBBid b ,com.syntel.sb.appl.bo.client.SBClient c where o.deletionMark =0 and m.deletionMa rk = 0 and b.bidStatus.code =50 and b.member.memberId =m.memberId and b.client.clientId = 166and c.clientId=b.client.clientId and c.deletion Mark<>1 and m.organizationId =o.organizationId group by o.organizationId,o.organizationName order by 1 desc ) where rownum <=10 ]
  4. 0

    Assigning values to a returned object from query

    Coderanch | 1 decade ago | Chris Boldon
    org.hibernate.hql.ast.QuerySyntaxError: unexpected token: new near line 1, column 64 [select projectOrganization, count(projectOrganization) as inc, new PortfolioCountImpl(portfolio,inc) from com.x.pmo.vo.ProjectImpl group by projectOrganization as organization]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.hibernate.hql.ast.QuerySyntaxError

      unexpected token: ( near line 1, column 49 [FROM Message AS msg GROUP BY month(msg.datecreated)

      at org.hibernate.hql.ast.ErrorCounter.throwQueryException()
    2. Hibernate HQL/JP-QL Parser
      QueryTranslatorImpl.compile
      1. org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:74)
      2. org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:214)
      3. org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:127)
      4. org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
      4 frames
    3. Hibernate
      QueryImpl.list
      1. org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:414)
      2. org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:814)
      3. org.hibernate.impl.SessionImpl.list(SessionImpl.java:773)
      4. org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
      4 frames