Named query containing @Enumerated comparison

[Marc Siegel]

Hi folks,

Say I have an entity Item, with an @Enumerated column 'status'.

How can I have a named query like this:
    "SELECT i FROM Item WHERE i.status = 'New' "

I've tried
    "SELECT i FROM Item WHERE i.status = 'New' "
    "SELECT i FROM Item WHERE i.status.name = 'New' "
    "SELECT i FROM Item WHERE i.status = ItemStatus.New "
    "SELECT i FROM Item WHERE i.status = com.xyz.lib.ItemStatus.New "

To no avail. Any help?

Thanks
-Marc