[rules-users] Unable to use MySQL JNDI datasource with Guvnor

Hi, [Guvnor 5.4.0.Beta2 on Jboss AS 7.1.1.Final with MySQL] When I configure Guvnor to use MySQL through a JNDI datasource I get multiple exceptions: java.sql.SQLException: You cannot set autocommit during a managed transaction! Stack trace attached below. The exact same datasource works OK without JNDI. A http://mail-archives.apache.org/mod_mbox/jackrabbit-users/200812.mbox/%3C... thread on the JackRabbit mailing list says this is a problem with XA datasources: But my datasource is not XA.... Any suggestions would be much appreciated! Thanks, Jelle ====================================== 2012/03/25 04:00:43,787 ERROR [org.apache.jackrabbit.core.util.db.ConnectionHelper] (http--127.10.162.129-8080-3) Failed to execute SQL (stacktrace on DEBUG log level): java.sql.SQLException: You cannot set autocommit during a managed transaction! at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.setJdbcAutoCommit(BaseWrapperManagedConnection.java:878) at org.jboss.jca.adapters.jdbc.WrappedConnection.setAutoCommit(WrappedConnection.java:715) at org.apache.jackrabbit.core.util.db.ConnectionHelper.getConnection(ConnectionHelper.java:395) [jackrabbit-core-2.2.8.jar:2.2.8] at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:278) [jackrabbit-core-2.2.8.jar:2.2.8] at org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:267) [jackrabbit-core-2.2.8.jar:2.2.8] at org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:263) [jackrabbit-core-2.2.8.jar:2.2.8] at org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:458) [jackrabbit-core-2.2.8.jar:2.2.8] at org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:263) [jackrabbit-core-2.2.8.jar:2.2.8] at org.apache.jackrabbit.core.util.db.CheckSchemaOperation.run(CheckSchemaOperation.java:89) [jackrabbit-core-2.2.8.jar:2.2.8] at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileSystem.java:197) [jackrabbit-core-2.2.8.jar:2.2.8] at org.apache.jackrabbit.core.config.RepositoryConfigurationParser$6.getFileSystem(RepositoryConfigurationParser.java:1057) [jackrabbit-core-2.2.8.jar:2.2.8] at org.apache.jackrabbit.core.config.RepositoryConfig.getFileSystem(RepositoryConfig.java:911) [jackrabbit-core-2.2.8.jar:2.2.8] at org.apache.jackrabbit.core.RepositoryImpl.(RepositoryImpl.java:285) [jackrabbit-core-2.2.8.jar:2.2.8] at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:605) [jackrabbit-core-2.2.8.jar:2.2.8] at org.apache.jackrabbit.core.TransientRepository$1.getRepository(TransientRepository.java:180) [jackrabbit-core-2.2.8.jar:2.2.8] at org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:280) [jackrabbit-core-2.2.8.jar:2.2.8] at org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:376) [jackrabbit-core-2.2.8.jar:2.2.8] at org.apache.jackrabbit.commons.AbstractRepository.login(AbstractRepository.java:123) [jackrabbit-jcr-commons-2.2.8.jar:] at org.drools.repository.JCRRepositoryConfigurator.login(JCRRepositoryConfigurator.java:95) [guvnor-repository-connector-jcr-5.4.0.Beta2.jar:5.4.0.Beta2] at org.drools.repository.RulesRepositoryConfigurator.login(RulesRepositoryConfigurator.java:85) [guvnor-repository-5.4.0.Beta2.jar:5.4.0.Beta2] at org.drools.guvnor.server.repository.RepositoryStartupService.newSession(RepositoryStartupService.java:118) [guvnor-webapp-core-5.4.0.Beta2.jar:5.4.0.Beta2] at org.drools.guvnor.server.repository.RepositoryStartupService.create(RepositoryStartupService.java:69) [guvnor-webapp-core-5.4.0.Beta2.jar:5.4.0.Beta2] -- View this message in context: http://drools.46999.n3.nabble.com/Unable-to-use-MySQL-JNDI-datasource-wit... Sent from the Drools: User forum mailing list archive at Nabble.com.