ActiveMQ使用笔记（二）ActiveMQ消息持久化(3)

3、JDBC

配置JDBC适配器：

Java

 

1 2 3

<persistenceAdapter>         <jdbcPersistenceAdapter dataSource="#mysql-ds" createTablesOnStartup="false" />     </persistenceAdapter>

dataSource指定持久化数据库的bean，createTablesOnStartup是否在启动的时候创建数据表，默认值是true，这样每次启动都会去创建数据表了，一般是第一次启动的时候设置为true，之后改成false。

MYSQL持久化bean

Java

1 2 3 4 5 6 7

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

SQL Server持久化bean

Java

 

1 2 3 4 5 6 7

<bean id="mssql-ds" class="net.sourceforge.jtds.jdbcx.JtdsDataSource" destroy-method="close">    <property name="serverName" value="SERVERNAME"/>    <property name="portNumber" value="PORTNUMBER"/>    <property name="databaseName" value="DATABASENAME"/>    <property name="user" value="USER"/>    <property name="password" value="PASSWORD"/> </bean>

Oracle持久化bean

Java

 

1 2 3 4 5 6 7 8

<bean id="oracle-ds" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">     <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>     <property name="url" value="jdbc:oracle:thin:@10.53.132.47:1521:activemq"/>     <property name="username" value="activemq"/>     <property name="password" value="activemq"/>     <property name="maxActive" value="200"/>     <property name="poolPreparedStatements" value="true"/>   </bean>

DB2持久化bean

Java

 

1 2 3 4 5 6 7 8

<bean id="db2-ds" class="org.apache.commons.dbcp.BasicDataSource"  destroy-method="close">       <property name="driverClassName" value="com.ibm.db2.jcc.DB2Driver"/>       <property name="url" value="jdbc:db2://hndb02.bf.ctc.com:50002/activemq"/>       <property name="username" value="activemq"/>       <property name="password" value="activemq"/>       <property name="maxActive" value="200"/>       <property name="poolPreparedStatements" value="true"/>   </bean>