Hibernate Community • View topic - HQL not support subselect in from clause?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

HQL not support subselect in from clause?

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

jimmy6

Post subject: HQL not support subselect in from clause?

Posted: Sun Aug 06, 2006 9:12 am

Beginner

Joined: Fri Jan 13, 2006 11:19 am
Posts: 24

The error occur in the subselect after FROM clause. How can i solve it? I already tried the following 2 sql.
select count(*) FROM select...
select count(*) FROM ( select ...

Code:

org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: select near line 1, column 25 [select count(*)  FROM   select sum(....

Top

david

Post subject:

Posted: Sun Aug 06, 2006 8:01 pm

Hibernate Team

Joined: Tue Aug 26, 2003 7:19 pm
Posts: 2364
Location: Brisbane, Australia

No - it is not supported in HQL.
You could use native SQL to solve the problem.

Top

jimmy6

Post subject:

Posted: Tue Aug 08, 2006 3:22 am

Beginner

Joined: Fri Jan 13, 2006 11:19 am
Posts: 24

Why hql is not work?

Top

david

Post subject:

Posted: Tue Aug 08, 2006 8:07 pm

Hibernate Team

Joined: Tue Aug 26, 2003 7:19 pm
Posts: 2364
Location: Brisbane, Australia

The HQL language thus the parser does not currently support it.
It a matter of someone decided to make HQL allow this format to happen.

Top

Page 1 of 1

[ 4 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