Hibernate version: 2.1

Let's say I have an order with 100 line items and I want to display a single item in the order. I can use something like the following to get the subset of my line items,

lineItems = session.filter(order.getLineItems, "where this.itemNo=20")

However, the client code only retrieves line items via order.getLineItems() and is not aware of session. The LineItem is associated with Order via <set><one-to-many></set>. Can I use "where" in <set> where the criteria is given in runtime?

No. In Hibernate3 you could use filters

Since Hibernate3 is in alpha, I will stay with 2.1 for now. I found a solution for my problem, though not sure if it's the best one. Instead of mapping getLineItems() to LineItem, getLineItemsLazy() is used. The business method is defined as follows,

barryku, just so that you are aware by setting the new HashSet() you will lose the ability to have cascade delete work since the HashSet will not be keeping state like the persistent collections will.

I'm trying to tackle the same sort of problems on a grander and I had come up with a similar solution. In my case the cascade deletes aren't an issue but I think I have a few ideas to make it behave 'normally' when all is said and done.

I'm going to have to take another look at the filters but I'm not sure it's going to do the trick for me.