Configure a messaging engine to use a data store
Although the default message store for a typical messaging engine is file store, we can also configure a messaging engine to use a data store.
Each messaging engine has its own file store or data store. If the data store is chosen the messaging engine uses an instance of a JDBC data source to interact with the database containing the data store for that messaging engine.
When a new messaging engine that uses a data store is created on a single server, it is configured to use an Apache Derby data source by default. This enables the messaging engine to run without needing any additional configuration.
To configure a new messaging engine to use the chosen data source when creating that messaging engine on a single server, see Add a server as a new bus member.
When a messaging engine is created as a member of a cluster, you must explicitly configure both the data store and the JDBC data source that the messaging engine uses to interact with the data store. We must also set Purge policy to EntirePool. For more information, see Tune the JDBC data source of a messaging engine.
If we do not want to use the default data source configuration, we can use the WAS console to change the configuration parameters. For example, we can change the data source or we can configure the data store to use a different JDBC provider.
If we configure a new messaging engine to use the chosen data source when creating that messaging engine as a member of a cluster, see Add a server as a new bus member.
Supported configurations: WebSphere Application Server supports direct customer use of the Apache Derby database in test environments only. The product does not support direct customer use of Apache Derby database in production environments. The product supports the use of Apache Derby only by internal application server componentsf in production environments.
Subtopics
- Create the database, schema and user ID for a messaging engine
Before the data store for a messaging engine can be set up, first create the database, the schema and the database user ID that the messaging engine needs to access the data store tables.
- Create data store tables
When we create the data store tables, we have two options. We can either choose that WebSphere Application Server does it automatically, or that the database administrator does it manually.
- Configure a JDBC data source for a messaging engine
For a data store for a messaging engine, the messaging engine uses an instance of JDBC data source to interact with the database containing the data store.
- Configure a messaging engine data store to use a data source
After configuring a JDBC data source, we can configure a messaging engine data store to use the data source.
- Configure a data source for a messaging engine running in a cluster
Methods that we can use to configure a data source for a messaging engine depend on the cluster in which you intend to run the messaging engine.
Subtopics
- Create the database, schema and user ID for a messaging engine
Before the data store for a messaging engine can be set up, first create the database, the schema and the database user ID that the messaging engine needs to access the data store tables.
- Create data store tables
When we create the data store tables, we have two options. We can either choose that WebSphere Application Server does it automatically, or that the database administrator does it manually.
- Configure a JDBC data source for a messaging engine
For a data store for a messaging engine, the messaging engine uses an instance of JDBC data source to interact with the database containing the data store.
- Configure a messaging engine data store to use a data source
After configuring a JDBC data source, we can configure a messaging engine data store to use the data source.
- Configure a data source for a messaging engine running in a cluster
Methods that we can use to configure a data source for a messaging engine depend on the cluster in which you intend to run the messaging engine.
Related concepts
Bus members
Related tasks
Add a messaging engine to a cluster Tune the JDBC data source of a messaging engine Add a server as a new bus member
Related information:
Data store [Settings]