activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "javier (JIRA)" <>
Subject [jira] Commented: (AMQ-2766) lost messages using jdbcPersistenceAdapter and mysql
Date Mon, 07 Jun 2010 20:05:52 GMT


javier commented on AMQ-2766:

here is my setting for activemq:

    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
    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.

    <!-- Allows us to use system properties as variables in this configuration file -->
    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"/>

    <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/activemq"/>
	    <property name="username" value="root"/>
	    <property name="password" value="javier"/>
	    <property name="poolPreparedStatements" value="true"/>

    <broker xmlns="" brokerName="default"  useShutdownHook="false"

        <!-- Destination specific policies using destination names or wildcards -->
                    <policyEntry queue=">" memoryLimit="5mb"/>
                    <policyEntry topic=">" memoryLimit="5mb">

        <!-- Use the following to configure how ActiveMQ is exposed in JMX -->
            <managementContext createConnector="false"/>

        <!-- The store and forward broker networks ActiveMQ will listen to -->

		 <jdbcPersistenceAdapter dataDirectory="${servicemix.base}/activemq-data" dataSource="#mysql-ds"

        <!-- Use the following if you wish to configure the journal with JDBC -->
            <journaledJDBC dataDirectory="${activemq.base}/data" dataSource="#postgres-ds"/>

        <!-- Or if you want to use pure JDBC without a journal -->
            <jdbcPersistenceAdapter dataSource="#postgres-ds"/>

        <!--  The maximum about of space the broker will use before slowing down producers
                    <memoryUsage limit="20 mb"/>
                    <storeUsage limit="1 gb" name="foo"/>
                    <tempUsage limit="100 mb"/>

        <!-- The transport connectors ActiveMQ will listen to -->
            <transportConnector name="openwire" uri="tcp://localhost:61616" discoveryUri="multicast://default"/>
            <transportConnector name="stomp" uri="stomp://localhost:61613"/>


    <bean id="activemqConnectionFactory" class="org.apache.activemq.ActiveMQConnectionFactory">
        <property name="brokerURL" value="tcp://localhost:61616" />

    <bean id="pooledConnectionFactory" class="org.apache.activemq.pool.PooledConnectionFactoryBean">
        <property name="maxConnections" value="8" />
        <property name="maximumActive" value="500" />
        <property name="transactionManager" ref="transactionManager" />
        <property name="connectionFactory" ref="activemqConnectionFactory" />
        <property name="resourceName" value="activemq.default" />

    <bean id="resourceManager" class="org.apache.activemq.pool.ActiveMQResourceManager"
          <property name="transactionManager" ref="transactionManager" />
          <property name="connectionFactory" ref="activemqConnectionFactory" />
          <property name="resourceName" value="activemq.default" />

    <osgi:reference id="transactionManager" interface="javax.transaction.TransactionManager"

    <osgi:service ref="pooledConnectionFactory">
            <entry key="name" value="default"/>


> lost messages using jdbcPersistenceAdapter and mysql
> ----------------------------------------------------
>                 Key: AMQ-2766
>                 URL:
>             Project: ActiveMQ
>          Issue Type: Bug
>    Affects Versions: 5.3.2
>         Environment: ubuntu
>            Reporter: javier
> hi,
> i was trying durable topics with jdbcPersistenceAdapter and mysql using JmsDurableTopicTransactionTest
 class (activemq test sources) and modified the connection and the method testReceiveRollback
adding a reconnect after the rollback. it should be work fine but it fails and i'm not sure
if i'm doing something wrong or is a bug.
> i would appreciate someone can check this test with this little modification
> javier

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message