Resumen del proveedor de JDBC

Los proveedores de JDBC son requisitos previos para orígenes de datos que proporcionar a las aplicaciones conexiones físicas con una base de datos.

Utilice estas tablas para una referencia rápida de los proveedores JDBC específicos de la base de datos.

Apache Derby
JDBC provider Transaction support Version and other considerations
Derby JDBC Provider One-phase
  • Does not support Version 4 data sources
  • Configurable only in nodes at version 6.0.2 and later
  • Not for use in clustered environment: accessible from a single JVM only
Derby JDBC Provider (XA) One and two-phase
  • Does not support Version 4 data sources
  • Configurable only in nodes at version 6.0.2 and later
  • Not for use in clustered environment: accessible from a single JVM only
Derby JDBC Provider 40 One-phase
  • Configurable only in nodes at version 7.0 and later
  • Does not support Version 4 data sources
Derby JDBC Provider 40 (XA) One and two-phase
  • Configurable only in nodes at version 7.0 and later
  • Does not support Version 4 data sources
Derby Network Server using Derby Client One-phase
  • Does not support Version 4.0 data sources.
  • Configurable only in nodes at version 6.1 and later
  • Can be used in clustered environment: a database instance can be accessed by multiple JVMs
  • Only for use with Apache Derby databases that run on the same node as the application server
Derby Network Server using Derby Client (XA) One and two-phase
  • Does not support Version 4 data sources
  • Configurable only in nodes at version 6.1 and later
  • Can be used in clustered environment: a database instance can be accessed by multiple JVMs
  • Only for use with Apache Derby databases that run on the same node as the application server
Derby Network Server using Derby Client 40 One-phase
  • Configurable only in nodes at version 7.0 and later
  • Does not support Version 4 data sources
Derby Network Server using Derby Client 40 (XA) One and two-phase
  • Configurable only in nodes at version 7.0 and later
  • Does not support Version 4 data sources
Derby Network Server Provider using the Universal JDBC driver

Deprecated

One-phase
  • Does not support XA
  • Does not support Version 4 data sources
  • Configurable only in nodes at version 6.0.2 and later
  • Can be used in clustered environment: a database instance can be accessed by multiple JVMs
DB2 on AIX, HP-UX, Linux, Solaris, and Windows systems
JDBC provider Transaction support Version and other considerations
DB2 Using IBM JCC Driver One-phase
  • Configurable in nodes that are at version 7.0 and later.
  • [z/OS] Supports only one-phase commit processing, unless you use the application server on z/OS with the type 2 JDBC driver. On the application server for z/OS, the type 2 JDBC driver uses RRS and supports two-phase commit processing.
DB2 Using IBM JCC Driver (XA) One and two-phase
  • Configurable in nodes that are at version 7.0 and later.
  • [z/OS] Do not use the type 2 JDBC driver on the application server for z/OS.
DB2 Universal JDBC Provider One-phase N/A
DB2 Universal JDBC Provider (XA) One and two-phase N/A
DB2 UDB for iSeries
JDBC provider Transaction support Version and other considerations
DB2 UDB for iSeries (Native) One-phase Recommended when you run the application server on iSeries.
DB2 UDB for iSeries (Native XA) One and two-phase Recommended when you run the application server on iSeries.
DB2 UDB for iSeries (Toolbox) One-phase N/A
DB2 UDB for iSeries (Toolbox XA) One and two-phase N/A
DB2 Universal JDBC Provider (XA) One and two-phase
  • Only for use when you run the application server on z/OS.
  • Only driver type 4 is supported
  • Does not support Version 4 data sources
DB2 on z/OS
JDBC provider Transaction support Version and other considerations
DB2 Using IBM JCC Driver One-phase
  • [z/OS] Supports only one-phase commit processing, unless you use the application server on z/OS with the type 2 JDBC driver. On the application server for z/OS, the type 2 JDBC driver uses RRS and supports two-phase commit processing.
  • Configurable in version 7.0 and later nodes.
DB2 Using IBM JCC Driver (XA) One and two-phase
  • [z/OS] Do not use the type 2 JDBC driver on the application server for z/OS.
  • Configurable in nodes that are at version 7.0 and later.
DB2 Universal JDBC Provider

[AIX Solaris HP-UX Linux Windows] [iSeries] One-phase when connecting to the application server that is on AIX, HP-UX, Linux, Solaris, and Windows systems

[z/OS] One and two-phase when you connect to the application server for z/OS with the type 2 JDBC driver.

For two-phase transaction support, use driver type 2. The application server then uses RRS to coordinate transaction processing.
DB2 Universal JDBC Provider (XA) One and two-phase [z/OS]
  • You cannot use driver type 2 with the XA provider; in this case, use only driver type 4.
  • Does not support Version 4 data sources.
Informix
JDBC provider Transaction support Version and other considerations
Informix Using IBM JCC Driver One phase This provider is configurable in nodes that are at version 7.0 and later.
Informix Using IBM JCC Driver (XA) One and two-phase This provider is configurable in nodes that are at version 7.0 and later.
Informix JDBC Provider One-phase N/A
Informix JDBC Provider (XA) One and two-phase N/A
Microsoft SQL Server
JDBC provider Transaction support Version and other considerations
Microsoft SQL Server JDBC Driver One-phase N/A
Microsoft SQL Server JDBC Driver (XA) One and two-phase N/A
DataDirect ConnectJDBC Provider, type 4 driver, for Microsoft SQL Server One-phase N/A
DataDirect ConnectJDBC Provider, type 4 driver, for Microsoft SQL Server (XA) One and two-phase N/A
Oracle
JDBC provider Transaction support Version and other considerations
Oracle JDBC Provider One-phase N/A
Oracle JDBC Provider (XA) One and two-phase N/A
Sybase
JDBC provider Transaction support Version and other considerations
Sybase JDBC 3 Driver One-phase jConnect v6.05
Sybase JDBC 3 Driver (XA) One and two-phase jConnect v6.05
Sybase JDBC 2 Driver One-phase jConnect v5.5
Sybase JDBC 2 Driver (XA) One and two-phase jConnect v5.5



Los enlaces marcados (en línea) requieren acceso a Internet.

Tareas relacionadas


Nombre de fichero: udat_minreq.html