6.2. Using the Plain JDBC Adapter
Overview
This section describes how to use the plain JDBC adapter, which is the recommended adapter to use for most applications.
Example
Example 6.3, “Configuring Red Hat JBoss A-MQ to use the Plain JDBC Persistence Adapter” shows a configuration fragment that configures the plain JDBC adapter to use the Apache Derby database.
Example 6.3. Configuring Red Hat JBoss A-MQ to use the Plain JDBC Persistence Adapter
<beans ... > <broker ...> ... 1 <persistenceAdapter> 2 <jdbcPersistenceAdapter dataSource="#derby-ds" /> </persistenceAdapter> ... <broker> ... 3<bean id="derby-ds" class="org.apache.derby.jdbc.EmbeddedDataSource"> <property name="databaseName" value="derbydb"/> <property name="createDatabase" value="create"/> </bean>
The configuration in Example 6.3, “Configuring Red Hat JBoss A-MQ to use the Plain JDBC Persistence Adapter” has three noteworthy elements:
- 1
- The
persistenceAdapterelement wraps the configuration for the JDBC persistence adapter. - 2
- The
jdbcPersistenceAdapterelement specifies that the broker will use the plain JDBC persistence adapter and that the JDBC driver's configuration is specified in abeanelement with the ID,derby-ds. - 3
- The
beanelement specified the configuration for the Derby JDBC driver.
Configuration
Table 6.1, “Attributes for Configuring the Plain JDBC Persistence Adapter” describes the attributes used to configure the plain JDBC persistence adapter.
| Attribute | Default Value | Description |
|---|---|---|
adapter | Specifies the strategy to use when accessing a non-supported database. For more information see the section called “Using generic JDBC providers”. | |
cleanupPeriod | 300000 | Specifies, in milliseconds, the interval at which acknowledged messages are deleted. |
createTablesOnStartup | true | Specifies whether or not new database tables are created when the broker starts. If the database tables already exist, the existing tables are reused. |
dataDirectory | activemq-data | Specifies the directory into which the default Derby database writes its files. |
dataSource | #derby | Specifies the id of the Spring bean storing the JDBC driver's configuration. For more information see the section called “Configuring your JDBC driver”. |
transactionIsolation | Connection.TRANSACTION_READ_UNCOMMITTED | Specifies the required transaction isolation level. For allowed values, see java.sql.Connection. |
useLock | true | Specifies in the adapter uses file locking. |
lockKeepAlivePeriod | 30000 | Specifies the time period, in milliseconds, at which the current time is saved in the locker table to ensure that the lock does not timeout. 0 specifies unlimited time. |
