Repository: activemq-artemis Updated Branches: refs/heads/master a67838bc3 -> b4ff38ec7
Add info on JDBC Persistence Project: http://git-wip-us.apache.org/repos/asf/activemq-artemis/repo Commit: http://git-wip-us.apache.org/repos/asf/activemq-artemis/commit/481a854f Tree: http://git-wip-us.apache.org/repos/asf/activemq-artemis/tree/481a854f Diff: http://git-wip-us.apache.org/repos/asf/activemq-artemis/diff/481a854f Branch: refs/heads/master Commit: 481a854f6c4e7e072a3d29b23df0af1317ce7683 Parents: a67838b Author: Martyn Taylor <[email protected]> Authored: Tue Jun 7 12:02:47 2016 +0100 Committer: Martyn Taylor <[email protected]> Committed: Tue Jun 7 12:02:47 2016 +0100 ---------------------------------------------------------------------- docs/user-manual/en/persistence.md | 22 ++++++++++++++++++++-- 1 file changed, 20 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/activemq-artemis/blob/481a854f/docs/user-manual/en/persistence.md ---------------------------------------------------------------------- diff --git a/docs/user-manual/en/persistence.md b/docs/user-manual/en/persistence.md index 2d50c42..999d875 100644 --- a/docs/user-manual/en/persistence.md +++ b/docs/user-manual/en/persistence.md @@ -360,13 +360,31 @@ Using aptitude, (e.g. on Ubuntu or Debian system): ## Apache ActiveMQ Artemis JDBC Persistence -The Apache ActiveMQ Artemis JDBC persistence store is still under development and only supports persistence of standard messages and bindings (this is everything except large messages and paging). The JDBC store uses a JDBC connection to store messages and bindings data in records in database tables. The data stored in the database tables is encoded using Apache ActiveMQ Artemis journal encoding. +WARNING: The Apache ActiveMQ Artemis JDBC persistence store is under development and is included for evaluation purposes. + +The Apache ActiveMQ Artemis JDBC persistence layer offers the ability to store broker state (Messages, Addresses and other +application state) using a database. N.B. Address full policy Paging (See: [The section on Paging](paging.md)) is currently not +supported with the JDBC persistence layer. + +Using the ActiveMQ Artemis File Journal is the recommended configuration as it offers higher levels of performance and is +more mature. The JDBC persistence layer is targetted to those users who must use a database e.g. due to internal company +policy. + +ActiveMQ Artemis currently has support for a limited number of database vendors (older versions may work but mileage may +vary): + +1. PostGres 9.4.x +2. MySQL 5.7.x +3. Apache Derby 10.11.1.1 + +The JDBC store uses a JDBC connection to store messages and bindings data in records in database tables. The data stored +in the database tables is encoded using Apache ActiveMQ Artemis internal encodings. ### Configuring JDBC Persistence To configure Apache ActiveMQ Artemis to use a database for persisting messages and bindings data you must do two things. -1. Add the appropriate JDBC client libraries to the Artemis runtime. You can do this by dropping the relevant jars in the lib folder of the ActiveMQ Artemis distribution. +1. Add the appropriate JDBC driver libraries to the Artemis runtime. You can do this by dropping the relevant jars in the lib folder of the ActiveMQ Artemis distribution. 2. create a store element in your broker.xml config file under the <core> element. For example:
