WAS v8.5 > Administer applications and their environment > Welcome to administering Service integration > Administer message stores > Administer data stores > Configure a messaging engine to use a data store

Configure a JDBC data source for a messaging engine

If we are using 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.

Restriction: When you are configuring a service integration bus member to use a data store, be aware that using a type 2 JDBC driver for the data store is not supported for configurations where WebSphere MQ server definitions are also used. If wer configuration includes WebSphere MQ server definitions and you are using a data store, use type 4 JDBC drivers.

When creating a new Network Attached Apache Derby data store, by default you get a blank authentication alias.

For Oracle, use the Oracle 10g thin driver for the service integration data store. This driver is compatible with earlier versions of Oracle.

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.

Use the dmgr console to set the data source configuration parameters. Note that your choice of relational database management system (RDBMS) determines the parameters you set.

1. Create a JDBC provider.

   Under General Properties, in the Select the implementation type field, ensure that you select Connection pool data source.

2. Create a data source for the JDBC provider.

   1. Under Additional Properties, ensure that you select Data sources.

   2. Configure the connection pool for the JDBC data source.

      Set the Maximum connections to the number of connections you require, for example, at least 50. The default number of connections is 10.

3. Test the connection using the test connection service provided for validating data source configurations

Related concepts:

JDBC providers
Data sources

Related

Configure a messaging engine data store to use a data source
Create data store tables

+

Search Tips   |   Advanced Search