03_ActiveMQ_实例化到MySQL

1、找到D:\apache-activemq-5.15.4\conf\activemq.xml

2、将原本这一块配置改为MYSQL  

<!-- before -->
<persistenceAdapter>
    <kahaDB directory="${activemq.data}/kahadb"/>
</persistenceAdapter>

<!-- after -->
<persistenceAdapter>
	<jdbcPersistenceAdapter dataSource="#derby"/> <!-- 配置数据源为MQSQL -->
</persistenceAdapter>

3、添加MQSQL相关配置 

<!-- bean的id需要和上文配置保持统一 -->
<bean id="derby" 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?relaxAutoCommit=true"/>
	<property name="username" value="root"/>
	<property name="password" value="root"/>
	<property name="maxActive" value="200"/>
	<property name="poolPreparedStatements" value="true"/>
</bean>

4、需要在目录D:\apache-activemq-5.15.4\lib下添加三个jar包 

• commons-dbcp-1.4.jar
• commons-pool-1.6.jar
• mysql-connector-java-5.1.44-bin.jar

jar包选择有误可能会导致启动失败，尽量不选dbcp2或是pool2的jar 

5、启动后查看数据库，新增了三张表，此时算成功 

• activemq_acks
• activemq_lock
• activemq_msgs