WebSphere Enterprise Service Bus for z/OS, Version 6.2.0 Operating Systems: z/OS


Data sources

Data sources provide the link between applications and relational databases.

Applications use a data source to obtain connections to a relational database. A data source is analogous to the J2EE Connector Architecture (JCA) connection factory, which provides connectivity to other types of enterprise information systems (EIS).

A data source is associated with a JDBC provider, which supplies the driver implementation classes that are required for JDBC connectivity with a specific type of database. Application components transact directly with the data source to obtain connection instances to your database. The connection pool that corresponds to each data source provides connection management.

You can create multiple data sources with different settings, and associate them with the same JDBC provider. For example, you might use multiple data sources to access different databases within the same database application. WebSphere® ESB requires JDBC providers to implement one or both of the following data source interfaces, which are defined by Sun Microsystems. These interfaces enable the application to run in a single-phase or two-phase transaction protocol.

The following tables provide examples of typical stand-alone and typical deployment environment setups:
Table 1. Typical stand-alone environment setup
Datasource Component Scope JNDI Name
WBI DataSource CommonDB Node jdbc/WPSDB
SCA Application Bus ME data source SCA ME Server jdbc/com.ibm.ws.sib/nlNode01.server1-SCA.APPLICATION.localhostNode01Cell.Bus
Business Process Choreographer data source BPC Server jdbc/BPEDB
Business Process Choreographer ME data source BPC ME Server jdbc/com.ibm.ws.sib/nlNode01.server1-BPC.localhostNode01Cell.Bus
event CEI Server jdbc/cei
CEI ME data source CEI ME Server jdbc/com.ibm.ws.sib/nlNode01.server1-CommonEventInfrastructure_Bus
Table 2. Typical deployment environment setup
Datasource Component Scope JNDI Name
WBI DataSource CommonDB Cell jdbc/WPSDB
SCA Application Bus ME data source SCA ME Cluster jdbc/com.ibm.ws.sib/clusterone-SCA.APPLICATION.enduranceTestCell01.Bus
Business Process Choreographer data source BPC Cluster jdbc/BPEDB
Business Process Choreographer ME data source BPC ME Cluster jdbc/com.ibm.ws.sib/clusterone-BPC.enduranceTestCell01.Bus
event CEI Cluster jdbc/cei
CEI ME data source CEI ME Cluster jdbc/com.ibm.ws.sib/clusterone-CommonEventInfrastructure_Bus

For more information on data sources, see "Data sources" in theWebSphere Application Server information center.


concept Concept topic

Terms of use | Feedback


Timestamp icon Last updated: 21 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic//com.ibm.websphere.wesb620.zseries.doc/doc/cins_datasources.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).