Using Hibernate Criteria with an List within my domain object

[Craig Dumolien]

I have a domain object Order, which has an List of OrderLine objects withing OrderLine, I have another object called Product which has fields I need to be able to search on.

I currently have Hibernate set up to pull all the Product and OrderLine data, when an Order is requested. I like this. However, when using criteria I thought I should be able to set this up like,

	criteria.add(Restrictions.like("orderLines.product.customerProductId", customerProductId.concat("%")));

but I get an Exception: org.hibernate.QueryException: could not resolve property: orderLines.product.customerProductId of: com....domain.Order

		...
		List/*<Order>*/ ordersList = new ArrayList();

		try {						
			session = ht.getSessionFactory().openSession();
			conn = session.connection();
			Criteria criteria = getCriteria(session);
			
			// add any user request criteria
			if (poNum != null && poNum.length() > 0) {
				criteria.add(Restrictions.like("poNum", poNum.concat("%")));
			}
			if (customerProductId != null && customerProductId.length() > 0) {
				criteria.add(Restrictions.like("orderLines.product.customerProductId", customerProductId.concat("%")));
			}
			if (supplierProductId != null && supplierProductId.length() > 0) {
				criteria.add(Restrictions.like("orderLines.product.supplierProductId", supplierProductId.concat("%")));
			}
			...

Is my notation wrong? If I just do a search on the poNum (which resides on the Order object), the search works fine. It only has problems when I go down to the OrderLine and Product level.

Thanks for the help.

[Trilochan Bharadwaj]

you can't go through properties like that, hibernate only "hydrates" one-to-one mapping for models, to go beyond that depth, you have to do something like:

final Criteria criteria = new Configuration().configure().buildSessionFactory().openSession().createCriteria(Order.class);
		criteria.createAlias("order.product", "product_", Criteria.LEFT_JOIN);
		criteria.createAlias("product_.somethingDeep", "somethingDeep_", Criteria.LEFT_JOIN);

or something in those lines.

Trilochan.

[Craig Dumolien]

Thanks for the input. That fixed it. The code I actually used is below. After getting the OrderLine, every other object I need to reference is one-to-one.

criteria.createAlias("orderLines", "ol", CriteriaSpecification.INNER_JOIN);