Keeping Session live

[vaibhavpuranik]

Is there any way to keep Hibernate session live after the method call?
I am trying to implement Pagination using Gavin King's Page class.

But it uses scrollable resultsets and as soon as my method exists, I think the session is getting killed.

Any hints, pointers will be appreciated

Regards,
Vaibhav

[hiberman]

Is there any way to keep Hibernate session live after the method call?
I am trying to implement Pagination using Gavin King's Page class.

But it uses scrollable resultsets and as soon as my method exists, I think the session is getting killed.

Any hints, pointers will be appreciated

Regards,
Vaibhav

it depends, in which layer you want to keep sessions open:
1) web layer - try OpenSessionInViewFilter or interceptor.
2) business layer - wrap you method into transaction.

see more in this topic, look for lazyinitexception

[Costin Leau]

scrollable resultsets

Besides keeping the session alive you can use DetachedCriteria to keep the result between different request (just make sure you store it somewhere).