Hi All,
I'm trying to get activemq 4.0 to work with sequoia (was previously c-jdbc)
but am running into a problem asociated with autocomit mode connections
trying to be commited when the broker starts up. I tried the solution that
works with mysql but the sequoia driver seems to ignore it.
here's a partial trace
ACTIVEMQ_HOME: C:\install\incubator-activemq-4.0\bin\..
Loading message broker from: xbean:activemq.xml
INFO BrokerService - ActiveMQ 4.0 JMS Message Broker
(localhos
t) is starting
INFO BrokerService - For help or more information please
see:
http://incubator.apache.org/activemq/
WARN JDBCPersistenceAdapter - Database driver NOT recognized:
[sequoia_
generic_driver]. Will use default JDBC implementation.
ERROR BrokerService - Failed to start ActiveMQ JMS Message
Brok
er. Reason: java.io.IOException: Trying to commit a connection in autocommit
mod
e
java.io.IOException: Trying to commit a connection in autocommit mode
at
org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport
.java:42)
at
org.apache.activemq.store.jdbc.TransactionContext.close(TransactionCo
ntext.java:125)
at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.createAdapter(J
DBCPersistenceAdapter.java:253)
at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getAdapter(JDBC
PersistenceAdapter.java:213)
at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.start(JDBCPersi
here are the parts of my config
<persistenceAdapter>
<jdbcPersistenceAdapter dataSource="#sequoia-ds" />
</persistenceAdapter>
<!-- Sequoia DataSource -->
<bean id="sequoia-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName"
value="org.continuent.sequoia.driver.Driver"/>
<property name="url"
value="jdbc:sequoia://localhost/vieo_ccs?relaxAutoCommit=true"/>
<property name="username" value="postgres"/>
<property name="password" value="postgres"/>
<property name="poolPreparedStatements" value="true"/>
<property name="defaultAutoCommit" value="true"/>
</bean>
any ideas on how to get the persistence adapter to set the connection to
autocommit=false? (the default connection for sequoia is autocommit=true)
regards
Dave
--
View this message in context: http://www.nabble.com/ActiveMQ-and-Sequoia-Database--autocommit-issue-t1590803.html#a4317014
Sent from the ActiveMQ - User forum at Nabble.com.
|