I use a Hibernate session in a MBean method in the following way:

InitialContext context = new InitialContext();
SessionFactory factory = (SessionFactory) context.lookup(SESSION_FACTORY_JNDI_NAME);
session = factory.openSession();
Transaction tx = session.beginTransaction();
try {
 MyDAO o = (MyDAO) session.load(MyDAO.class, "key1", LockMode.UPGRADE);
 ....
 tx.commit();
} catch (Exception e) {
 tx.rollback();
}

But autocommit of the underlying JDBC connection is true, and the record is not locked during the processing.
The Transaction is an JTATransaction.

When I set autocommit to of manually, then the record is locked, but the tx.commit does not pass the commit to the underlying JDBC connection.

Maybe a missing configuratin for the TransactionManager or UserTransaction.

Who have any ideas?

My testenvironment is JBoss 4.0.1, Hiberante 2.1.6, MySQL 4.1.5-gamma with innodb tables.

Thank you for your assistence.
Ramses