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.
Table 1. Apache Derby JDBC providers . Use
the table 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
|
Table 2. DB2 on AIX, HP-UX, Linux, Solaris, and Windows systems JDBC providers . Use
the table for quick reference on database-specific JDBC providers.
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 |
Table 3. DB2 UDB
for iSeries JDBC providers . Use the table for quick reference on database-specific JDBC
providers.
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 |
Table 4. DB2 on z/OS JDBC providers . Use
the table for quick reference on database-specific JDBC providers.
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 |
|
Table 5. Informix JDBC
providers . Use the table for quick reference on database-specific
JDBC providers.
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. |
Table 6. Microsoft SQL
Server JDBC providers . Use the table for quick reference
on database-specific JDBC providers.
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 |
Table 7. Oracle JDBC providers . Use
the table for quick reference on database-specific JDBC providers.
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. |
Table 8. Sybase JDBC providers . Use
the table for quick reference on database-specific JDBC providers.
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. You might
want to use a later provider that uses Sybase jConnect 6.05 or jConnect
7.0.
|