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.
