Hi,

I have just started working on Hibernate.
I have a doubt about subqueries.
My query in Oracle is
select * from ( select * from tabelname where ID=12 order by dtCreation desc ) where rownum <= 4;

Please let me know how I can use the query in hibernate.

Thanks in advance.
Sri.

Hello, what kind of queries do you plan to use, hql or SQL?

Hi,

I want to use hql queries.

Im using a List and want to populate the list using the query.
Here I require help in writing the hql query inside the createQuery.

queryList = session.createQuery("select * from ( select * from tabelname where ID=12 order by dtCreation desc ) where rownum <= 4").list();

thanks in advance.
sri

Hi,
HQL subqueries may occur only in the select or where clauses.
So, we cannot have inline views in HQL.

-----------------------------------------
Rate the reply if you find it helpful

Hi,

Is this not possible in anyway to do In Hibernate??

Thanks,
Sri

Hi,
It's not possible with HQL.
Definitely possible with Hibernate.
Use session.createSQLQuery().

-----------------------------------------
Rate the reply if you find it helpful

How about just keeping things simple...
In Hibernate you select from an Object not a table. instead of trying to do everything in one go, just break it up.

HQL1: "from tablename where bla bla bla" will give you your table name, you can then use a simple if statment to convert this to your fully qualified Object name which should be the same as MyObject.class.getName() for example.

Then you can do your 2nd peice of HQL.

HQL2: "from <Object name from if statment before> where bla bla"

There isn't any need to do everything in one statement as you did with SQL. Keep things simple with Hibernate and you'll get on with it much better.

i agree with adamgibbons, why you just split the queries, as i've heard sometimes it's faster for some databases.

Hi adamgibbons,

I am also newbie with Hibernate. Can you describe more in detail, how you applying new select statement on the existing select result.

Thanks in advance.
Sergio