Thanks for the suggestions, Chris and Marco.
It seems the error is related to the Database connection or configuration.
This is the typical error Im getting
Aug 26, 2011 12:33:22 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
SEVERE: XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state
I'm having little success in tracking down a solution from goggle.
BTW, I'm using bitronix for TX
import bitronix.tm.TransactionManagerServices;
import bitronix.tm.resource.jdbc.PoolingDataSource;
| | | UserTransaction ut = (UserTransaction) new InitialContext().lookup("java:comp/UserTransaction"); |
| | | ut.begin(); |
| | | PoolingDataSource ds1 = new PoolingDataSource(); |
| | | ds1 = new PoolingDataSource(); |
| | | ds1.setUniqueName("jdbc/testDS1"); |
| | | ds1.setClassName("com.mysql.jdbc.jdbc2.optional.MysqlXADataSource"); |
| | | ds1.setMaxPoolSize(3); |
| | | ds1.setAllowLocalTransactions(true); |
| | | ds1.getDriverProperties().put("user", "test1"); |
| | | ds1.getDriverProperties().put("password", "test1"); |
| | | ds1.getDriverProperties().put("URL","jdbc:mysql://localhost:3306/jbpm5db"); |