Hello,

I can not use WITH keyword for extra join conditions. Here is my HQL:
and the exception I get:


My hibernate version is 3.2.2.ga. I followed the example from hibernate tutorial so I assume my syntax is correct.
What is happening? Thank you.

Problem solved.
It was a problem with the Query Translator. The job of the Query Translator is to turn HQL queries into SQL queries. The ClassicQueryTranslatorFactory is the version that was included in Hibernate 2. In Hibernate 3 they created a new Query Translator, the ASTQueryTranslatorFactory. ClassicQueryTranslatorFactory does not know about WITH clause.
Set the Query Translator in the hibernate.properties file: