Atomikos Forum

Error in commit on vendor connection


  Would anyone know where we tell the Connection Pooler how to turn off auto-commit for SQLServer? Using Hibernate but Atomikos is managing. Getting this trace below.
2009-04-30 14:31:11,330 WARN  (default.1) [atomikos] Error in commit on vendor connection
java.sql.SQLException: commit() should not be called while in auto-commit mode.
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.commit(
    at com.atomikos.jdbc.nonxa.AtomikosThreadLocalConnection.transactionTerminated(
I'm on the latest version (3.5.4) and am using jta/non-xa
and Hibernate3.3.1

My code is simply doing this:

 private static UserTransactionImp sUserTx = new UserTransactionImp();

      sUserTx.begin(); "begin processing message " + messageBody.getUUID() );
      processor.processMessage(null, null, messageBody, mContext);

In the file, possibly relevant
entries are:
In the Hibernate.cfg.xml
  <property name="connection.atomikos.nonxa">true</property>
  <property name="connection.atomikos.uniqueResourceName">re_nonxa</property>
  <property name="connection.atomikos.driverClassName">net.sourceforge.jtds.jdbc.Driver</property>
Ben K Send private email
Thursday, April 30, 2009
This appears to be a race condition in non-xa, that manifests itself under high loads. I have fixed this for our next community release.

Guy Pardon Send private email
Friday, May 15, 2009

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics