I have a composite user type Currency with 2 columns: amount and currency_code.

I'm trying to select all records where amount is greater than 0 regardless of currency_code - and I don't see any way to do that.

I tried this query:

"select * from Product where cost.amount > 0"

as well as Criteria query:

crit.add(Restrictions.gt("cost.amount", 0))

and both failed with "unable to resolve amount property". Is there actually a way to accomplish this without using SQL query?

Looks like CompositeUserType might be the answer. Reading up on that now.