+

Search Tips   |   Advanced Search


JDBC provider summary


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

  • One phase only when connecting to WAS run on Windows, supported UNIX systems, or supported Linux systems

  • One and two phase when connecting to WAS for the z/OS platform, using driver type 2

WAS 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

  • In WAS run on z/OS, you cannot use driver type 2 with the XA provider; in this case, use only driver type 4.

  • Does not support V4 data sources in WAS run on z/OS


Cloudscape V10.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.

Version 10.1 cannot be used as a production database. V10.1 can only be used for development and test purposes.

JDBC provider Transaction support Version and other considerations

Derby JDBC Provider

One phase only

  • Not for use in clustered environment: accessible from a single JVM only

  • Does not support V4 data sources

Derby JDBC Provider (XA)

One and two phase

  • Not for use in clustered environment: accessible from a single JVM only

  • Does not support V4 data sources

Derby Network Server Provider using the Universal JDBC driver

Deprecated in WAS v.6.1

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 V4 data sources

Derby Network Server using Derby Client provider

One phase only

  • Can be used in clustered environment: a database instance can be accessed by multiple JVMs

  • Does not support V4 data sources

  • Only for use with Cloudscape 10.1.x databases that run on the same node as WAS

Derby Network Server using Derby Client provider (XA)

One and two phase

  • Can be used in clustered environment: a database instance can be accessed by multiple JVMs

  • Does not support V4 data sources

  • Only for use with Cloudscape 10.1.x databases that run on the same node as WAS


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

  • Only for use with the corresponding driver from DataDirect Technologies

  • V3.5, Service pack 2 of the DataDirect ConnectJDBC type 4 driver can support access to both MS SQL Server 2005 and MS SQL Server 2000

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

  • V3.5, Service pack 2 of the DataDirect ConnectJDBC type 4 driver can support access to both MS SQL Server 2005 and MS SQL Server 2000

IBM WebSphere embedded ConnectJDBC Provider for MS SQL Server One phase only

  • Cannot be used outside of WAS environment

  • V3.5, Service pack 2 of the driver can support access to both MS SQL Server 2005 and MS SQL Server 2000

IBM WebSphere embedded ConnectJDBC Provider for MS SQL Server (XA) One and two phase

  • Cannot be used outside of WAS environment

  • V3.5, Service pack 2 of the driver can support access to both MS SQL Server 2005 and MS SQL Server 2000

 

Related tasks


Configure a JDBC provider using the console