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.
DB2 on Windows, supported UNIX systems, or supported Linux systems | ||
---|---|---|
JDBC provider | Transaction support | Version and other considerations |
DB2 Universal JDBC Provider | One phase only | |
DB2 Universal JDBC Provider (XA) | One and two phase |
DB2 UDB for iSeries | ||
---|---|---|
JDBC provider | Transaction support | Version and other considerations |
DB2 UDB for iSeries (Toolbox) | One phase only | |
DB2 UDB for iSeries (Toolbox XA) | One and two phase |
DB2 on z/OS | ||
---|---|---|
JDBC provider | Transaction support | Version and other considerations |
DB2 Universal JDBC Provider |
|
WebSphere Application Server for the z/OS platform only: For two-phase transaction support, use driver type 2. Application Server then uses RRS to coordinate transaction processing. |
DB2 Universal JDBC Provider (XA) | One and two phase |
|
Cloudscape Version 10.1.x Because
the Cloudscape v10.1.x code base is the product of the Open Source Apache
Derby Project, Cloudscape v10.1.x uses Derby JDBC classes.
Restriction: Version
10.1 cannot be used as a production database. Version 10.1 can only be
used for development and test purposes.
|
||
---|---|---|
JDBC provider | Transaction support | Version and other considerations |
Derby JDBC Provider |
One phase only |
|
Derby JDBC Provider (XA) |
One and two phase |
|
Derby Network Server Provider using the Universal JDBC driver Deprecated in WebSphere Application Server v.6.1 |
One phase only |
|
Derby Network Server using Derby Client provider |
One phase only |
|
Derby Network Server using Derby Client provider (XA) |
One and two phase |
|
Informix | ||
---|---|---|
JDBC provider | Transaction support | Version and other considerations |
Informix JDBC Provider | One phase only | |
Informix JDBC Provider (XA) | One and two phase |
Sybase | ||
---|---|---|
JDBC provider | Transaction support | Version and other considerations |
Sybase jConnect for JDBC Provider | One phase only | |
Sybase jConnect for JDBC Provider (XA) | One and two phase |
Oracle | ||
---|---|---|
JDBC provider | Transaction support | Version and other considerations |
Oracle JDBC Provider | One phase only | |
Oracle JDBC Provider(XA) | One and two phase |
Microsoft SQL Server | ||
---|---|---|
JDBC provider | Transaction support | Version and other considerations |
DataDirect ConnectJDBC Provider, type 4 driver, for MS SQL Server | One phase only |
|
DataDirect ConnectJDBC Provider, type 4 driver, for MS SQL Server (XA) | One and two phase |
|
IBM WebSphere embedded ConnectJDBC Provider for MS SQL Server | One phase only |
|
IBM WebSphere embedded ConnectJDBC Provider for MS SQL Server (XA) | One and two phase |
|