Hibernate version: 3.0.5

Name and version of the database you are using:oracle 9i

The generated SQL (show_sql=true):
Hibernate: select this_.id as id0_, this_.tcn as tcn19_0_, this_.name as name19_0_, this_.description as descript5_19_0_, this_.volume as volume19_0_, this_.last_change as last7_19_0_, this_.last_group_change as last8_19_0_, this_.dov_id as dov9_19_0_, this_.pco_id as pco10_19_0_, this_.sequence as sequence19_0_, this_.product_number as product11_19_0_, this_.number_of_outlets as number12_19_0_, this_.pde_id as pde14_19_0_, this_.con_id as con15_19_0_ from spp_product_component this_ where this_.class='CP'

Total number of records in the table are - 75000
Nd the count of above query if executed in TOAD is - 65000

When ever I get all the records using criteria above query is generated
And it gives me timeout error on sun 1app server 7
and when i try to execute the same code using my junit bypassing the appserver it gives me out of memory error.

Can any one suggest what shuld i do to avoid this.

Were ever I do bulk fetch I am facing this problem ....
pls suggest if anyone has faced same issue.

don't retrieve all the results at once