How to open a new hibernate transaction with ejb3?

liwuen · **Joined:** Tue Jun 29, 2010 7:09 pm **Posts:** 1

Hi everybody! I have a simple but annoying question. How can I make (or call for) a new transaction when running along all the hibernate process?

What I mean is the following. I have a web service running with Jboss and Hibernate (using ejb3). The thing is that I want to make 5 inserts, but for example if the no. 3 fails, the first two are rollbacked automatically and the last two are not even persisted. I always get a "EntityManager must be access within a transaction" exception, so I found that the problem was that I was using the same transaction along all the 5 inserts.

I have 5 methods (one per each insert), and I was using the annotation "@TransactionAttribute(TransactionAttributeType.SUPPORTS)" in everyone of them. I changed them to "@TransactionAttribute(TransactionAttributeType.REQUIRES_NEW)" on each one, but the problem persists. Does anyone know what should I change to get the non-fail inserts to not roll back? Thanks!

sanne.grinovero · **Posted:** Mon Jul 05, 2010 5:18 pm

if you configure hibernate correctly you won't need to deal with transactions: at the end of you business method the container will commit the transaction, including all changes you made in the hibernate/JPA context.
So what you have to do is read the manual about configuring the transactionmanager: http://docs.jboss.org/hibernate/stable/core/reference/en/html/session-configuration.html#configuration-j2ee

Milo · **Joined:** Thu Aug 20, 2009 3:00 am **Posts:** 11

Hello,

I don't want autocommitting and so I just call this piece of code as soon as the entities need to be committed. This does a rollback if anything fails.

Code:

   /**
    * @param entityManager - EntityManager
    */
   public static void commitEntityManager(EntityManager entityManager) {
      synchronized (entityManager) {
         EntityTransaction transaction = entityManager.getTransaction();
         try {
            transaction.begin();
            transaction.commit();
         } catch (Throwable e) {
            LOGGER.error("commitEntityManager: " + e, e);
            if (transaction != null && transaction.isActive()) {
               transaction.rollback();
            }
            FacesHelper.addError("Aanpassing mislukt... probeer opnieuw ! [" + e + "]");
         }
      }
   }

Hmmm, reread your post and I now see that you WANT the others to be inserted. Maybe just call the commit for each insert? Or probably better, use the advise of experienced poster Sanne :)