Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Select statement

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

coups

Post subject: Select statement

Posted: Mon Nov 17, 2008 8:51 am

Newbie

Joined: Mon Sep 01, 2008 8:17 am
Posts: 2

Hi,

in Sql it is possible to write such code:

Select * from ( Select ...)

When i write this code in hql, i got every time a QuerySyntaxException.
I need this for ordering by the different columns, and 2 are subselects.

Thanks

Top

christianz

Post subject:

Posted: Mon Nov 17, 2008 12:32 pm

Newbie

Joined: Wed Oct 08, 2008 1:54 am
Posts: 14

Afaik subselcts in the From clause are not possible in HWL as of now.
http://opensource.atlassian.com/project ... e/HHH-3356

However if you are only trying to order the result it should be possible to do that by using a join and an order by with two parameters. Can you paste the full HQL statement?

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum