Hibernate query syntax error?

Question

from (From FlightSchedule as a where a.route.routeId=1) as b

What is wrong in above query? It gives me this error

org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: ( near line 1, column 6 [from
 (From FlightSchedule as a where a.route.routeId=1) as b]

I have tried to write it in different ways but that don't work. What I suppose is that the inner query should evaluate to a list of objects and the same should be returned by the first from token? Please tell me what I am doing wrong? Thank you.

How does your whole query look like? change the From to from, they are case sensitive. — Zeus
– Zeus, Commented Oct 10, 2013 at 21:10
IN mysql This should be like this: select * from (select * from FlightSchedule where routeId=1) a; — Amit Kumar
– Amit Kumar, Commented Oct 10, 2013 at 21:16
Why are using nested queries here? By the way if you want nested queries, the nested query shall contain select clause, and as far as I know you can't use nested queries in from clause in hibernate. — Amir Pashazadeh
– Amir Pashazadeh, Commented Oct 10, 2013 at 21:48
Why not just From FlightSchedule as a where a.route.routeId=1? — Amir Pashazadeh
– Amir Pashazadeh, Commented Oct 10, 2013 at 21:48
because I am going to do self join. select * from (select * from flightschedule where routeId=1) join (select * from flightschedule where routeId=2) — Amit Kumar
– Amit Kumar, Commented Oct 10, 2013 at 22:02

JB Nizet · Accepted Answer · 2013-10-10 21:14:07Z

3

Your assumptions are wrong. This is invalid HQL. Quote from the documentation:

Note that HQL subqueries can occur only in the select or where clauses.

answered Oct 10, 2013 at 21:14

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

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

5 Comments

Amit Kumar Over a year ago

Thank you for your answer.But how can I write HQL equivalent to select * from (select * from FlightSchedule where routeId=1) a;

Amit Kumar Over a year ago

I tried that too but now it says unexpected token *. Also I don't find any select * example on the documentation page.

JB Nizet Over a year ago

You can't. subqueries can occur only in the select or where clauses. Use SQL.

Amit Kumar Over a year ago

Thank you JB Nizet. But with sql I will not get benefit of hibernate cache.Can I?

JB Nizet Over a year ago

Yes, you can. Just as with HQL queries. SQLQuery extends Query, which has a setCacheable() method

Collectives™ on Stack Overflow

Hibernate query syntax error?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related