Hi all,

I'm trying to implement an Oracle query containing the pattern "select ... from (select ... from...) ... " in HQL. As a simple example I would like to run the following Oracle query:

select * from (select name, age from customer)

I know that the query is nonsense, nevertheless I would like to make it work in hibernate just to verify if a such statement is supported by HQL.
Can anyone provide the equivalent HQL query?

Thanks.

Best regards.
Dario.

No, this is not supported, don't think it would make much sense on an object querying level. You can use createSqlQuery to roll your own.

Yeah, AFAICT, from-clause subselects don't make sense in an OO query language, so you would be better to just use direct JDBC.

Ok, I implemented the query using the createSQLQuery() method and works fine. However I'm a little bit disappointed I can't use HQL: using regular SQL my query could become vendor dependent :-(
I don't know much about OO query language, so I don't catch your observation. In SQL such queries are often useful for performance reason, when you want to manipulate columns from different tables in a single select and would be too expensive to join all the tables. You mean that in OO queries this situation never occurs, or is there a different solution?

Dario