Hibernate version 2.1
Oracle 8.1

I have the following piece of code in my application :

select("from FormEmployeeImpl order by full_name");

which generates the following SQL :

select * from ( select formemploy0_.EMP_ID as EMP_ID, formemploy0_.FULL_NAME as FULL_NAME, formempl
oy0_.EMAIL as EMAIL, formemploy0_.LOGIN as LOGIN from FORM_EMPLOYEE formemploy0_ order by full_name ) where
rownum <= ?

The value of the "?" parameter is set to 100.

I'm puzzled :

1. Why hibernate is putting the encapsulating statement
around the select statement? Can I get hibernate
not to use encapsulating statements. By encapsulating
I mean the "select * " statement.

2. Where is the value of 100 coming from ? Was something
configured (that I don't know about) which says
"limit all query results to 100"?

3. If all else fails ... is there a way to set the value of 100 to 1000000 or some
super large number so I can get all the results from the query?

Thanks,


em

Are you sure you don't set maxResult()/firstResult() in your query?