JDBC provider summary

Database type	JDBC Provider	Transaction support	Vand 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 WAS run on iSeries
	DB2 UDB for iSeries (Native XA)	One and two phase	Recommended for use with WAS 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 V4 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 WAS 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 WAS run on z/OS -Does not support V4 data sources in WAS 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 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 V4 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

 

---