Hi,

I have a class (Status) which implements PersistentEnum, providing both fromInt() and toInt() methods. This 'enumerated type' is a property of a class, say Message.

I need to query the database to return all queries with a given status. i.e.



This generates sql:


and gives the exception:


I have tried all sorts of combinations of the query method signature (using Hibernate.custom(clazz), Hibernate.OBJECT, etc, etc). All seem to give a different exception.

What is the correct what to use a PersistentEnum in a query?

Thanks

Justin

BTW I know it works if I do:


... but surely there is way that Mr Hibernate takes care of the conversion?

Justin

Use a fully-qualified class name.

Great - working 100%.

I had (erroneously) assumed that because I had used Message unqualified I could used Status unqualified in the query.

Thanks Gavin !