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 | 9 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

    Hibernate 3 rc1 breaks grouping by functions. It complains about finding an open paren after the 'group by'. http://forum.hibernate.org/viewtopic.php?t=939313 org.hibernate.hql.ast.QuerySyntaxError: unexpected token: ( near line 1, column 97 [select sum(t.clicks), date(t.date) from hdc.Tracker t where t.listing.merchant = ? group by date(t.date) order by sum(t.clicks)] at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:74) at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:214) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:127) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83) at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:414) at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:814) at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:850) at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41) at hdc.Test1.doTest5(Test1.java:241) at hdc.Test1.main(Test1.java:317) Caused by: line 1:97: unexpected token: ( at org.hibernate.hql.antlr.HqlBaseParser.groupByClause(HqlBaseParser.java:896) at org.hibernate.hql.antlr.HqlBaseParser.queryRule(HqlBaseParser.java:704) at org.hibernate.hql.antlr.HqlBaseParser.selectStatement(HqlBaseParser.java:227) at org.hibernate.hql.antlr.HqlBaseParser.statement(HqlBaseParser.java:150) at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:208) ... 8 more

    Hibernate JIRA | 1 decade ago | Jarod
    org.hibernate.hql.ast.QuerySyntaxError: unexpected token: ( near line 1, column 97 [select sum(t.clicks), date(t.date) from hdc.Tracker t where t.listing.merchant = ? group by date(t.date) order by sum(t.clicks)]
  4. 0

    Hibernate 3 rc1 breaks grouping by functions. It complains about finding an open paren after the 'group by'. http://forum.hibernate.org/viewtopic.php?t=939313 org.hibernate.hql.ast.QuerySyntaxError: unexpected token: ( near line 1, column 97 [select sum(t.clicks), date(t.date) from hdc.Tracker t where t.listing.merchant = ? group by date(t.date) order by sum(t.clicks)] at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:74) at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:214) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:127) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83) at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:414) at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:814) at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:850) at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41) at hdc.Test1.doTest5(Test1.java:241) at hdc.Test1.main(Test1.java:317) Caused by: line 1:97: unexpected token: ( at org.hibernate.hql.antlr.HqlBaseParser.groupByClause(HqlBaseParser.java:896) at org.hibernate.hql.antlr.HqlBaseParser.queryRule(HqlBaseParser.java:704) at org.hibernate.hql.antlr.HqlBaseParser.selectStatement(HqlBaseParser.java:227) at org.hibernate.hql.antlr.HqlBaseParser.statement(HqlBaseParser.java:150) at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:208) ... 8 more

    Hibernate JIRA | 1 decade ago | Jarod
    org.hibernate.hql.ast.QuerySyntaxError: unexpected token: ( near line 1, column 97 [select sum(t.clicks), date(t.date) from hdc.Tracker t where t.listing.merchant = ? group by date(t.date) order by sum(t.clicks)]

    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