Sorry for this bug...don't know why my question wasn't submited:/
2) I think you can use Native Queries for this (assuming you mean from EJB3 not J2EE).
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3991284#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...