this solution to be outdated now.
since i have updated glassfish to the latest official release by sun (Sun Java System Application Server 9.1_02 (build b04-fcs)) the code provided by gyorke does not work anymore.
I get the following exception:
"java.lang.ClassCastException: com.sun.enterprise.util.QueryWrapper cannot be cast to oracle.toplink.essentials.ejb.cmp3.EJBQuery"
how do I have write the code now to take a look at the native sql queries?
[Message sent by forum member 'zebhed' (zebhed)]
http://forums.java.net/jive/thread.jspa?messageID=274390