Hi Friends,

I'm developing a web application in Java where i use Hibernate with PostgreSQL.

Things are going good, but i have a concern with my approach. I'm not sure if I'm doing the right thing.

When a user logs in, I create a httpSession and hibernateSession. I store the hibernateSession as an attribute in the httpSession.

I'm not sure if it is a good practice as i've seen in a couple of forums that the hibernateSession becomes stale if we keep it open for too long. But since creating a new HibernateSession each time hits the performance, i don't want to keep creating and closing it every time.

Please suggest me what i can do.

It doesn't hit performance to create a new session for every request. Keeping it in the httpSession is likely to cause trouble and performance issues sooner or later. Eg. first-level cache using up a lot of memory, thread/synchronization issues, automatic-dirty checking taking a long time, etc.

Here is a quote from the documentation at http://docs.jboss.org/hibernate/stable/ ... ons-basics