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)]

  1. 0

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

    Stack Overflow | 5 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)]
  2. 0

    JPA query for table with name user with Hibernate

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

    Automated exception search integrated into your IDE

  5. 0

    Spring boot + Hibernate - User is not mapped

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

    unexpected token: part near line 1, column 155 [SELECT NEW

    Stack Overflow | 2 years ago | Drew1208
    org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: part near line 1, column 155 [SELECT NEW com.htd.domain.ShopOrder(po.id, po.po_number, po.due_date, po_part.id, po_part.part_quantity, part.id, part.part_number, part.part_description part.plasma_hrs_per_part, part.grind_hrs_per_part, part.mill_hrs_per_part, part.brakepress_hrs_per_part) FROM com.htd.domain.Po po LEFT JOIN po.partList po_part LEFT JOIN po_part.part]

  1. MoYapro 1 times, last 2 weeks ago
  2. MoYapro 1 times, last 2 months ago
  3. marcbouvierdav 1 times, last 2 months ago
  4. davidvanlaatum 1 times, last 5 months ago
  5. tfr 1 times, last 4 months ago
30 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