[jboss-user] [Persistence] - Weird generated SQL with JBoss 5.1

Hi, I am trying to migrate my ejb3 app from JBoss 4.2.3 to JBoss 5.1 I get a strange hibernate related issue when trying to perfrom an native query with JBoss 5.1 : String nativeQuery = "select sysdate from dual"; | Query query = getEntityManager().createNativeQuery(nativeQuery); When I execute this code withing JBoss 5.1 I get the following in the console : 12:09:22,833 INFO [STDOUT] Hibernate: select * from (select sysdate from dual ) where rownum <= ? This used to work perfectly inside JBoss 4.2.3 so I wonder what I need to do ??? Any ideas? - Patrick View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4269543#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...