SQL Exception while setting up clustering

[Dean Jones]

Hello folks,

I'm trying to set up clustering using a database journal, backed by
SQL Server (unfortunately). I've managed to get rid of a few data
truncation errors by changing the schema definition, but now I'm
getting the following error from the append() method of
DatabaseJournal:

 java.sql.SQLException: commit() should not be called while in auto-commit mode.
        at 
net.sourceforge.jtds.jdbc.ConnectionJDBC2.commit(ConnectionJDBC2.java:1681)
        at 
org.apache.jackrabbit.core.journal.DatabaseJournal.append(DatabaseJournal.java:311)

This seems similar to:

https://issues.apache.org/jira/browse/JCR-913

but it's happening in append() rather than checkSchema(). My cluster config is:

        <Cluster id="node1">
          <Journal class="org.apache.jackrabbit.core.journal.DatabaseJournal">
            <param name="revision" value="${rep.home}/revision.log" />
            <param name="driver" value="net.sourceforge.jtds.jdbc.Driver" />
            <param name="url" value="jdbc:jtds:sqlserver://server/db" />
            <param name="user" value="user"/>
            <param name="password" value="password"/>
            <param name="schemaObjectPrefix" value="JR_"/>
          </Journal>
        </Cluster>

I'm using 1.3.3. Any thoughts on what's happening here?

Thanks,

Dean.