ActiveMQ 消息持久化到Mysql数据库

修改配置文件持久化到Mysql数据库

文件路径：\conf\activemq.xml

<persistenceAdapter>
    <!--<kahaDB directory="${activemq.data}/kahadb"/>-->
    <jdbcPersistenceAdapter dataSource="#mysql-ds"/>
</persistenceAdapter>

<bean id="mysql-ds" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://localhost:3306/test?relaxAutoCommit=true"/>
    <property name="username" value="root"/>
    <property name="password" value="123456"/>
    <property name="poolPreparedStatements" value="true"/>
</bean>

 apache-dbcp包下载地址

http://commons.apache.org/proper/commons-dbcp/download_dbcp.cgi

apache-commons-pool下载地址:

http://commons.apache.org/proper/commons-pool/download_pool.cgi

 

数据库需要字符集设置为latin1.

可以参考这个博客:

https://www.cnblogs.com/grey-wolf/p/6530998.html

CREATE DATABASE IF NOT EXISTS test default charset utf8; //这个是错误的写法 要么不写要么写latin1

DROP DATABASE test;

CREATE DATABASE IF NOT EXISTS test;

Enabling Message Priority

配置优先级生效：

<policyEntry queue='first' prioritizedMessages='true' />

循序渐进ActiveMQ（3）----MessageConsumer的消息选择器及mysql消息持久化