Database type | JDBC Provider | Transaction support | Version and other considerations |
---|---|---|---|
DB2 on Windows, UNIX, or workstation-based LINUX | DB2 Universal JDBC Provider | One phase only | |
DB2 Universal JDBC Provider (XA) | One and two phase | The XA implementation is not supported in WebSphere Application Server run on workstation-based LINUX |
|
DB2 legacy CLI-based Type 2 JDBC Provider | One phase only | ||
DB2 legacy CLI-based Type 2 JDBC Provider (XA) | One and two phase | ||
DB2 UDB for iSeries | DB2 UDB for iSeries (Native) | One phase only | Recommended for use with WebSphere Application Server run on iSeries |
DB2 UDB for iSeries (Native XA) | One and two phase | Recommended for use with WebSphere Application Server run on iSeries |
|
DB2 UDB for iSeries (Toolbox) | One phase only | ||
DB2 UDB for iSeries (Toolbox XA) | One and two phase | ||
DB2 Universal JDBC Provider (XA) | One and two phase | -Only for use with WebSphere Application Server run on z/OS -Only driver type 4 is supported -Does not support Version 4 data sources |
|
DB2 legacy CLI-based Type 2 JDBC Provider | One phase only | -Only for use with WebSphere Application Server run on Windows, UNIX, or workstation-based LINUX - Requires the DB2 Connect driver (available from DB2) |
|
DB2 legacy CLI-based Type 2 JDBC Provider (XA) | One and two phase | -Only for use with WebSphere Application Server run on Windows, UNIX, or workstation-based LINUX - Requires the DB2 Connect driver (available from DB2) |
|
DB2 on z/OS | DB2 for z/OS Local JDBC Provider (RRS) | One and two phase | Only for use with WebSphere Application Server run on z/OS |
DB2 Universal JDBC Provider | One phase only | ||
DB2 Universal JDBC Provider (XA) | One and two phase | -Only driver type 4 is supported in WebSphere Application Server run on z/OS -Does not support Version 4 data sources in WebSphere Application Server run on z/OS |
|
DB2 legacy CLI-based Type 2 JDBC Provider | One phase only | -Only for use with WebSphere Application Server run on Windows, UNIX, or workstation-based LINUX - Requires the DB2 Connect program (available from DB2) |
|
DB2 legacy CLI-based Type 2 JDBC Provider (XA) | One and two phase | -Only for use with WebSphere Application Server run on Windows, UNIX, or workstation-based LINUX - Requires the DB2 Connect program (available from DB2) |
|
Cloudscape | Cloudscape JDBC Provider | One phase only | - Not for use in clustered environment: accessible from a single JVM only - Does not support Version 4 data sources |
Cloudscape JDBC Provider (XA) | One and two phase | - Not for use in clustered environment: accessible from a single JVM only - Does not support Version 4 data sources |
|
Cloudscape Network Server using Universal JDBC driver | One phase only | - Can be used in clustered environment: a database instance can be accessed by multiple JVMs - Does not support XA - Does not support Version 4 data sources |
|
Use Derby Version 10 only for development and test purposes. |
|
One phase only | - Not for use in clustered environment: accessible from a single JVM only - Does not support Version 4 data sources |
|
One and two phase | - Not for use in clustered environment: accessible from a single JVM only - Does not support Version 4 data sources |
|
|
One phase only | - Can be used in clustered environment: a database instance can be accessed by multiple JVMs - Does not support XA - Does not support Version 4 data sources |
|
Informix | Informix JDBC Driver | One phase only | |
Informix JDBC Driver (XA) | One and two phase | ||
Sybase | Sybase JDBC Driver | One phase only | |
Sybase JDBC Driver (XA) | One and two phase | ||
Oracle | Oracle JDBC Driver | One phase only | |
Oracle JDBC Driver (XA) | One and two phase | ||
MS SQL Server | DataDirect ConnectJDBC type 4 driver for MS SQL Server | One phase only | Only for use with the corresponding driver from DataDirect Technologies |
DataDirect ConnectJDBC type 4 driver for MS SQL Server (XA) | One and two phase | Only for use with the corresponding driver from DataDirect Technologies | |
WebSphere embedded ConnectJDBC driver for MS SQL Server | One phase only | Cannot be used outside of WebSphere Application Server environment |
|
WebSphere embedded ConnectJDBC driver for MS SQL Server (XA) | One and two phase | Cannot be used outside of WebSphere Application Server environment |