Hibernate version:
2.1.6

Question:
Can I define my own join in Hibernate HQL ? I don't want to define it in mapping xml files.
I need to build query like this (native SQL):

SELECT *
FROM CONSULTANT_PLAN
LEFT JOIN CONSULTANT_WEEK ON
(CONSULTANT_PLAN.ID = CONSULTANT_WEEK.IDUSER
AND DATE > '2004-06-28 00:00:00.000'
AND DATE < '2004-07-02 00:00:00.000')
ORDER BY NAME DESC, DATE

where date values need to be set dynamically.
It is a little different than that (this can be done easily using HQL and mapping files) :

SELECT *
FROM CONSULTANT_PLAN
LEFT JOIN CONSULTANT_WEEK ON CONSULTANT_PLAN.ID = CONSULTANT_WEEK.IDUSER
WHERE
(DATE > '2004-06-28 00:00:00.000'
AND DATE < '2004-07-02 00:00:00.000')
ORDER BY NAME DESC, DATE

which gives you other results.

Greetings
Tom Kucharski

Hibernate version:
2.1.6

I need to build query like this:

from Model1 model1 inner join Model2 model2 on model1.foreignModel2 = model2.primaryId

I don't want to use mapping files because I must define join there explicity, not dynamically. Apart from that, how can I build such query ???
I think Hibernate don't let me build such query.


from Model1 model1 inner join Model2 model2 on model1.foreignModel2 = model2.primaryId and model1.someValue < 5

Thanks for any reply.
Tom Kucharski

You can, read http://www.hibernate.org/hib_docs/refer ... yhql-joins

Thanks.

There is nothing more than creating simple join query using join definition described in mapping file(s) on this site.

I've read this tutorial really carefully.
I've also read 'Hibernate in Action' book but I haven't found any explanation for this problem.


Anyway, thanks for reply.
Tom Kucharski

No, you can't declare your own outer join condition in Hibernate 2. (I think this is in the documentation and in the book, but certainly in the FAQ.)