Can't call commit when autocommit=true

[Wayne1285]

I am attempting to use a POJO MDB by using Jencks JCA Container 1.1.2,
ActiveMQ 4.0-RC1 and SpringFramework 1.2.6  I am using a basic setup.  Here
is the spring-config file.

================================================
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
"http://www.springframework.org/dtd/spring-beans.dtd"; >

<!-- Example found at
http://docs.codehaus.org/display/ACTIVEMQ/JCA+Container -->

<beans>
        <bean id="JCAContainer" class="org.jencks.JCAContainer">
                <property name="bootstrapContext">
                        <bean
                               
class="org.jencks.factory.BootstrapContextFactoryBean">
                                <property name="threadPoolSize" value="5" />
                        </bean>
                </property>
                <property name="resourceAdapter">
                        <bean id="activeMqResourceAdapter"
                               
class="org.activemq.ra.ActiveMQResourceAdapter">
                                <property name="serverUrl"
                                        value="tcp://www.sample.com:62626"
/>
                        </bean>
                </property>
        </bean>

        <bean id="SampleActivity" class="org.jencks.JCAConnector">
                <property name="jcaContainer" ref="JCAContainer" />
                <property name="activationSpec">
                        <bean
class="org.activemq.ra.ActiveMQActivationSpec">
                                <property name="destination"
value="activity" />
                                <property name="destinationType"
                                        value="javax.jms.Queue" />
                        </bean>
                </property>
                <property name="ref" value="ActivityHandler" />
        </bean>

        <bean id="ActivityHandler"
                class="com.sample.ActivityHandler"
                singleton="false" />

</beans>
================================================
The handler is as simple as it can get.

public class ActivityHandler implements MessageListener {

    private static Logger s_logger =
Logger.getLogger(ActivityHandler.class);

    public void onMessage(Message _message) {
        s_logger.debug("Received message:" + _message);
    }
}
===================================
Here is the log file 


 INFO Mon 27 11:50:43PM JmsBrokerManager.start() Using dataSource
jdbc:mysql://:6033/jmsdb
 INFO Mon 27 11:50:43PM ActiveMQ 4.0-RC1 JMS Message Broker
(SegOneJmsBroker) is starting
 INFO Mon 27 11:50:43PM For help or more information please see:
http://www.logicblaze.com
ERROR Mon 27 11:50:45PM JmsBrokerManager.start() Failed. Trying to add
connector tcp://localhost:9137 Reason - java.io.IOException: Can't call
commit when autocommit=truejava.io.IOException: Can't call commit when
autocommit=true
        at
org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:42)
        at
org.apache.activemq.store.jdbc.TransactionContext.close(TransactionContext.java:125)
        at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getLastMessageBrokerSequenceId(JDBCPersistenceAdapter.java:132)
        at
org.apache.activemq.broker.region.RegionBroker.<init>(RegionBroker.java:89)
        at
org.apache.activemq.broker.jmx.ManagedRegionBroker.<init>(ManagedRegionBroker.java:89)
        at
org.apache.activemq.broker.BrokerService.createRegionBroker(BrokerService.java:906)
        at
org.apache.activemq.broker.BrokerService.createBroker(BrokerService.java:863)
        at
org.apache.activemq.broker.BrokerService.getBroker(BrokerService.java:443)
        at
org.apache.activemq.broker.BrokerService.addConnector(BrokerService.java:136)
        at
org.apache.activemq.broker.BrokerService.addConnector(BrokerService.java:126)
        at
com.segone.communications.jms.JmsBrokerManager.start(JmsBrokerManager.java:122)
        at
com.segone.communications.jms.JmsBrokerManager.main(JmsBrokerManager.java:67)
Caused by: java.sql.SQLException: Can't call commit when autocommit=true
        at com.mysql.jdbc.Connection.commit(Connection.java:2145)
        at
org.apache.activemq.store.jdbc.TransactionContext.close(TransactionContext.java:119)
        ... 10 more
--
View this message in context: 
http://www.nabble.com/Can%27t-call-commit-when-autocommit%3Dtrue-t1353900.html#a3624415
Sent from the ActiveMQ - User forum at Nabble.com.