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)), 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	Cloudscape JDBC Provider	One phase only	- Not for use in clustered environment: 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 clustered environment: accessible from a single JVM only - Does not support Version 4 data sources
	Cloudscape Network Server Provider using the Universal JDBC driver	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 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	One phase only	- Not for use in clustered environment: accessible from a single JVM only - Does not support Version 4 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 Version 4 data sources
	Derby Network Server Provider using the Universal JDBC driver	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 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

Related tasks

Configuring a JDBC provider using the administrative console