WebSphere WebSphere Application Server Express, Version 6.0.x Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Configuring a messaging engine to use a data source

Use this task to configure a messaging engine to use a data source.

Before you begin

Note: You must have already set up a data store and configured a data source. For more information, refer to Setting up the data store for a messaging engine.

Why and when to perform 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 administrative console to set the data store configuration parameters.

Perform the following steps to configure the messaging engine to use a data source:

Steps for this task

Configure the data store. Use the administrative console to complete the following steps
  1. In the navigation pane, click Service Integration > Buses.
  2. In the content pane, click the name of the bus to which your messaging engine belongs.
  3. Under Additional Properties, click Messaging engines. A list of messaging engines displays.
  4. Click the messaging engine name.
  5. Under Additional Properties, click Data store.
  6. Under General Properties, 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, ensure that you specify the schema name in lower case.
    Authentication alias
    Select the authentication alias that enables access to the data source.
    Cloudscape tip: If you use the Cloudscape Network Attach mode, you must specify an authentication alias. Cloudscape itself does not require this authentication alias, but the DB2 Universal JDBC Driver, which Cloudscape uses when running in Network Attached mode, does require an alias.
    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.
    DB2 for z/OS restriction: The option for WebSphere Application Server to create the tables is not available with DB2 for z/OS. Do not select Create tables, otherwise an exception will be thrown when WebSphere Application Server attempts to create the tables. Refer to Enabling your database administrator to create the data store tables if you use DB2 for z/OS.
Related tasks
Configuring a JDBC data source
Enabling your database administrator to create the data store tables

Task topic

Terms of Use | Feedback

Last updated: 2 Aug 2005
http://publib.boulder.ibm.com/infocenter/ws60help/index.jsp?topic=/com.ibm.websphere.pmc.express.doc\tasks\tjm0045_.html

© Copyright IBM Corporation 2004, 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)