WebSphere Application Server Network Deployment, Version 6.0.x     Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

JDBC provider summary

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

[Version 6.0.2]or Derby

Cloudscape JDBC Provider One phase only

- Not for use in clustering environment: Cloudscape is 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 clustering environment: Cloudscape is accessible from a single JVM only

- Does not support Version 4 data sources

Cloudscape Network Server using Universal JDBC driver One phase only Does not support Version 4 data sources

[Version 6.0.2]Derby JDBC Provider

One phase only

- Not for use in clustering environment: Derby is accessible from a single JVM only

- Does not support Version 4 data sources

[Version 6.0.2]Derby Network Server using Universal JDBC driver

One phase only 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

- Not available for Application Server on z/OS

- Cannot be used outside of WebSphere Application Server environment

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

- Not available for Application Server on z/OS

- Cannot be used outside of WebSphere Application Server environment

Reference topic    

Terms of Use | Feedback

Last updated: Mar 17, 2005 4:28:29 AM CST
http://publib.boulder.ibm.com/infocenter/ws60help/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/udat_minreq.html

© Copyright IBM Corporation 2002, 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)