I have mapped a Category with CategorizedItems and Items, like the Caveat Example. But in my Category there is an extra column "CATEGORY_TYPE".

Now when I run my test getItemById(Long Id), I get the CategorizedItems from every Category.

But I want only the CategorizedItems of the Category with CATEGORY_TYPE ="Something"

How can I achieve this in my mapping, because I can add no where="" in my Categorized.hbm.xml?

I have tried to add this in <class name="Category" table="CATEGORIES" where="CATEGORY_TYPE='UI'">

But this doesn't work as well.

How can I get this to work?

Because when I add an where on my Category.hbm.xml

like this:
<class name="Category" table="CATEGORIES" where="CATEGORIE_TYPE='UI'">

I get the following Exception:
org.hibernate.ObjectNotFoundException: No row with the given identifier exists: package.Category#86

I think I am almost there, but don't know what to do now.