If you 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.
Before you begin
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 your configuration includes WebSphere MQ
server definitions and you are using a data store, you must use type 4 JDBC
drivers.
Oracle Tip: Use the Oracle 10g thin driver for the
service integration data store. This driver is compatible with earlier versions
of Oracle.
About this task
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 that contains the data
store for that messaging engine.
Use the administrative console to set
the data source configuration parameters. Note that your choice of relational
database management system (RDBMS) determines the parameters you set.
Procedure
- Create a JDBC provider. See Configuring a JDBC provider using the administrative console. Under General Properties,
in the Select the implementation type field, ensure
that you select Connection pool data source.
For information
about the settings for your chosen RDBMS, see Data source minimum required settings, by vendor.
- Create a data source for the JDBC provider.
Refer to Configuring a data source using the administrative console.
- Under Additional Properties, ensure that
you select Data sources.
- 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. For more information, see Tuning the JDBC data source of a messaging engine.
- Test the connection by using the test connection service provided
for validating data source configurations See Test connection service.