JDBC providers
Installed applications use JDBC providers to interact with relational databases.
The JDBC provider object supplies the specific JDBC driver implementation class for access to a specific vendor database. To create a pool of connections to that database, you associate a data source with the JDBC provider. Together, the JDBC provider and the data source objects are functionally equivalent to the Java EE Connector Architecture (JCA) connection factory, which provides connectivity with a non-relational database.
For a current list of supported providers, see the WAS detailed systems requirements website. For detailed descriptions of the providers, including the supported data source classes and their required properties, refer to the topics on data source required minimum required settings, by vendor.
(zos) Removed support: WebSphere Application Server v8.5 no longer supports the DB2 for zOS Local JDBC Provider (RRS). Version 6.1 and later of the product requires that you migrate your JDBC configurations to the DB2 Using IBM JCC Driver or DB2 Universal JDBC Driver. For instructions, consult the topic on migrating from the JDBC/SQLJ Driver for OS/390 and z/OS to the DB2 Universal JDBC Driver in the Information Management Software for z/OS Solutions Information Center, which is located at http://publib.boulder.ibm.com/infocenter/dzichelp.
Subtopics
- (zos) DB2 Universal JDBC Driver support
This article lists the support details for using the DB2 Universal JDBC Driver with WebSphere Application Server for z/OS.
- Configure QueryTimeout
We can configure a query timeout on the data source of an application so that a Structured Query Language (SQL) statement will be interrupted if it fails to complete execution prior to the specified number of seconds.
Related concepts
(zos) DB2 Universal JDBC Driver support
Data sources
Related tasks
Configure a JDBC provider and data source Configure a JDBC provider using the administrative console Configure a data source using the administrative console Configure a JDBC provider using wsadmin Configure new data sources using wsadmin Configure new WAS40 data sources Create a JDBC provider and data source using the JMX API Configure data access for the Application Client Migrate applications to use data sources of the current Java EE Connector Architecture (JCA)
Data source minimum required settings, by vendor
Related information:
WebSphere Application Server detailed system requirements