[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - problem with testing: hibernate schema update -> can't commi
Hello
I write tests for domain persistence layer implemented on Hibernate.
I use JBoss microcontainer for the following purposes:
1. provide Datasources through JNDI
2. provide UserTransaction through JNDI
my tests fork fine. But I want to create database schema on every test run (I use HSQLDB
in embedded mode). Schema update is unavailable, because I use LocalTxDataSources which
use "test managed" UserTransaction.
stack trace:
SchemaUpdate - Running hbm2ddl schema update
| SchemaUpdate - fetching database metadata
| SchemaUpdate - could not get database metadata
| java.sql.SQLException: You cannot set autocommit during a managed transaction!
| at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.setJdbcAutoCommit(BaseWrapperManagedConnection.java:482)
| at
org.jboss.resource.adapter.jdbc.WrappedConnection.setAutoCommit(WrappedConnection.java:322)
| at
org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:36)
| at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:127)
| at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:314)
| at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1218)
hibernate.cfg.xml
| <property
name="connection.datasource">java:comp/env/jdbc/XxxDataSource</property>
| ....
| <property
name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
| <property
name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.WeblogicTransactionManagerLookup</property>
| <property
name="hibernate.transaction.flush_before_completion">true</property>
| <property
name="hibernate.transaction.auto_close_session">true</property>
| ...
| <property name="hibernate.hbm2ddl.auto">update</property>
jboss-beans.xml with several datasources:
| <bean name="MasterDSBootstrap"
class="org.jboss.resource.adapter.jdbc.local.LocalTxDataSource">
| <property
name="driverClass">org.hsqldb.jdbcDriver</property>
| <property
name="connectionURL">jdbc:hsqldb:file:test-output/master</property>
| <property name="userName">sa</property>
| <property
name="jndiName">java:comp/env/jdbc/XxxDataSource</property>
|
| <bean name="SlaveDSBootstrap"
class="org.jboss.resource.adapter.jdbc.local.LocalTxDataSource">
| <property
name="driverClass">org.hsqldb.jdbcDriver</property>
| <property
name="connectionURL">jdbc:hsqldb:file:test-output/slave</property>
| <property name="userName">sa</property>
| <property
name="jndiName">java:comp/env/jdbc/YyyDataSource</property>
|
"problem code" from SchemaUpdate.execute
| log.info("fetching database metadata");
| connection = connectionProvider.getConnection();
| if ( !connection.getAutoCommit() ) { <<<---- i can return true there
through extending datasource classes
| connection.commit();
| connection.setAutoCommit(true); <<< --- exception throwing there
| autoCommitWasEnabled = false;
| }
|
this code from hibernate 3.0.5, the same (but with insignificant differences) in 3.2
What are you think about this? Which is the simplest way to solve this issue? Should I use
nonTx Datasource's ? May be I have to extends LocalTxDataSource and WrappedConnection
for return AutoCommit true always?
thanks for your attention
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3988363#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...