1. Edit Activemq_home/conf/activemq.xml.
<Beans> <BrokerBrokername= "localhost"Persistent= "true"xmlns= "Http://activemq.apache.org/schema/core"> <Persistenceadapter> <JdbcpersistenceadapterDataSource= "#mysql-ds"Usedatabaselock= "false"transactionisolation= "4"/> </Persistenceadapter> </Broker> <BeanID= "Mysql-ds"class= "Org.apache.commons.dbcp.BasicDataSource"Destroy-method= "Close"> < Propertyname= "Driverclassname"value= "Com.mysql.jdbc.Driver"/> < Propertyname= "url"value= "Jdbc:mysql://localhost:3306/activemq?relaxautocommit=true"/> < Propertyname= "username"value= "Activemq"/> < Propertyname= "Password"value= "Activemq"/> < Propertyname= "Maxactive"value= "$"/> < Propertyname= "Poolpreparedstatements"value= "true"/> </Bean></Beans>
2. Add a driver package for the corresponding database in the Activemq_home/lib directory or its subdirectories.
3. Start Activemq, and automatically create three tables in the specified database: Activemq_msgs, Activemq_acks, Activemq_lock.
ActiveMQ (5.10.0)-Persisting messages using JDBC