Hi,

I have printed and read the hibernate doc but it is very poor in explanations about HQL (chapter 15).
So I managed to do simple queries but now I have one more complex that i'm not able to translate into HQL.

Here is the SQL query that I want into HQL :




And one more question (I'll give one credit for each...;o)):

Will I be able to retrieve an object for each column in my "select" clause.
I mean, I want to be able to retrieve the Person object, the EmpServ Object, the Serv object and the Emp object each time my query is satisfied..

Thanks in advance for help!

gaet'

For your first question, you want Session.createSQLQuery(" blah "), as opposed to Session.createQuery(" blah ")

Thanks for reply denis,

but does this mean that it's not possible to translate my SQL into HQL?
I'm surprised because HQL is know to be powerful...

disregard that. there is some good stuff in section 11.4 that is not in 15 - http://www.hibernate.org/hib_docs/v3/re ... e-querying . It appears you have a complex version of some of the stuff I know is in there. And you can definetly "retrieve an object for each column ", section 11.4.1.2 .

Thanks Denis,

This helps a little...and anyway, it help enough to help me to solve my problem...
for other readers that wants the solution, it is :


and then retrieve each object in the array returned (see chapter 11.4.1.2 for sample)

This solution is useful to retrieve object link up togheter instead of set lazy="false"....