SQL Exception while setting up clustering

[Dean Jones <de...@gmail.com>]

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.