I did a little more research on the pbm I have :
To be a little more specific I am wondering how to disable the Oracle dialect related paging behavior ? When using the EntityManager to execute a native query it seems that Hibernate thinks that a paging type query is to be executed...
Is there maybe a property I need to set in the persistence.xml to disable the paging behavior for native query?
You might have better luck asking this in the Hibernate user forum https://forum.hibernate.org/viewforum.php?f=1.
Also, try specifying the return type of the query result:
I don't know if that's going to make a difference though.