Please Help! I using Webpshere 4.03 and Struts 1.1 and don't have the luxury of using Serlet Filters... can someone explain how to use the hibernate session correctly.

I'm planning on using the thread local pattern, however my problem is that without Servlet Filters how can I ensure that the session is closed at the end of the request/response cycle?

Do I have to use the not recommended Auto timeout approach?

Any assistance would be appreciated.

Thanks. Pete

I guess no one has a solution? So how's this sound place the hibernate session in the HttpSession ensuring that transactions disconnect and reconnect as required.

I assume use of disconnect and reconnect will work for lazy instantiation, i.e can you lazily instantiate when a session is disconnected? If not what's the solution.

Any help/advice would be gratefully apprecaited.

You need some kind of interceptor that at least closes/disconnects the Session after the view is rendered. A disconnected Session can't be used for lazy loading, of course.

Agreed, but that is the crux of the problem, how best to achieve this if you don't have the benefit of the Spring framework interceptors or Servlet filters?

Then initialize all the data you need in a particular view before closing the Session by either using a runtime eager fetching strategy ("fetch join" in HQL, FetchMode in Criteria) or Hibernate.initialize().

I have used ThreadLocals for "old" struts with "old" servelt containers without problems:

public class MyServlet extends ActionServlet {


public void service(...

{

//DO BEFORE

super.service( ...

//DO AFTER


}

}