How to reuse existing connection in Open Session In view pattern implementation of Hibernate?

Question

I am using Hibernate by implementing "Open Session in view" pattern?It opens a new connection per request. Is there any way to use the existing connection? Is my understanding correct? May be i miss something during implementation which cause opening of new connection?

Answer 1

Advice: don't implement it yourself, use an existing one, like Spring's:

Servlet 2.3 Filter that binds a Hibernate Session to the thread for the entire processing of the request. Intended for the "Open Session in View" pattern, i.e. to allow for lazy loading in web views despite the original transactions already being completed.

Failing that, look at the source code for the above to see how Spring does it.