EJB-QL Queries

[rilux]

I have written a query such that a collection of a person EJB is returned that have manager status. It looks like this:

SELECT OBJECT(p) FROM person AS p WHERE p.manager = TRUE;

Given the current data in my database it should return a collection with 1 thing in it. However, I get an empty collection. Is this type of Boolean literal query unsupported currently? That would seem very silly to me, or have I done something stupid? That would be reasonable as it's a nice sunny day and the screaming kids are out screaming. It's driving me a little mental.

Rilux

[rilux]

Well, I seem to be having some major EJB-QL issues. I modified the query I've described above to do the same as an existing and working EJB-QL query - and I still get an empty result set.

What's more, if I edited this working one to the above it works exactly the same way as it did before being edited.

What on earth is going on here?

Rilux