[jboss-user] [EJB 3.0] - Re: EntityManager's Native Query & Paging Results

[jaikiran]

I don't believe the jdbc batch size would affect your query output. 

For further logging options, see this http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#configuration-logging

And yes, do look for the actual query being fired by Hibernate in the logs. Something similar to:

2008-06-16 20:38:57,886 TRACE [http-0.0.0.0-8080-2] [org.hibernate.loader.custom.sql.SQLCustomQuery] starting processing of sql query [SELECT DISTINCT USR.ID FROM USER USR WHERE  USR.name like '%jai%']
  | 2008-06-16 20:38:57,917 TRACE [http-0.0.0.0-8080-2] [org.hibernate.impl.SessionImpl] SQL query: SELECT DISTINCT USR.ID FROM USER USR WHERE  USR.name like '%jai%'
  | 2008-06-16 20:38:57,932 DEBUG [http-0.0.0.0-8080-2] [org.hibernate.SQL] SELECT DISTINCT USR.ID FROM USER USR WHERE  USR.name like '%jai%' limit ?, ?
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4158583#4158583

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