Hello everyone,
I'm trying to use Guvnor repository with mysql. I'm using JBoss7.
I configured the datasource as jndi resource like this:
<datasource jta="true" jndi-name="java:jboss/datasources/guvnor"
pool-name="guvnor" enabled="true" use-java-context="true"
use-ccm="true">
<connection-url>jdbc:mysql://localhost:3306/guvnor</connection-url>
<driver>com.mysql</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>10</min-pool-size>
<max-pool-size>100</max-pool-size>
<prefill>true</prefill>
</pool>
<security>
<user-name>root</user-name>
<password>password</password>
</security>
<statement>
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<share-prepared-statements>true</share-prepared-statements>
</statement>
</datasource>
Now, when I run guvnor I get this exception:
Caused by: java.sql.SQLException: You cannot set autocommit during a managed
transaction!
at
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.setJdbcAutoCommit(BaseWrapperManagedConnection.java:888)
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:351)
[jackrabbit-core-2.2.8.jar:2.2.8]
at
org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:339)
[jackrabbit-core-2.2.8.jar:2.2.8]
I think is related to the <transaction-isolation> tag. Any help?
I couldn't find any example of how to configure this. Without using JNDI it
works.
Thanks in advance
--
View this message in context:
http://drools.46999.n3.nabble.com/Problem-with-guvnor-db-mysql-jndi-tp402...
Sent from the Drools: User forum mailing list archive at
Nabble.com.