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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Stack Overflow by Seryozha Hovhannisyan
, 1 year ago
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)]
via Stack Overflow by dur
, 1 year ago
unexpected token: [ near line 1, column 29 [select generatedAlias0 from [user] as generatedAlias0]
via Stack Overflow by Drew1208
, 2 years ago
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
via Stack Overflow by DieZZzz
, 1 year ago
unexpected token: by near line 1, column 102 [select employee.id, employee.surname, subject.name from by.bsuir.yegoretsky.model.Employee employee, by.bsuir.yegoretsky.model.Subject subject where employee.subject_id=subject.id]
via Hibernate JIRA by Etienne Miret, 1 year ago
unexpected token: ( near line 1, column 114 [select pet from org.hibernate.test.hql.Animal pet, org.hibernate.test.hql.Animal owner where pet member of treat (owner as Human).pets]
via Hibernate JIRA by Etienne Miret, 1 year ago
unexpected token: ( near line 1, column 114 [select pet from org.hibernate.test.hql.Animal pet, org.hibernate.test.hql.Animal owner where pet member of treat (owner as Human).pets]
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(QuerySyntaxException.java:91)
at org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:109)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:304)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:203)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
at org.hibernate.engine.query.spi.HQLQueryPlan.(HQLQueryPlan.java:131)
at org.hibernate.engine.query.spi.HQLQueryPlan.(HQLQueryPlan.java:93)
at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:568)

Users with the same issue

189 times, 1 week ago
26 times, 2 weeks ago
5 times, 1 month ago
12 times, 4 months ago
11 times, 4 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.