Atomikos Forum

Problem using Atomikos with MSSQL

Hi,
Recently I migrated my application to Atomikos from JOTM.
I have no problems using it with oracle, but with MSSQL console is highly populated with errors like:
com.atomikos.jdbc.AtomikosSQLException: Error in rollback on vendor connection
    at com.atomikos.jdbc.AtomikosSQLException.throwAtomikosSQLException(AtomikosSQLException.java:46)
    at com.atomikos.jdbc.nonxa.AtomikosThreadLocalConnection.transactionTerminated(AtomikosThreadLocalConnection.java:416)
    at com.atomikos.jdbc.nonxa.AtomikosNonXAParticipant.rollback(AtomikosNonXAParticipant.java:168)
    at com.atomikos.icatch.imp.TxRollbackOnlyStateHandler.addParticipant(TxRollbackOnlyStateHandler.java:56)
    at com.atomikos.icatch.imp.CompositeTransactionImp.addParticipant(CompositeTransactionImp.java:198)
    at com.atomikos.jdbc.nonxa.AtomikosThreadLocalConnection.updateInTransaction(AtomikosThreadLocalConnection.java:222)
    at com.atomikos.jdbc.nonxa.AtomikosThreadLocalConnection.invoke(AtomikosThreadLocalConnection.java:302)
.....

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot invoke a rollback operation when the AutoCommit mode is set to "true".
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(SQLServerConnection.java:1958)
    at com.atomikos.jdbc.nonxa.AtomikosThreadLocalConnection.transactionTerminated(AtomikosThreadLocalConnection.java:408)
    ... 98 more


In source code I saw that this error is later on ignored, but stacktraces pollute console output, and later on jenkins cannot transfer output from our tests because of to big file.

Do you have any recommendations?
Tomasz Szuba Send private email
Wednesday, April 17, 2013
 
 
Did you try setting autoCommit to false?
Guy Pardon Send private email
Monday, May 27, 2013
 
 

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

Other recent topics Other recent topics