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 |
|
Derby JDBC Provider (XA) | One and two phase |
|
Derby JDBC Provider 40 | One-phase |
|
Derby JDBC Provider 40 (XA) | One and two phase |
|
Derby Network Server Using Derby Client | One-phase |
|
Derby Network Server Using Derby Client (XA) | One and two phase |
|
Derby Network Server Using Derby Client 40 | One-phase |
|
Derby Network Server Using Derby Client 40 (XA) | One and two phase |
|
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 |
|
DB2 Using IBM JCC Driver (XA) | One and two phase |
|
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 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 |
![]() |