org.hibernate.HibernateException: get is not valid without active transaction

Question

I'm new to Hibernate.

Automatically created hibernate.cfg.xml (Netbeans wizard)
Automatically created HibernateUtil.java
Automatically created POJO class with annotations

Trying to get object from database but getting error:

Exception in thread "pool-1-thread-1" org.hibernate.HibernateException: get is not valid without active transaction
    at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:297)

getting an object:

Session session = HibernateUtil.getSessionFactory().getCurrentSession();
CallInfo ci = (CallInfo) session.get(CallInfo.class, ucid);

hibernate.cfg.xml

<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/sochi_feedback</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">root</property>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property>
<property name="hibernate.current_session_context_class">thread</property>

@ShashankKadne `CallInfo ci = (CallInfo) session.get(CallInfo.class, ucid);` — VextoR, Mar 15 '12 at 10:55
Add "Transaction tx = session.beginTransaction();" just before this line and at the end of your operations call "tx.commit();" — Shashank Kadne, Mar 15 '12 at 10:59
why eclipse hibernate tool doesn't automatically generate this? — Li Tian Gong, Jan 14 '14 at 23:53

score 16 · Accepted Answer · answered Mar 15 '12 at 11:37

16

Add

Transaction tx = session.beginTransaction(); //This statement will initiate the transaction

just before your CallInfo ci = (CallInfo) session.get(CallInfo.class, ucid);

and at the end of your transaction commit the changes by calling..

tx.commit();

answered Mar 15 '12 at 11:37

Shashank Kadne

7,993
6
41
54

3

why eclipse hibernate tool doesn't automatically generate this? – Li Tian Gong Jan 14 '14 at 23:51

score 7 · Answer 2 · answered Jul 20 '12 at 07:39

7

Another solution is to use openSession() instead of getCurrentSession(). Then transactions can be used only when required for updating queries.

Session session = HibernateUtil.getSessionFactory().openSession();
CallInfo ci = (CallInfo) session.get(CallInfo.class, ucid);

answered Jul 20 '12 at 07:39

Amil Waduwawara

1,632
1
16
14

I'm experiencing exactly this, i.e. that sessions obtained via getCurrentSession requires a transaction even for get-operations, whereas this does not apply when using openSession. Why is that? (I had thought that the session-objects are identical?) – thomas a. h. Sep 06 '17 at 07:57
I had the same issue. But why? – Nov 16 '17 at 03:07

score 0 · Answer 3 · edited May 25 '16 at 09:08

0

Even after beginTransaction() and and commit() if you still get the

Caused by: org.hibernate.HibernateException: setDefaultReadOnly is not valid without active transaction
    at org.hibernate.context.internal.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:352)

go to "Start" and search for services and restart the database service

edited May 25 '16 at 09:08

Jonas Czech

12,018
6
44
65

answered May 25 '16 at 06:42

prasad

3
5

score 0 · Answer 4 · answered Nov 29 '17 at 07:29

0

Before you actually start the transaction you need to start the session by calling session.beginTransaction(), right after you create sessionFactory.

answered Nov 29 '17 at 07:29

Farruh Habibullaev

2,342
1
26
33

org.hibernate.HibernateException: get is not valid without active transaction

4 Answers4

Linked