Hi All,

It's about one day I'm struggling with this problem without understanding what's going on

I'm on mysql5 using hibernate 3, using all the default conf

here is my mapping file for the work object


<hibernate-mapping package="model">

<class name="model.Work" table="work" lazy="true" batch-size="30" >

<id name="id" column="id">
<generator class="native"/>
</id>

<property name="salary" />

</class>

</hibernate-mapping>



but when I call


List l = session.createQuery("From Work").list();


All the table is loaded !!!!

The log end with

StatefulPersistenceContext:748 - initializing non-lazy collections


Can someone give me a hint I really can't figure out what's going on.

You don't understand what lazy initialization is. It's a feature for mapped collections, not for list of mapped classes. You get exactly what are you asking in the query: a list of all Work instances.

Well,

I probably miss explain myself, when you query a collection of object using

session.createQuery("From Something).list();

hibernate should not load all the resultSet in the collection, imagine you have 1 million of lines....

It's here the batch size become important, but as you can see in my previous post, setting the batch size don't change anything.

Thanks anyway

For what you are trying to achieve use the following.

Query q = session.createQuery("From Something");
q.setFirstResult(n);
q.setMaxResults(30);
List l = q.list();

batch-size is a different concept.