Hibernate Session is closed

Question

When I call the method session.begin transaction as follows:

//session factory is instantiated via a bean
Session session = this.getSessionFactory().getCurrentSession();
session.beginTransaction();

Then I get the following exception message

6:13:52,217 ERROR [STDERR] org.hibernate.SessionException: Session is closed!
at org.hibernate.impl.AbstractSessionImpl.errorIfClosed(AbstractSessionImpl.java:49)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1319)

What could be the cause of this error ?

What do you do _before_ that exception? Post the code, please. — Péter Török, Mar 04 '10 at 10:50

Péter Török · Accepted Answer · 2010-03-04T11:18:26.607

30

Update: I guess that calling getCurrentSession() does not guarantee that the session is actually open. For the very first time, you should use

Session session = this.getSessionFactory().openSession();
session.beginTransaction();

instead. This suggestion is actually consistent with the page you found.

Earlier:

Based on the information available so far, we can conclude that the cause of the error is the session not being open ;-)

edited Mar 04 '10 at 11:18

answered Mar 04 '10 at 11:00

Péter Török

114,404
31
268
329

See also http://stackoverflow.com/questions/8046662/hibernate-opensession-vs-getcurrentsession – rogerdpack Aug 01 '13 at 15:20

score 8 · Answer 2 · answered Mar 04 '10 at 11:08

8

I think I found the answer in:

Session is Closed

I am yet to implement it

answered Mar 04 '10 at 11:08

Anand Sunderraman

7,900
31
90
150

score 7 · Answer 3 · answered Mar 19 '15 at 08:45

7

You can use this annotation on your controller method:

@Transactional(readOnly = true)

answered Mar 19 '15 at 08:45

ACV

9,964
5
76
81

The attribute readOnly is undefined for the annotation type Transactional – Liz Lamperouge Mar 13 '17 at 11:15
I was refering to this `import org.springframework.transaction.annotation.Transactional;` – ACV Mar 14 '17 at 17:18

score 1 · Answer 4 · answered May 29 '13 at 13:46

Instead of closing the session completely, you can use session.disconnect(), do some other work, then session.reconnect() before doing other transactions.

session.close() would be called at the very end of the request / business process.

In Hibernate 2.1.8 we have been using the one session per request model and it works well, avoiding session leaks, etc.

See here for some elaboration

score 0 · Answer 5 · answered Dec 11 '18 at 16:16

To handle session is closed exception:

1-)In your hibernate.cfg file change the default hibernate.current_session_context_class to managed instead of thread

2-)Create two methods to open and close the session properly and use the before and after your query as sown below:

 public static void renewSession() {
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            session.setFlushMode(FlushMode.MANUAL);
             ManagedSessionContext.bind(session);
             session.beginTransaction();
       } catch (Exception e) {
            e.printStackTrace();
        }

    }
    public static void closeSession()
    {
       try {
       ManagedSessionContext.unbind(HibernateUtil.getSessionFactory());
                  session.flush();
                 session.getTransaction().commit();
            session.close();
        }
        catch (Exception e) {
            e.printStackTrace();
        }
    }

Usage:

try {
                renewSession();
                String query = "from Table tb";
               data = (List<TypeObject>)session.createQuery(query).list();
                closeSession();
            } catch (Exception e) {
                e.printStackTrace();
            }

score 0 · Answer 6 · edited Dec 11 '19 at 22:22

0

The following solution worked for me:

@SuppressWarnings("unchecked")
public List<Enfermedad> obtenerEnfermedadesOrderByProcal() throws HibernateException {
    if (session==null)
        session = HibernateUtil.getSession();
    if (!session.isOpen())
        session = HibernateUtil.getSession();
    return session.createQuery("FROM Enfermedad AS e ORDER BY e.ordenPROCAL, e.id").list();
}

edited Dec 11 '19 at 22:22

Dharman

30,962
25
85
135

answered Dec 11 '19 at 22:12

Nicolas400

563
1
7
29

score 0 · Answer 7 · edited Jun 14 '12 at 20:22

0

This may be the reason

session.close();
tx.commit();

The correct way would be:

tx.commit();
session.close();

edited Jun 14 '12 at 20:22

ThiefMaster

310,957
84
592
636

answered Jun 07 '11 at 08:29

Mohammed Afsul

692
7
8

tx.commit() , will flush the session & also close the session implicitly – Sajjad Ali Khan Mar 22 '20 at 08:13

score 0 · Answer 8 · edited May 23 '17 at 12:10

0

I had the same Hibernate Session Closed Problem a year ago . MY QUESTION

but it was for a different reason, I put this here in case someone faces this problem and wants to know more about it.

edited May 23 '17 at 12:10

Community

1
1

answered Aug 11 '11 at 19:53

Saher Ahwal

9,015
32
84
152

Hibernate Session is closed

8 Answers8

Linked