Hibernate version: 2.1.4

Code between sessionFactory.openSession() and session.close():



Ok, I would like to be able to use the above code (or a better one) both with CMT and in plain java code. The following configurations failed:

CMT with hibernate JTA transaction: Hibernate transaction looks in JNDI for UserTransaction, which is not available with CMT (al least in jboss). To put the UserTransaction in java:comp I would have to declare the bean with BMT but that opens a can of worms.

CMT with hibernate JDBC transaction: Jboss rightfully complains that you are not supposed to commit in a CMT. But if I don't commit the transaction, then the code does not work in plain Java code

Has anyone else had/solved this problem? I would expect something like the hibernate transaction (magically?) detecting that it runs in a CMT environment and do nothing.

Would it be a solution not to use the Transaction object at all and just flush and close the session? Would session.close() commit the underlying transaction?

This is exactly the right way. I just suppose you have not configured Hibernate correctly for CMT/Jboss. Most likely wrong TransactinMannagerLookup.

Thanks Michel for the quick response. I was setting the property jta.UserTransaction instead of hibernate.transaction.manager_lookup_class. Setting the second works flawlessly.

I was trying to avoid appserver specific info in the hibernate config, but it's not such a big deal.

What about the second question? Is it OK not to use the transaction object at all? The transaction objects is useful when you want to have multiple transactions in the same session, but is it required even for just one transaction?

Thank you.

You should really always explicitly demarcate your transactions. Not doing so might only be useful in some _very_ exotic usecases, and if you _really_ know what you are doing.

So generally speaking, yes always use the transaction api.

Following is the configuration:

<!-- Transaction API -->
<property name="transaction.factory_class">net.sf.hibernate.transaction.JTATransactionFactory
</property>
<property name="transaction.manager_lookup_class">
net.sf.hibernate.transaction.WebSphereTransactionManagerLookup
</property>


but getting following error:

[10/23/04 15:58:34:356 AST] 6a2dede1 JTATransactio E net.sf.hibernate.transaction.JTATransaction TRAS0014I: The following exception was logged javax.naming.NameNotFoundException: Name "comp/UserTransaction" not found in context "java:".

My E.I.S Tier is based on DAO Pattern, and every DAO object is using Hibernate to manage persistence on the database.

I