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

[patrick@openbase.com]

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#4269543

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4269543