After setting
up a data store and configuring its data source, you can configure a messaging
engine to use the data source.
About this task
A 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 WebSphere Application Server administrative console to set the data store
configuration parameters.
Perform the following steps to configure the
messaging engine to use a data source using the administrative console:
Procedure
- In the navigation pane, click .
- In the content pane, click the name of the bus to which your messaging
engine belongs.
- Under Topology, click Messaging
engines. A list of messaging engines is displayed.
- Click the messaging engine name.
- On the Configuration pane, find the Message
store type option, which is Data store.
- Click on the Configure button.
- On a new page, specify the following properties:
- Data source name
- Type the JNDI name of the data source that provides access to database
that holds the data store.
- Schema name
- Type the name of the database schema that contains the tables used by
the data store.
General tip: The schema name
is usually the same as the user ID that is declared in the authentication
alias. With some databases, for example DB2, you can provide an alternative
schema name. For more information about the relationship between users and
schema, refer to the documentation for your chosen RDBMS.
Informix tip: When you configure your messaging engine
to use an Informix database, you must specify the schema name in lower case.
When starting, a messaging engine that uses a data store
checks to see if its data store exists. If the user has selected the Create
tables option in the configuration, whose tick-box is ticked by default,
the messaging engine creates the tables in its chosen schema.
The
Schema
name field is optional, and:
- The default schema name is IBMWSSIB.
- If you delete the text so that field is blank, the messaging engine takes
the user id defined in the authentication alias to be the schema name.
- If you define a schema name explicitly, that schema name is used by the
messaging engine.
- Authentication alias
- Select the authentication alias that enables access to the data source.
- Create tables
- Select the check box if you want WebSphere Application Server to
create the database tables automatically. For more information, refer to Creating the tables.
Note: The user ID that the
data store uses to connect to the data source must have sufficient authority
to create the database tables and indexes.
- Number of permanent tables
- Permanent table contains persistent objects for the data store.
Note: You
can only increase the number of permanent tables or temporary tables, not
decrease them.
See related links for more information.
- Number of temporary tables
- Temporary tables nonpersistent objects that have been saved to the data
store to reduce the messaging engine memory requirement.
Note: You can only
increase the number of permanent tables or temporary tables, not decrease
them.
See related links for more information.