org.hibernate.TransactionException: nested transactions not supported

Question

I'm attempting to do a little task using Hibernate and JSF .

Here's my snippet of code . managed bean method that supposed to retrieve a list of tags :

Session session = HibernateUtil.getSessionFactory().getCurrentSession();
public  List<WikiTag> getTags(){
    session.getTransaction().begin();
    Criteria crit = session.createCriteria(WikiTag.class);
    List<WikiTag> result = crit.list();     
    return result;
}

I understand that i can't have more than one session open. However when i call that snippet of code from a facelet i get

org.hibernate.TransactionException: nested transactions not supported

Any light thrown on this is much appreciated . thanks

Community · Accepted Answer · 2017-05-23 11:58:42Z

3

+50

You can't have more then one transaction (not session) active at same time (I'm writing about your case).
Probably your method is already under transaction and you don't need to create a new one; remove session.getTransaction().begin();.
Look How to avoid nested transactions not supported error?

In addiction, right pseudo-code for transaction management is:

tx = begin tx;
try
{
  do database operations;
  commit tx;
  tx = null;
}
finally
{
  if(tx != null)
  {
    rollback tx;
  }
}

edited May 23, 2017 at 11:58

CommunityBot

11 silver badge

answered Sep 12, 2013 at 8:39

Luca Basso Ricci

18.5k2 gold badges51 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Rehme Over a year ago

I only have one transaction open . when i remove that line session.getTransaction().begin();, i get org.hibernate.HibernateException: createCriteria is not valid without active transaction

Luca Basso Ricci Over a year ago

did you try begin/commit/rollback best pratice? Your code is non correct because you never close transaction you begun (rewrite e try again)

Rehme Over a year ago

I tried it sir. But I got a 3rd exception org.hibernate.SessionException: Session is closed!

Community · Accepted Answer · 2017-05-23 12:31:48Z

1

First, Accessing database in getters setters is wrong. getTags method called several times during page is rendered. You can not do transactional database connections in action methods..

Second, acceesing database in JSF action is not a good practice. You should access databases in other classes they generally called DAO classes.

Collectives™ on Stack Overflow

org.hibernate.TransactionException: nested transactions not supported

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related