can't use left join fetch since I am using 'with' clause.

harshalx · **Posted:** Thu Mar 11, 2010 2:08 am

Hello

I'm running the following query:

Code:

        qry = session.createQuery("from DealSynopsisHistory dh" +
              " left join dh.personCreateBy cb" +
                      " with cb.startTime <= :asOfDate" +
                      " and cb.endTime > :asOfDate" +
              " where dh.dealKey = 4563");

As documented here https://www.hibernate.org/117.html#A13, HQL is ignoring fetch="join" in the mapping files and doing a select fetch. When doing select fetches, the join conditions are ignored.

I am unable to understand why the join conditions are ignored while doing a select fetch. Also, since I am using the 'with' clause, I can't even use 'left join fetch'.

Is this a limitation or bug or is there some problem in the way I am understanding this?

Here is the relevant mapping between DealSynopsisHistory and PersonHistory tables.

Code:

DealSynopsisHistory.hbm.xml

<many-to-one name="createBy"  column="CREATE_BY" property-ref="kerberosId" entity-name="PersonHistory" fetch="join" lazy="false"/>