activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From deepak_a <angesh...@gmail.com>
Subject Re: Auto commit issue with SQL Server + ActiveMQ
Date Wed, 11 Dec 2013 16:44:00 GMT
Hi,

I upgraded to ActiveMQ 5.8.0.
Added changeAutoCommitAllowed="false" to broker-config.xml - as shown below

     <persistenceAdapter>
       <jdbcPersistenceAdapter dataSource="#reform-ds"
useDatabaseLock="false" changeAutoCommitAllowed="false"/>
     </persistenceAdapter>


Now I don't see the exceptions stated above.
However on Jboss start up - I see the following 

2013-12-11 16:08:40,865 INFO 
[org.apache.activemq.store.kahadb.plist.PListStoreImpl] (Starting ActiveMQ
Broker)
PListStore:[C:\Downloads\REFORM_HOME\jboss-5.1.0.GA\bin\activemq-data\jboss-activemq-broker\tmp_storage]
started
2013-12-11 16:08:40,885 INFO  [org.apache.activemq.broker.BrokerService]
(Starting ActiveMQ Broker) Using Persistence Adapter:
JDBCPersistenceAdapter(org.jboss.resource.adapter.jdbc.WrapperDataSource@504266b6)
2013-12-11 16:08:40,896 INFO 
[org.apache.activemq.store.jdbc.JDBCPersistenceAdapter] (Starting ActiveMQ
Broker) Database adapter driver override recognized for :
[jtds_type_4_jdbc_driver_for_ms_sql_server_and_sybase] - adapter: class
org.apache.activemq.store.jdbc.adapter.TransactJDBCAdapter
2013-12-11 16:08:40,959 WARN 
[org.apache.activemq.store.jdbc.JDBCPersistenceAdapter] (Starting ActiveMQ
Broker) Cannot create tables due to: java.sql.SQLException: You cannot
commit with autocommit set!
2013-12-11 16:08:40,960 WARN 
[org.apache.activemq.store.jdbc.JDBCPersistenceAdapter] (Starting ActiveMQ
Broker) Failure Details: You cannot commit with autocommit set!
java.sql.SQLException: You cannot commit with autocommit set!
	at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:661)


**************************

Despite this warning ActiveMQ seems to have come up fine.


regards,
D



--
View this message in context: http://activemq.2283324.n4.nabble.com/Auto-commit-issue-with-SQL-Server-ActiveMQ-tp4675355p4675406.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.

Mime
View raw message