hibernate.QueryException when converting a query

Question

I have a HQL query that I'm trying to execute, but I keep getting a QueryException.

My query is

SELECT a FROM (SELECT MAX(m.version) maxVersionOp, m.codoperacion codOp FROM ConsumoMe m WHERE m.codoperacion  IN ('MEL101','MEL102') AND m.horizontetemporal IN('PM') GROUP BY m.codoperacion), ConsumoMe a WHERE codOp = a.codoperacion AND maxVersionOp = a.version AND a.fechaBajaLogica IS NULL

And the exception I get:

org.hibernate.QueryException: in expected: SELECT [SELECT a FROM (SELECT MAX(m.version) maxVersionOp, m.codoperacion codOp FROM es.enagas.siomprog.entities.ConsumoMe m WHERE m.codoperacion  IN ('MEL101','MEL102') AND m.horizontetemporal IN('PM') GROUP BY m.codoperacion), es.enagas.siomprog.entities.ConsumoMe a WHERE codOp = a.codoperacion AND maxVersionOp = a.version AND a.fechaBajaLogica IS NULL]

If I cut the inner select and try executing it:

SELECT MAX(m.version) maxVersionOp, m.codoperacion codOp FROM ConsumoMe m WHERE m.horizontetemporal IN('PM') AND (m.codoperacion = 'MEL101' OR m.codoperacion = 'MEL102') GROUP BY m.codoperacion

Then I get a similar exception:

org.hibernate.QueryException: , expected in SELECT [SELECT MAX(m.version) maxVersionOp, m.codoperacion codOp FROM es.enagas.siomprog.entities.ConsumoMe m WHERE m.horizontetemporal IN('PM') AND (m.codoperacion = 'MEL101' OR m.codoperacion = 'MEL102') GROUP BY m.codoperacion]

If I run the SQL equivalent queries, I get valid results. Furthermore, those error messages ", expected in SELECT" are not very helpful. Any idea of what could be the problem?

XYZ expected means that the HQL parser was expecting XYZ but got something else. It was expecting 'in' in the first query and ',' in the 2nd one — Guillaume
– Guillaume, Commented Jun 27, 2013 at 16:42

sanbhat · Accepted Answer · 2013-06-27 16:41:28Z

1

I see multiple errors in the SQL

m.codoperacion codOp --> m.codoperacion as codOp

AND m.horizontetemporal IN('PM') AND GROUP BY m.codoperacion --> there should not be AND

AND m.horizontetemporal IN('PM') GROUP BY m.codoperacion

answered Jun 27, 2013 at 16:41

sanbhat

17.6k6 gold badges52 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

DannyMo Over a year ago

also MAX(m.version) maxVersionOp --> MAX(m.version) AS maxVersionOp

Luis Sep Over a year ago

Thanks, "AND GROUP" was wrong, I pasted the wrong version of the query. About adding "as", it's not necessary, can be omitted. But still, removing that AND does not solve the problem.

Luis Sep · Accepted Answer · 2013-07-03 15:44:46Z

0

The answer is in:

http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html/queryhql.html#queryhql-subqueries

Hibernate doesn't allow subqueries in the from clause.

answered Jul 3, 2013 at 15:44

Luis Sep

2,4125 gold badges28 silver badges34 bronze badges

Collectives™ on Stack Overflow

hibernate.QueryException when converting a query

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related