Hibernate in web applications

RichardMaly · **Joined:** Mon Nov 24, 2003 11:47 am **Posts:** 22

Hi, I have large Hibernate application (about 40 Hibernate mapping classes). I use ThreadLocal pattern. For every http request I open session in my SessionThreadLocal and when page is completly done I closed session (in Filter).

But this is not all right, because new Hibernate Session object need more than 1 second for first .load(). What is proper patter for web applications ? Do not close session in SessionThreadLocal (only call session.clear()) ?

christian · **Posted:** Mon Feb 23, 2004 8:51 am

This is the correct pattern, I'd also consider your application quite small. The performance problems you see have nothing to do with your usage of the Session ThreadLocal (at least I hope so), but we can't help you, as you have not shown any code.

michael · **Posted:** Mon Feb 23, 2004 10:30 am

I hope you don't build the SessionFactory every time, too?

RichardMaly · **Joined:** Mon Nov 24, 2003 11:47 am **Posts:** 22

Example test:

Code:

      public void testManySessions() throws Exception {
      long t;
      SessionFactory fac = HibernateProvider.getSessionFactory();
      for (int i = 0; i < 10; i++) {
         t = System.currentTimeMillis();
         Session session = fac.openSession();
         Kurz kurz = (Kurz) session.load(Kurz.class, new Long(1));
         session.close();
         log.debug("time: " + (System.currentTimeMillis() - t) + "ms");
      }
     }

Result:

Code:

22:23,687 DEBUG HibernateSimpleTest:134 - time: 2859ms
22:26,515 DEBUG HibernateSimpleTest:134 - time: 2828ms
22:29,421 DEBUG HibernateSimpleTest:134 - time: 2906ms
22:32,234 DEBUG HibernateSimpleTest:134 - time: 2813ms
22:35,093 DEBUG HibernateSimpleTest:134 - time: 2859ms
22:37,906 DEBUG HibernateSimpleTest:134 - time: 2797ms
22:40,734 DEBUG HibernateSimpleTest:134 - time: 2828ms
22:41,921  WARN SessionImpl:3358 - unclosed connection
22:41,968  WARN SessionImpl:3358 - unclosed connection
22:43,843 DEBUG HibernateSimpleTest:134 - time: 3109ms
22:46,656 DEBUG HibernateSimpleTest:134 - time: 2813ms
22:49,421 DEBUG HibernateSimpleTest:134 - time: 2765ms

Is this normal behaviour ?

michael · **Posted:** Mon Feb 23, 2004 11:35 am

I don't consider this normal, enable logging and check whats going on there. I suspect you have a lot of non-lazy collections and you are acutally loading the complete object graph there.