Hi everybody!!!

Its the first time i use hibernate and i think its really working very well. But i have a little problem with inheritance mapping.

The structure of the hibernate mapping is that:
- we have one meal at the top
- a meal consists of many mealitems
- a meal item references a food object
- a food can be a single nourishment or a recipe

And the problem is, that whenever i want to output the complete meal (this means i iterator through the single mealitem, i access the food and output the name) hibernate always generates a single select for each food

isnt it possible that hibernate loads all foods when i load a meal from the database with ONE SINGLE select

here are some parts of the hiberante mapping...

the mapping of the meal class


the mapping of the mealitems


the mapping of the food class


and when i run the code in java, like i mentioned, hibernate makes a single sql query for every food object and doesnt load all once

thanks for every

greets
markus

The "best practice" way is to use HQL and "join fetching"; see the docs.

You could also enable join fetching in the mapping documents if you really wanted to. Although, note that if you went this route, it would be much more difficult to get a Meal without getting all of its associations.