activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From deepak_a <angesh...@gmail.com>
Subject Auto commit issue while using SQL Server + ActiveMQ
Date Wed, 11 Dec 2013 09:23:38 GMT
All,I am using ActiveMQ 5.6.0SQL Server 2008 is used in backend.With SQL
Server - I get the following exception2013-12-11 09:17:15,085 WARN 
[org.apache.activemq.store.jdbc.JDBCPersistenceAdapter] (ActiveMQ Transport:
tcp:///127.0.0.1:62351) Commit failed: commit() should not be called while
in auto-commit mode.java.sql.SQLException: commit() should not be called
while in auto-commit mode.	at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.commit(ConnectionJDBC2.java:1878)........................................2013-12-11
09:17:15,089 WARN  [org.apache.activemq.store.jdbc.JDBCPersistenceAdapter]
(ActiveMQ Transport: tcp:///127.0.0.1:62351) Rollback failed: rollback()
should not be called while in auto-commit mode.java.sql.SQLException:
rollback() should not be called while in auto-commit mode.	at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:1893)
at
net.sourceforge.jtds.jdbcx.proxy.ConnectionProxy.rollback(ConnectionProxy.java:517)........................................2013-12-11
09:17:15,109 WARN  [org.apache.activemq.store.jdbc.JDBCPersistenceAdapter]
(ActiveMQ Transport: tcp:///127.0.0.1:62351) Error while closing connection:
commit() should not be called while in auto-commit
mode.java.sql.SQLException: commit() should not be called while in
auto-commit mode.	at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.commit(ConnectionJDBC2.java:1878)........................................Caused
by: java.sql.SQLException: commit() should not be called while in
auto-commit mode.	at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.commit(ConnectionJDBC2.java:1878)
at
net.sourceforge.jtds.jdbcx.proxy.ConnectionProxy.commit(ConnectionProxy.java:87)This
happens when a message is to be persisted to the database.My broker-config
is as follows            		     Datasource is shown below                   
ReformDS                                        false                   
net.sourceforge.jtds.jdbcx.JtdsDataSource                                	
LDN-LRM-PC-189                    reform                    SQLEXPRESS                   
true					false             	true            	true					                   
TRANSACTION_READ_UNCOMMITTED                    10                    30                 
 
15                    5000                                        select 1               
                                             
MS SQLSERVER                                		EncryptDBPassword            	
jboss.security:service=JaasSecurityDomain,domain=ServerMasterPassword               
Is this happening because - my Datasource is attempting to commit in
addition to the auto-commit in SQL Server? - I don;t see any option to
disable auto-commit in the Datasource though...regardsD



--
View this message in context: http://activemq.2283324.n4.nabble.com/Auto-commit-issue-while-using-SQL-Server-ActiveMQ-tp4675353.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message