hi.

i've got a mapped entity. let's call it "person". a person has pets. now, i want to load the number of pets into a member of my person class, but i don't want to store the value in a column. i have a simple statement which retrieves all person attributes, and the number of pets.
how do i make hibernate map the resultset of this statement to a class, rather than a table?

Hibernate maps objects to tables not classes. You could implement a composite user type and use Hibernate to persist it for you. The Manning book, Hibernate Quickly has a good discussion on this topic. See if a friend or associate has a copy of the book and look at composite user types (implements UserType or CompositeUserType). You can google as well.

Add a field to your Person class and map it using formula. Hibernate doesnt create/use columns for entries that are marked with "formula". So for e.g. your hbm.xml for Person woulld have



PS: I havent verified if the count is allowed in the formula. The Hibernate docs indicate that it can be .

according to google, the formula can be any sql expression. it will be inserted as a subselect.