What SQL is getting generated for this EJB-QL (it is written to the server.log file)? Is it the sql you were expecting?
The problem is that I can't find any SQL generated in this server.log file.
I finally found another solution to get the collection I want but I still don't understand why what I did is not working.
> The problem is that I can't find any SQL generated in
> this server.log file.
Up the log level to at least debug.