WAS v8.5 > WebSphere applications > Data access resources > Data conceptsData sources
Applications use a data source to obtain connections to a relational database. A data source is analogous to the 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 required for connecting to your vendor database. Application components transact directly with the data source to obtain connection instances to the database. The connection pool that corresponds to each data source provides connection management.
We 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 vendor database application. WebSphere Application Server 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.
- ConnectionPoolDataSource
Supports application participation in local and global transactions, excepting two-phase commit transactions. When a connection pool data source is involved in a global transaction, transaction recovery is not provided by the transaction manager. The application is responsible for providing the backup recovery process if multiple resource managers are involved.
A connection pool data source does support two-phase commit transactions when the data source is making use of Last participant support, enables a single one-phase commit resource to participate in a global transaction with one or more two-phase commit resources.
- XADataSource
Supports application participation in any single-phase or two-phase transaction environment. When this data source is involved in a global transaction, the product transaction manager provides transaction recovery.
Related
Relational resource adapters and JCA
JDBC providers
Access data from application clients
Configure a JDBC provider
Configure a data source
Configure a JDBC provider using wsadmin
Configure new data sources using wsadmin
Configure new WAS40 data sources using wsadmin.sh
Configure a JDBC provider and data source using the JMX API
Configure data access for application clients using the assembly tool and ACRCT
Create or change a resource reference using the assembly tool
Assemble data access applications using the assembly tool
Deploy data access applications
Develop data access applications
Migrating applications to use data sources of the current JCA
Configure a JDBC provider and data source
Use one-phase and two-phase commit resources in the same transaction