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

Configuring a JDBC data source

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

Why and when to perform this task

Each messaging engine has its own data store. 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 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
Configuring a messaging engine to use a data source
Creating the 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\tjm0040_.html

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