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 >