Arif,

Are you sure you need the relaxAutoCommit property? I thought you only needed that one if you are connecting to older MySQL DB servers. If you do need it, there is a typo in the property. The stack trace seems to indicate that a rollback is issued, when no transaction has previously been started. Are there any previous warnings/errors on the console?

Gert

Arif Mohd wrote:
My configuration is as follows,

 <?xml version="1.0" encoding="UTF-8"?>
<!--

    Licensed to the Apache Software Foundation (ASF) under one or more
    contributor license agreements.  See the NOTICE file distributed with
    this work for additional information regarding copyright ownership.
    The ASF licenses this file to You under the Apache License, Version 2.0
    (the "License"); you may not use this file except in compliance with
    the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

    Unless required by applicable law or agreed to in writing, software
    distributed under the License is distributed on an "AS IS" BASIS,
    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    See the License for the specific language governing permissions and
    limitations under the License.

-->
<beans xmlns:amq="http://activemq.org/config/1.0";>
<!-- ActiveMQ JMS Broker configuration -->
  <amq:broker depends-on="jmxServer">

<!-- Disable creation of the jmx connector which is created in the jmx.xml configuration file -->
    <amq:managementContext>
      <bean class="org.apache.activemq.broker.jmx.ManagementContext">
        <property name="createConnector" value="false" />
      </bean>
    </amq:managementContext>

    <!-- Use journaled JDBC persistence -->
    <amq:persistenceAdapter>
      <!--<amq:journaledJDBC journalLogFiles="5"
dataDirectory="./data/amq"/> -->
      <!-- To use a different datasource, use th following syntax : -->
<amq:journaledJDBC journalLogFiles="5" dataDirectory="../data" dataSource="#mysql-ds"/> </amq:persistenceAdapter> <amq:transportConnectors>
       <!-- Activate a TCP connector with multicast discovery.
            Note that multicast may be disabled if your computer
            is not on a network, which may prevent the broker to start.
In such a case, just remove the discoveryUri attribute. -->
       <amq:transportConnector uri="tcp://localhost:61616"
discoveryUri="multicast://default"/>
    </amq:transportConnectors>
<amq:networkConnectors>
      <!-- by default just auto discover the other brokers -->
      <amq:networkConnector uri="multicast://default"/>
<!-- <amq:networkConnector
uri="static://(tcp://host1:61616,tcp://host2:61616)"/>
      -->
    </amq:networkConnectors>
</amq:broker> <!-- This xbean configuration file supports all the standard spring xml
configuration options -->
<!-- Postgres DataSource Sample Setup --> <!-- <bean id="postgres-ds" class="org.postgresql.ds.PGPoolingDataSource">
    <property name="serverName" value="localhost"/>
    <property name="databaseName" value="activemq"/>
    <property name="portNumber" value="0"/>
    <property name="user" value="activemq"/>
    <property name="password" value="activemq"/>
    <property name="dataSourceName" value="postgres"/>
    <property name="initialConnections" value="1"/>
    <property name="maxConnections" value="10"/>
  </bean>
  -->
<!-- MySql DataSource Sample Setup using the Commons DBCP pooler
(http://jakarta.apache.org/commons/dbcp/) -->
<bean id="mysql-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url"
value="jdbc:mysql://localhost:3306/test?relaxAutocCommit=true"/>
    <property name="username" value="root"/>
    <property name="password" value=""/>
    <property name="poolPreparedStatements" value="true"/>
  </bean>
  <!-- MySql DataSource Sample Setup using the c3p0 pooler
(http://sf.net/projects/c3p0) -->
<!-- <bean id="mysql-ds" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
    <property name="driverClass" value="com.mysql.jdbc.Driver">
    <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/activemq">
    <property name="user" value="activemq">
    <property name="password" value="activemq">
    <property name="minPoolSize" value="5">
    <property name="maxPoolSize" value="10">
    <property name="acquireIncrement" value="3">
  </bean>
  -->
<!-- Embedded Derby DataSource Sample Setup --> <!-- <bean id="derby-ds" class="org.apache.derby.jdbc.EmbeddedDataSource">
    <property name="databaseName" value="derbydb"/>
    <property name="createDatabase" value="create"/>
  </bean>
-->
</beans>


Arif Mohd wrote:
Hi all,

    - Iam using servicemix3.1 which is using activeMQ 4.1
    - Iam placing multiple requests on servicemix and these requests are
served by http-bc and i will get the response and these responses are kept
in topic.
    - iam using mySQL as persitence storage.

          Under the above condition(when multiple requests are placed) iam
getting the following error

ERROR - JournalPersistenceAdapter      - Failed to checkpoint a message
store: edu.emory.mathcs.backport.java.util.concurre cutionException: java.io.IOException: Not started. edu.emory.mathcs.backport.java.util.concurrent.ExecutionException: java.io.IOException: Not started. at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.getResult(FutureTask.java:299) at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.get(FutureTask.java:118) at org.apache.activemq.store.journal.JournalPersistenceAdapter.doCheckpoint(JournalPersistenceAdapter.java:386) at org.apache.activemq.store.journal.JournalPersistenceAdapter$2.iterate(JournalPersistenceAdapter.java:129) at org.apache.activemq.thread.PooledTaskRunner.runTask(PooledTaskRunner.java:111) at org.apache.activemq.thread.PooledTaskRunner.access$100(PooledTaskRunner.java:26) at org.apache.activemq.thread.PooledTaskRunner$1.run(PooledTaskRunner.java:44) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690) at java.lang.Thread.run(Thread.java:595) Caused by: java.io.IOException: Not started. at org.apache.activemq.store.jdbc.TransactionContext.rollback(TransactionContext.java:168) at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.rollbackTransaction(JDBCPersistenceAdapter.java:368) at org.apache.activemq.store.journal.JournalPersistenceAdapter.rollbackTransaction(JournalPersistenceAdapter.java:1 at org.apache.activemq.util.TransactionTemplate.run(TransactionTemplate.java:62) at org.apache.activemq.store.journal.JournalMessageStore.checkpoint(JournalMessageStore.java:247) at org.apache.activemq.store.journal.JournalMessageStore.checkpoint(JournalMessageStore.java:221) at org.apache.activemq.store.journal.JournalPersistenceAdapter$4.call(JournalPersistenceAdapter.java:356) at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176) ... 3 more


Could any body help me out .



Reply via email to