Been searching for several hours I even posted a quest. earlier on this forum - but with no luck - I got an answer but I did not get it to work.

So

My problem seems quite normal.
ObjA has two collections
ObjA.CollectionB and ObjA.CollectionC. Both these collections are quite huge and I want to restrict the items in both collection to be items where items.Year=thisYear-1.

How do I initialize ObjA in such a way that CollectionB and CollectionC ONLY contain items with item.Year=thisYear-1.

My problem is that I cannot have the session open for more than a few secs. So I have to pass ObjA on to a business method (fully initialized with the restrictions on the collections).

I have fiddled around with several queries but can't grasp it.

Is this scenario supported in Hibernate???? or are there other ways to achieve the same??

please help!!

Regards Morten

Just an idea, but you could define an entity representing your Items class that uses the 'where' attribute and map to this entity:



Not sure this would work, but at least it's an idea...

collection-level where="..." is also a possibility

And how do I change the where clause at runtime??
Year is dependent of what the user wants??

Regards Morten

This is sounding more like a query, then.

Can you show me such a query - because no matter what I try it dosent work.

I CAN get collectionB initialized correctly but CollectionC ALWAYS contains everything.

I do something like.

ObjAInst = _session.CreateQuery("from ObjA oa left join fetch oa.CollectionB cb where oa.Id=34 and cb.Id in (25,26) ").List()[0];

This produces the expected result. Now I want to attach CollectionC to ObjA

_session.CreateQuery("from ObjA oa left join fetch oa.CollectionC cc where cc.Id in (200,201) and oa=:object").SetEntity("object", ObjAInst ).List();


After this call ObjA.CollectionC contains ALL elements - What shall I do and NOT only the ones with Id in (200,201)

I'm gettting a little desperate here - spent days on this issue.....

Regards Morten[/b]

Use a Hibernate3 Filter.