Hibernate version:
3.2.0.cr1


Hello il would like to optimize my sql queries with subselect fetch.

this declaration didn't work

<many-to-one name="*" class="*" fetch="subselect">

And i don't like to use join fetch

Thanks for your help

subselect doesn't make sense in this case. A many to one will be loaded via an outer join or a simple select. Are you thinking maybe of a one-to-many mapping, that has support for subselect.

delete

Hello

I don't like to use fetch join & select on many-to-one property

Example
Person --> many-to-one --> Adress


When you select n Persons (1 select) and get Adress for Each Person (n Select)

for 50 Persons got 51 queries

with subselect

select many Person (1 select) and on first access of property Adress (1 select)

for 50 Persons got 2 queries

Thanks
Sorry for my English