activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave cawthorn <dave.cawth...@empired.com>
Subject ActiveMQ and Sequoia Database -autocommit issue
Date Wed, 10 May 2006 10:46:46 GMT

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.


Mime
View raw message