Hi,
I am trying to migrate my ejb3 app from JBoss 4.2.3 to JBoss 5.1 using Hibernate 3.3.2 as the JPA provider
I get a strange hibernate related issue when trying to perfrom an native query with JBoss 5.1 :
Code:
String nativeQuery = "select sysdate from dual";
Query query = getEntityManager().createNativeQuery(nativeQuery);
When I execute this code withing JBoss 5.1 I the following SQL code in generated :
Code:
12:09:22,833 INFO [STDOUT] Hibernate: select * from (select sysdate from dual ) where rownum <= ?
In fact all my native query get encapsulated in this pagging template mode. How can I disable this feature in order for my native query to be executed as requested?
Any ideas?
- Patrick