linux配置activemq5使用mysql数据库

 

1. 修改activemq配置文件

修改${activemq_home}/conf/activemq.xml

找到<broker></broker>，在<broker>中加入schedulerSupport="true"，如下：

<broker xmlns="http://activemq.apache.org/schema/core" brokerName="192.168.64.132" destroyApplicationContextOnStop="true" schedulerSupport="true" >

将默认的<persistenceAdapter>注释掉，加入如下的设置：

<persistenceAdapter>

    <jdbcPersistenceAdapter dataSource="#mysql-ds" useDatabaseLock="false"/>

</persistenceAdapter>

<broker>标签之外配置mysql数据源 。

<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?relaxAutoCommit=true"/>

    <property name="username" value="activemq"/>

    <property name="password" value="activemq"/>

    <property name="poolPreparedStatements" value="true"/>

</bean>

 

2. mysql JDBC驱动包mysql-connector-java-5.1.17.jar放到${ACTIVEMQ_HOME}/lib/下

3、启动

#${ACTIVEMQ_HOME}/bin/activemq console

这样启动的主要原因是为了实时查看activemq启动过程中是否有错误发生。

4、遇到的问题

错误：

INFO | Database lock driver override not found for : [mysql-ab_jdbc_driver].  Will use default implementation.

INFO | Attempting to acquire the exclusive lock to become the Master broker

解决办法：

在persistenceAdapter中添加useDatabaseLock="false"

<persistenceAdapter>

    <jdbcPersistenceAdapter dataSource="#mysql-ds" useDatabaseLock="false" />

        </persistenceAdapter>