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

Configuring a JDBC data source for a messaging engine

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

Before you begin

Restriction:
DB2 Tip:
To use a DB2 Universal JDBC Driver to access the default database (embedded Cloudscape) that is supplied with WebSphere Application Server, you need to create an authentication alias. This requirement is documented in Vendor-specific data sources minimum required settings. After creating the authentication alias, you configure the messaging engine as described in Modify data store configurations.
Note: This requirement only applies to embedded Cloudscape. If you are using Cloudscape Network Server, you do not need to create an authentication alias.
Oracle Tip: Use the Oracle 10g thin driver for the service integration data store. This driver is compatible with earlier versions of Oracle.

Why and when to perform this task

Each messaging engine has its own data store. Amessaging 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 source configuration parameters. Note that your choice of relational database management system (RDBMS) determines the parameters you set.

Perform the following steps to configure the data source:

Steps for this task

  1. Create a JDBC provider. Refer to Creating and 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, refer to Vendor-specific data sources minimum required settings.

  2. Create a data source for the JDBC provider. Refer to Creating and configuring a data source using the administrative console.
    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. For more information, refer to Tuning the JDBC data source of a messaging engine.
  3. Test the connection. Refer to Test connection.
Related concepts
JDBC providers
Data sources
Related tasks
Modify data store configurations
Creating the tables

Task topic

Terms of Use | Feedback

Last updated: 15 Mar 2007
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.pmc.nd.doc\tasks\tjm0040_.html

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