Restrictions on fields with UserType question

aaime · **Joined:** Fri Apr 09, 2004 12:47 pm **Posts:** 36

Hi,
this is a pretty much open ended question.
Are UserType columns usable in any meaningful way in both hql or the criteria api?

For example, what if I query a user type that defines a value with a unit, and that's mapped onto two columns on the db, namely value and unit. Would a query like

myUserTypeAttribute > Measure(20,kiloVolt)

be turned into sql as:

value > 20 and unit > 'kilovolt'?

That's what it seems from the the code inside SimpleExpression at least (taken from the Criteria API).

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Never tried it in Criteria, but it should work. In HQL, you have to do the opposite:

Code:

myUserTypeAttribute.value > 20 and myUserTypeAttribute.unit = kiloVolt

From section 14.8 of the ref docs:

refdocs wrote:

You may also specify properties of components or composite user types (and of components of components, etc). Never try to use a path-expression that ends in a property of component type (as opposed to a property of a component).

aaime · **Joined:** Fri Apr 09, 2004 12:47 pm **Posts:** 36

tenwit wrote: