java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: with-clause referenced two different from-clause elements [SELECT v FROM com.imc.lpu.core.entity.Visit v LEFT JOIN v.idSluchMed s LEFT JOIN s.idInsured i LEFT JOIN i.histInvalidList h ON h.begdate < v.visitDate]

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 Hibernate JIRA by Sergey Lysenko, 1 year ago
org.hibernate.hql.internal.ast.QuerySyntaxException: with-clause referenced two different from-clause elements [SELECT v FROM com.imc.lpu.core.entity.Visit v LEFT JOIN v.idSluchMed s LEFT JOIN s.idInsured i LEFT JOIN i.histInvalidList h ON h.begdate < v.visitDate]
via Hibernate JIRA by Sergey Lysenko, 1 year ago
org.hibernate.hql.internal.ast.QuerySyntaxException: with-clause referenced two different from-clause elements [SELECT v FROM com.imc.lpu.core.entity.Visit v LEFT JOIN v.idSluchMed s LEFT JOIN s.idInsured i LEFT JOIN i.histInvalidList h ON h.begdate < v.visitDate]
via Stack Overflow by Nicolai Parlog
, 2 years ago
org.hibernate.hql.internal.ast.QuerySyntaxException: Country is not mapped [SELECT x FROM Country x]
via Stack Overflow by mmaceachran
, 1 year ago
org.hibernate.hql.internal.ast.QuerySyntaxException: User is not mapped [from User where lower(name) = :userName]
via Stack Overflow by Makudex
, 2 years ago
org.hibernate.QueryException: could not resolve property: user_level of: com.taskmanagement.entities.User [SELECT u.username,u.password,ul.level FROM com.taskmanagement.entities.User u JOIN u.user_level ul]
via Stack Overflow by Alexey Kirillov
, 1 year ago
org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: p near line 1, column 60 [select p from com.ui4ivr.entity.AnnouncementEntity p where p.on = TRUE]
org.hibernate.hql.internal.ast.QuerySyntaxException: with-clause referenced two different from-clause elements [SELECT v FROM com.imc.lpu.core.entity.Visit v LEFT JOIN v.idSluchMed s LEFT JOIN s.idInsured i LEFT JOIN i.histInvalidList h ON h.begdate < v.visitDate]
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.analyze(QueryTranslatorImpl.java:284)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:206)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
at org.hibernate.engine.query.spi.HQLQueryPlan.(HQLQueryPlan.java:126)
at org.hibernate.engine.query.spi.HQLQueryPlan.(HQLQueryPlan.java:88)
at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:190)
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:328)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1683)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:331)

Users with the same issue

10 times, 1 day ago
189 times, 1 month ago
26 times, 1 month ago
5 times, 2 months ago
12 times, 5 months ago

Write tip

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