When using <any> for a single point polymorphic association, how can I efficiently retrieve the associated entities?

e.g.


If I run the query "from Foo where deptId = 3" and 100 Foos are returned, is it possible to retrieve the Bars in the same query (outer-join) or in subsequent queries using batch fetching. "left join fetch bar" does not work, nor does setting batch-size in "bartypeX"



Thanks,
J.

(Hibernate version 2.1.7)[/code]

Whatever happened to the <join table="bars" outer-join="false"> as mentioned in Gavin's blog
http://blog.hibernate.org/cgi-bin/blosx ... /join.html

J.

I figured my original problem out, if I set

<class name="Bar1" table="BAR1" lazy="true" batch-size="10">

and then, after loading the foo objects, explicitly hydrate the bar using foo.getBar().getSomeProperty(), the bar subclasses are loaded in batches. Without the lazy=true, the bar objects are loaded one by one.

J.