Scott, out of curiosity.. do you know what started the active transaction that is in effect while the SessionFactory is being closed?

Steve Ebersole, yes the Hibernate2LCacheStatsTestCase unit test case link is calling EJB session bean SFSBHibernate2LcacheStats.cleanup() method. SFSBHibernate2LcacheStats.cleanup() starts a JTA transaction, which the SessionFactory.close() is called within.

Does the current fix work with different connection release modes? I'm not exactly sure of what will happen if the Session already has a connection that is enlisted into the active JTA transaction (before Hibernate calls TM.suspend()), which cause difficulties for the attempt to set auto commit mode.

Did you also think about getting a different (one-off) database connection for executing the DDL?