Hey all-

I am using Hibernate inside of JBoss. My hibernate.cfg.xml uses a datasource I have specified in JBoss.

In my code I am trying to execute a SchemaUpdate execute on the config object to build the tables I have in my config, but not yet in my db.

When it in JBoss I get this error:
11:43:52,659 INFO [Dialect] Using dialect: net.sf.hibernate.dialect.MySQLDialect
11:43:52,659 INFO [NamingHelper] JNDI InitialContext properties:{}
11:43:52,659 INFO [DatasourceConnectionProvider] Using datasource: java:/instanceDS
11:43:52,659 INFO [SchemaUpdate] Running hbm2ddl schema update
11:43:52,659 INFO [SchemaUpdate] fetching database metadata
11:43:52,689 ERROR [SchemaUpdate] could not get database metadata
java.sql.SQLException: You cannot commit during a managed transaction!
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:495)
at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:467)
at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:113)


What exactly does this mean and what can I do to avoid this. When I run the app in standalone mode (ie, not using jboss and datasources, but a main). I don't have any issues.

Thanks in advance for any insight you can give me.

-Tommy

Have the same problem, have set following properties:



And


occurs only at SchemaUpdate.
After the exception i can use the SessionFactory and hibernate sessions as
as wonted.

??

I guess you are configuring the SessionFactory within a method in an EJB. You can't commit a transaction that's managed by the container. If that's the case you have to make sure that you declare the Transaction type for that method as NotSupported, this will prevent the EJB container from starting a container managed transaction when calling the method and hibernate will then be able to commit.