JDBC持久化

1、将mysql连接的jar放入active-mq的lib文件夹中

2、修改actviemq.xml，替换默认的kahadb

<!--  

<persistenceAdapter>

            <kahaDB directory="${activemq.data}/kahadb"/>

      </persistenceAdapter>

-->

<persistenceAdapter>  

      <jdbcPersistenceAdapter dataSource="#mysql-ds" createTableOnStartup="true"/>

</persistenceAdapter>

3、设置JDBC连接配置，创建数据库（自动建表）

    </broker>

 

    <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://mysql数据库URL/activemq?relaxAutoCommit=true"/>

        <property name="username" value="mysql数据库用户名"/>

        <property name="password" value="mysql数据库密码"/>

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

    </bean>

 

    <import resource="jetty.xml"/>

5、启动activemq