hi everybody,

since the table per subclass strategie was too slow, i switched to
the table-per-class-hierarchy strategie to represent the following
inheritance:



My problem:
i usually don't want to recieve the data from all descriptors.

i'm am using query by criteria (since it makes it so easy to create
dynamic queries).

when i only include restrictions on the image columns, the descriptors
are eager-loaded, however i also recieve all descriptors belonging to the
selected images.

when i include restrictions on the image AND the descriptor columns
the descriptors aren't eager-loaded anymore.

i realized that i can use filters (in the xml mapping files), but i need to
create the queries dynamically (depending on the user input). do i
have to make a filter for every column and dynamically add the filters to
the session?

when i tried this i recieved too many images, since only the descriptors
are filtered by filters. i suddenly had images with no descriptors. these
images should'nt be included in the result list.

what i really need is, to be able to put restrictions on image table as well
as descriptor table columns, and load everything eagerly!!!

how do i do that?? any ideas????
thanks in advance,
cheers, nick