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), using the Legacy DB2 for z/OS JDBC Driver | 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 |
![]() ![]() ![]() |
![]() ![]() ![]() |
![]() ![]() ![]() - Not for use in clustered environment: accessible from a single JVM only - Does not support Version 4 data sources |
![]() ![]() ![]() |
![]() ![]() ![]() |
![]() ![]() ![]() - Not for use in clustered environment: accessible from a single JVM only - Does not support Version 4 data sources |
|
![]() ![]() ![]() |
![]() ![]() ![]() |
![]() ![]() ![]() - 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 |
|
![]() Derby Restriction: Derby Version 10.0 cannot be used as a production database.
Derby Version 10.0 can only be used for development and test purposes.
No restriction: Derby Version 10.1 can be used in
production environments as well as in development and test environments.
|
![]() Derby JDBC Provider |
![]() |
![]() - Not for use in clustered environment: accessible from a single JVM only - Does not support Version 4 data sources |
![]() Derby JDBC Provider (XA) |
![]() |
![]() - Not for use in clustered environment: accessible from a single JVM only - Does not support Version 4 data sources |
|
![]() Derby Network Server Provider using the Universal JDBC driver |
![]() |
![]() - 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 Provider | One phase only | |
Informix JDBC Provider (XA) | One and two phase | ||
Sybase | Sybase jConnect for JDBC Provider | One phase only | |
Sybase jConnect for JDBC Provider (XA) | One and two phase | ||
Oracle | Oracle JDBC Provider | One phase only | |
Oracle JDBC Provider(XA) | One and two phase | ||
MS SQL Server | DataDirect ConnectJDBC Provider, type 4 driver, for MS SQL Server | One phase only | Only for use with the corresponding driver from DataDirect Technologies |
DataDirect ConnectJDBC Provider, 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 Provider for MS SQL Server | One phase only | Cannot be used outside of WebSphere Application Server environment |
|
WebSphere embedded ConnectJDBC Provider for MS SQL Server (XA) | One and two phase | Cannot be used outside of WebSphere Application Server environment |