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

[jvg123]

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/%3C51431.217.109.84.129.1228826659.squirrel@www.mail.fr.clara.net%3E
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-with-Guvnor-tp3855272p3855272.html
Sent from the Drools: User forum mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20120325/21cb16fe/attachment.html