JDBC provider summary

JDBC provider summary

JDBC providers are prerequisites for data sources, which supply applications with the physical connections to a database.
Use these tables for quick reference on database-specific JDBC providers.

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.

Apache Derby
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. 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.
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
(iseries) DB2 UDB for iSeries (Native) One-phase Recommended when you run the application server on iSeries.
(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
(zos) 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 Configurable in version 7.0 and later nodes.
DB2 Using IBM JCC Driver (XA) One and two phase Configurable version 7.0 and later nodes.
DB2 Universal JDBC Provider One-phase when connecting to the application server that is on AIX, HP-UX, Linux, Solaris, Windows, and iSeries systems.

DB2 Universal JDBC Provider (XA) One and two phase

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 Driver One-phase N/A
Informix JDBC Driver (XA) One and two phase N/A
Informix using IBM DB2 JDBC Universal Driver One phase This provider is configurable in nodes that are at version 7.0 and later.
Informix using IBM DB2 JDBC Universal Driver (XA) One and two phase This provider is configurable in nodes that are at version 7.0 and later.

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 MS SQL Server One-phase N/A
DataDirect ConnectJDBC Provider, type 4 driver, for MS SQL Server (XA) One and two phase N/A

Oracle
JDBC provider Transaction support Version and other considerations
Oracle JDBC Driver One-phase Must use the ojdbc6.jar driver to connect to any version of Oracle database.
Oracle JDBC Driver(XA) One and two phase Must use the ojdbc6.jar driver to connect to any version of Oracle database.

Sybase
JDBC provider Transaction support Version and other considerations
Sybase JDBC 4 Driver One-phase jConnect v7.0
Sybase JDBC 4 Driver (XA) One and two phase jConnect v7.0
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

Deprecated feature: Support for Sybase jConnect 5.5 is deprecated. We might want to use a later provider that uses Sybase jConnect 6.05 or jConnect 7.0.depfeat

Reference topic

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.

Apache Derby
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. 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.
DB2 Universal JDBC Provider	One-phase	N/A
DB2 Universal JDBC Provider (XA)	One and two phase	N/A