Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hi!! I would like to change the fetching strategy to lazy at runtime. Is it possible? I've seen examples of changing from lazy to imediate, for example. But I would like to use no lazy (lazy=false) and at runtime, for some other situation, change fetching strategy to lazy.
It would be something like:

select * from user fetch lazy...
don't know..
Thanks in advance..

iconst;

Using a criteria query, you could override the fetch mode. Hibernate 3 has deprecated the LAZY option, but the replacement is SELECT, in contrast with JOIN (which replaces EAGER).

For example, in a Order/OrderItems parent/child scenario:



If your mapping defined the relationship between Order and OrderItems as lazy="false", you would override it with the criteria above.

//Nicholas

thanks in advance! but can it be done in HQL?? I am in a situation where I cant use Criteria (join with other objects...)

I see what you mean. I do not think it can be done in raw HSQL. But you can join to other objects in criteria queries. My example above joins order items and orders, but you can also make arbitrary associations.

//Nicholas

but, it really needs to be done in hql... could someone help me!?