How to specify a query for lazy initialized collection

[pmurphy.pjmurphy.paddypower.com]

Is it possible to specify the query that is used to initialize a lazy initialized collection within an entity? Also, is is possible to specify this for just a particular conversation/page etc?

So, for example, I have an entity called Foo which contains a collection of Bar entities which are lazily initialized. When I specify the following EL expression I want the Bar entities returned in a specified order defined by some query.

1. {foo.bars}

For other pages I don't want to place this query restriction on the bars collection to maintain performance.

Thanks,

Philip

[pmurphy.pjmurphy.paddypower.com]

EL Expression should read (forgot to format)

#{foo.bars}

[pmurphy.pjmurphy.paddypower.com]

Actually, forget about this question as the elements in the foo are contained in a Set (i.e. unordered this would never work.

[jeanluc]

To avoid an extra roundtrip to the db you can also have a separate query with join fetch that is used for that particular case.

[cash1981]

Yes. What you will need to do is us use fetch. Fetch will eagerly fetch the join. So in your foo.bars you will in your entityManager.createQuery(select foo from Foo foo where join fetch foo.bar)