I have a Category domain object.

In my categories table I added an extra column item_count that is updated by a trigger.

I have added a new CategorySummary object that contains the Category with the item_count.

class CategorySummary {
private Category category;
private int nrOfItems;

public CategorySummary(Category cat, int nrOfItems) {
....
...
}
}

I want to build and fill this object with HQL, but how do I do this?
The Category object doesn't know anything about the item_count column, because this is not mapped.

And I don't want my Category object to be polluted with item_count.

Can somebody help me with this?

You can map class inheritance.
For example:


AI