[rules-users] Problem with guvnor db mysql jndi

[Leonardo Soubeste]

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-tp4020805.html
Sent from the Drools: User forum mailing list archive at Nabble.com.