Hi Joe,
this is strange. Your query looks ok. I'm just wondering about the error message. It says unexpected token SystemPrivilege at column 1. Meaning the query text passed to the query parser starts with SystemPrivilege (but the parser expects to find the token SELECT). I had such an error when I intended to create a named query, but I called em.createQuery (instead of em.createNamedQuery) and passed the query name as an argument.
Regards Michael
[Message sent by forum member 'mb124283' (mb124283)]
http://forums.java.net/jive/thread.jspa?messageID=228993