1.添加MySql数据源
打开Activemq安装目录下的conf/activemq.xml文件,添加MySql数据源。默认情况下Activemq使用KahaDB存储,注解掉KahaDB配置,改为mysql配置如下:
该配置表示,我们将要使用名称为“MySQL-DS”的作为mysql数据源。
2. 配置MySql数据源
在节点后面,增加MySQL数据源配置:
3. 创建数据库activemq 字符集需要使用latin1
4. 配置完成后,将mysql-connector-java-5.1.29.jar 驱动包加入到 Activemq 的 lib目录下,启动Activemq。查看activemq数据库会有三张表:activemq_acks ,activemq_lock ,activemq_msgs
数据表activemq_msgs即为持久化消息表;
注意可能出现异常(创建数据库activemq 字符集需要使用latin1 否者出现下面错误)2015-05-04 14:50:30,335 | INFO | Refreshing org.apache.activemq.xbean.XBeanBrokerFactory$1@30f97aff: startup date [Mon May 04 14:50:30 CST 2015]; root of context hierarchy | org.apache.activemq.xbean.XBeanBrokerFactory$1 | WrapperSimpleAppMain
2015-05-04 14:50:33,051 | INFO | PListStore:[/usr/local/apache-activemq-5.11.1/bin/linux-x86-64/../../data/localhost/tmp_storage] started | org.apache.activemq.store.kahadb.plist.PListStoreImpl | WrapperSimpleAppMain
2015-05-04 14:50:33,134 | INFO | Using Persistence Adapter: JDBCPersistenceAdapter(org.apache.commons.dbcp.BasicDataSource@74aad738) | org.apache.activemq.broker.BrokerService | WrapperSimpleAppMain
2015-05-04 14:50:33,509 | INFO | Database adapter driver override recognized for : [mysql_connector_java] - adapter: class org.apache.activemq.store.jdbc.adapter.MySqlJDBCAdapter | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | WrapperSimpleAppMain
2015-05-04 14:50:33,575 | INFO | Database lock driver override not found for : [mysql_connector_java]. Will use default implementation. | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | WrapperSimpleAppMain
2015-05-04 14:50:33,578 | INFO | Using a separate dataSource for locking: org.apache.commons.dbcp.BasicDataSource@74aad738 | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | WrapperSimpleAppMain
2015-05-04 14:50:33,580 | INFO | Attempting to acquire the exclusive lock to become the Master broker | org.apache.activemq.store.jdbc.DefaultDatabaseLocker | WrapperSimpleAppMain
2015-05-04 14:50:33,602 | INFO | Becoming the master on dataSource: org.apache.commons.dbcp.BasicDataSource@74aad738 | org.apache.activemq.store.jdbc.DefaultDatabaseLocker | WrapperSimpleAppMain
2015-05-04 14:50:33,642 | WARN | Old message cleanup failed due to: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'activemq.activemq_acks' doesn't exist | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | ActiveMQ JDBC PA Scheduled Task
2015-05-04 14:50:33,645 | WARN | Failure Details: Table 'activemq.activemq_acks' doesn't exist | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | ActiveMQ JDBC PA Scheduled Task
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'activemq.activemq_acks' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.7.0_79]
at sun.reflect.NativeConstructorAccess