Hibernate query using a custom user type

[David Irwin]

All,

I'm trying to create a Hibernate query. Here's my named query that works so far that I define in my mapping file:

    
<query name="standard">
  from common.datastructures.alarm.AlarmInfo as alarmInfo
  where alarmInfo.deviceId =  :mrgreen: eviceId AND 
  alarmInfo.clearedDate > :afterDate AND
  alarmInfo.clearedDate < :beforeDate
  order by alarmInfo.clearedDate
</query>

What I'm trying to add is the following:
* there's an object in the AlarmInfo class called "level" that I map as a custom Hibernate user type (it implements org.hibernate.usertype.UserType).
* I only want to retrieve an alarmInfo object if it's alarmInfo.level is in a collection of alarm levels.

I tried to do the following:

public List<AlarmInfo> retrieveAlarms(AlarmQuery alarmQuery) {
Criteria criteria = getSession().createCriteria(AlarmInfo.class);
criteria.add(Restrictions.in("level", alarmQuery.getLevels().toArray(new AlarmLevel[0])));
...
return criteria.list();
}

This, however, doesn't seem to work. I feel like since the "level" is mapped as a Hibernate UserType I should be doing something differently. Any ideas?

Thanks,
Dave