JDBC provider summary
JDBC providers are prerequisites for data sources, which supply applications with the physical connections to a database.
Apache Derby JDBC provider Transaction support Version and other considerations Derby JDBC Provider One-phase
- Does not support V4 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 V4 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 V4 data sources
Derby JDBC Provider 40 (XA) One and two-phase
- Configurable only in nodes at version 7.0 and later
- Does not support V4 data sources
Derby Network Server using Derby Client One-phase
- Does not support V4.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 appserver
Derby Network Server using Derby Client (XA) One and two-phase
- Does not support V4 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 appserver
Derby Network Server using Derby Client 40 One-phase
- Configurable only in nodes at version 7.0 and later
- Does not support V4 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 V4 data sources
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.
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 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 in nodes that are at version 7.0 and later.
DB2 Universal JDBC Provider One-phase when connecting to the appserver that is on AIX, HP-UX, Linux, Solaris, and Windows 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 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
Related tasks
Set a JDBC provider