Hi,

I am new to Hibernate.
I need to do several left joins using the Hibernate Criteria API.

What I would like to do is to get a list of objects (document) without retreiving all the attributes of the objects using projection. Meanwhile, each object has an associated object (invoice) with all its attributes needed.

Here is my work I have so far for one of my problems:
Criteria criteria =
session.createCriteria(Document.class, "document")
.setProjection(Projections.projectionList()
.add(Projections.alias(Projections.property("documentType"), "documentType"))
.add(Projections.alias(Projections.property("dateUploaded"), "dateUploaded"))
.add(Projections.alias(Projections.property("invoice"), "invoice"))
.add(Projections.alias(Projections.property("invoiceNumber"), "invoiceNumber"))
.add(Projections.alias(Projections.property("remarks"), "remarks")))
.createAlias("document.invoice", "invoice", CriteriaSpecification.LEFT_JOIN)
.addOrder(Property.forName("dateUploaded").asc())
.setResultTransformer(new AliasToBeanResultTransformer(Document.class));

return criteria.list();
}

The result of it is not what I would like to see. The invoice table is left-joined but its attributes are not queried.
I would like the invoice to be queried as an (associated) "full" object of the "partial" document object.
Please help!

What do you mean that your invoice is not queried? You mean you get proxies?

Try

instead of

>> What do you mean that your invoice is not queried?

The invoice table is appropriately left-joined with the listed document attributes, but the fields in the invoice table are not queried in my above work.

And the result of .setFetchMode("invoice", FetchMode.EAGER) is identical to my above work. So this does not produce what I need.

Thank you for trying to help ~