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 <a href="http://mail-archives.apache.org/mod_mbox/jackrabbit-users/200812.mbox/%3C51431.217.109.84.129.1228826659.squirrel@www.mail.fr.clara.net%3E" target="_top" rel="nofollow" link="external">thread</a> 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.<init>(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]

        
<br/><hr align="left" width="300" />
View this message in context: <a href="http://drools.46999.n3.nabble.com/Unable-to-use-MySQL-JNDI-datasource-with-Guvnor-tp3855272p3855272.html">Unable to use MySQL JNDI datasource with Guvnor</a><br/>
Sent from the <a href="http://drools.46999.n3.nabble.com/Drools-User-forum-f47000.html">Drools: User forum mailing list archive</a> at Nabble.com.<br/>