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/#configurat... 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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...