Hibernate version: 3.1.0

I think there may be a bug in CriteriaImpl$Subcriteria.setFetchMode() when the Subcriteria was created from another Subcriteria.

I'm querying a structure that looks like this:

entity->many-to-one(assoc1)->entity->many-to-one(assoc2)->entity->collection

The following code works (it performs the fetch join on the collection)...



...but this doesn't work (the fetch join is not performed)...



Using the debugger, I noticed that CriteriaImpl$Subcriteria.setFetchMode() calls CriteriaImpl.setFetchMode() with a qualified path. However, in the failing case, the qualified path is "assoc2.collection", not "assoc1.assoc2.collection".

I've simplified the example queries. In reality they contain restrictions at the outer-most and inner-most nesting levels.

I have the same problem, I solved it using HQL:

StringBuffer strQuery = new StringBuffer(1000);
strQuery.append("from Project p ")
.append("left join fetch p.savedQuantification q ")
.append("left join fetch q.blocks bl ")
.append("left join fetch bl.blockDetails bd ")
.append("left join fetch bd.savings s ")
.append("left join fetch p.spendArea ")
.append("left join fetch p.cluster ")
.append("left join fetch p.spendCategory ")
.append("left join fetch p.region ")
.append("left join fetch p.businessGroup ")
.append("left join fetch p.hub ")
.append("left join fetch p.site ")
.append("left join fetch p.owner ")
.append("left join fetch p.milestoneStatus ")
.append("left join fetch p.backupOwner ")
.append("left join fetch p.projectStatus ")
.append("left join fetch p.multipleSite ")
.append("left join fetch p.milestones ")
.append("left join fetch p.implementationBarriers ")
.append("where p.id = " + id);

return (Project) uniqueElement(getHibernateTemplate().find(strQuery.toString()));



But I would prefere using the Criteria class instead of HQL.

Help would be welcome.

schuer

I've shown working code using the criteria API, it's just not as pretty as the broken version! You can also use Criteria.createAlias() to refer to associated entities.

Chris.