org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: where near line 1, column 206 [select distinct generatedAlias0 from de.mexchange.packagingdb.entity.Employee as generatedAlias0 where exists (select distinct treat(generatedAlias0 as de.mexchange.packagingdb.entity.EmployeeThird) from where treat(generatedAlias0 as de.mexchange.packagingdb.entity.EmployeeThird).other like :param0)]

tip
Do you find the tips below useful? Click on the to mark them and say thanks to rafael . Or join the community to write better ones.
  1. 0
    samebug tip
    Your code probably has some syntax issue with how you're making the query request, more on this here: goo.gl/9wtLyd If your problem wasn't solved by that link, check this one as well: https://goo.gl/zBTzbl
  2. 0

    JPA: Specificaation api Cannot load entity by field from child class in JOINED inheritance

    Stack Overflow | 9 months ago | Seryozha Hovhannisyan
    org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: where near line 1, column 206 [select distinct generatedAlias0 from de.mexchange.packagingdb.entity.Employee as generatedAlias0 where exists (select distinct treat(generatedAlias0 as de.mexchange.packagingdb.entity.EmployeeThird) from where treat(generatedAlias0 as de.mexchange.packagingdb.entity.EmployeeThird).other like :param0)]
  3. 0

    JPA query for table with name user with Hibernate

    Stack Overflow | 12 months ago | dur
    org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: [ near line 1, column 29 [select generatedAlias0 from [user] as generatedAlias0]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1

    Stack Overflow | 1 year ago | Crazy Coder
    org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1, column 8 [SELECT * FROM com.rhcloud.giveme.entity.User u WHERE u.email = :email]
  6. 0

    Spring boot + Hibernate - User is not mapped

    codegur.online | 9 months ago
    org.hibernate.hql.internal.ast.QuerySyntaxException: User is not mapped

  1. richard77 1 times, last 4 months ago
  2. MoYapro 2 times, last 4 months ago
  3. marcbouvierdav 1 times, last 6 months ago
  4. davidvanlaatum 1 times, last 10 months ago
  5. tomthomas 50 times, last 1 month ago
1 more registered users
31 unregistered visitors
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.internal.ast.QuerySyntaxException

    unexpected token: where near line 1, column 206 [select distinct generatedAlias0 from de.mexchange.packagingdb.entity.Employee as generatedAlias0 where exists (select distinct treat(generatedAlias0 as de.mexchange.packagingdb.entity.EmployeeThird) from where treat(generatedAlias0 as de.mexchange.packagingdb.entity.EmployeeThird).other like :param0)]

    at org.hibernate.hql.internal.ast.QuerySyntaxException.convert()
  2. Hibernate
    SessionImpl.createQuery
    1. org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:91)
    2. org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:109)
    3. org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:304)
    4. org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:203)
    5. org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
    6. org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:131)
    7. org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:93)
    8. org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
    9. org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
    10. org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
    11. org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1836)
    11 frames
  3. org.hibernate.jpa
    AbstractEntityManagerImpl.createQuery
    1. org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:568)
    1 frame