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.
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?