Data source minimum required settings, by vendor


 

+

Search Tips   |   Advanced Search

 

Use these tables for quick reference to JDBC provider driver classes.

Following the tables are links to detailed requirements for creating data sources that correspond to each JDBC provider, including information about connection and optional properties.

Use the admin console or the wsadmin scripting tool to define these properties on the data sources.

Apache Derby
JDBC provider Transaction support Considerations
Derby JDBC Provider One-phase

  • Does not support V4 data sources
  • Configurable only in nodes at version 6.0.2 and later
  • Not for use in clustered environment: accessible from a single JVM only
Derby JDBC Provider (XA) One and two-phase

  • Does not support V4 data sources
  • Configurable only in nodes at version 6.0.2 and later
  • Not for use in clustered environment: accessible from a single JVM only

Derby JDBC Provider 40 One-phase

  • Configurable only in nodes at version 7.0 and later
  • Does not support V4 data sources

Derby JDBC Provider 40 (XA) One and two-phase

  • Configurable only in nodes at version 7.0 and later
  • Does not support V4 data sources

Derby Network Server using Derby Client One-phase

  • Does not support V4.0 data sources.
  • Configurable only in nodes at version 6.1 and later
  • Can be used in clustered environment: a database instance can be accessed by multiple JVMs
  • Only for use with Apache Derby databases that run on the same node as the appserver

Derby Network Server using Derby Client (XA) One and two-phase

  • Does not support V4 data sources
  • Configurable only in nodes at version 6.1 and later
  • Can be used in clustered environment: a database instance can be accessed by multiple JVMs
  • Only for use with Apache Derby databases that run on the same node as the appserver

Derby Network Server using Derby Client 40 One-phase

  • Configurable only in nodes at version 7.0 and later
  • Does not support V4 data sources

Derby Network Server using Derby Client 40 (XA) One and two-phase

  • Configurable only in nodes at version 7.0 and later
  • Does not support V4 data sources

DB2 on AIX, HP-UX, Linux, Solaris, and Windows systems
JDBC provider Transaction support Version and other considerations
DB2 Using IBM JCC Driver One-phase Configurable in nodes that are at version 7.0 and later.
DB2 Using IBM JCC Driver (XA) One and two-phase Configurable in nodes that are at version 7.0 and later.
DB2 Universal JDBC Provider One-phase N/A
DB2 Universal JDBC Provider (XA) One and two-phase N/A

DB2 UDB for iSeries
JDBC provider Transaction support Version and other considerations
DB2 UDB for iSeries (Toolbox) One-phase N/A
DB2 UDB for iSeries (Toolbox XA) One and two-phase N/A

DB2 on z/OS
JDBC provider Transaction support Version and other considerations
DB2 Using IBM JCC Driver One-phase Configurable in version 7.0 and later nodes.
DB2 Using IBM JCC Driver (XA) One and two-phase Configurable in nodes that are at version 7.0 and later.
DB2 Universal JDBC Provider

One-phase when connecting to the appserver that is on AIX, HP-UX, Linux, Solaris, and Windows systems

 
DB2 Universal JDBC Provider (XA) One and two-phase  

Informix
JDBC provider Transaction support Version and other considerations
Informix Using IBM JCC Driver One phase Configurable in nodes that are at version 7.0 and later.
Informix Using IBM JCC Driver (XA) One and two-phase Configurable in nodes that are at version 7.0 and later.
Informix JDBC Provider One-phase N/A
Informix JDBC Provider (XA) One and two-phase N/A

Microsoft SQL Server
JDBC provider Transaction support Version and other considerations
Microsoft SQL Server JDBC Driver One-phase N/A
Microsoft SQL Server JDBC Driver (XA) One and two-phase N/A
DataDirect ConnectJDBC Provider, type 4 driver, for Microsoft SQL Server One-phase N/A
DataDirect ConnectJDBC Provider, type 4 driver, for Microsoft SQL Server (XA) One and two-phase N/A

Oracle
JDBC provider Transaction support Version and other considerations
Oracle JDBC Provider One-phase N/A
Oracle JDBC Provider (XA) One and two-phase N/A

Sybase
JDBC provider Transaction support Version and other considerations
Sybase JDBC 3 Driver One-phase jConnect v6.05
Sybase JDBC 3 Driver (XA) One and two-phase jConnect v6.05
Sybase JDBC 2 Driver One-phase jConnect v5.5
Sybase JDBC 2 Driver (XA) One and two-phase jConnect v5.5

 

Detailed requirements

The following list identifies required class files and connection properties per JDBC provider.

After you determine the JDBC provider that suits the application and environment, ensure that you acquire the corresponding JDBC driver at a release level supported by this version of the appserver. Consult the IBM support website for supported hardware and software. Use the following links to navigate to the requirements list. Each link corresponds to a specific database vendor, product, and platform.




Subtopics


Data source minimum required settings for Apache Derby
Data source minimum required settings for DB2 with the appserver on AIX, HP-UX, Linux, Solaris, or Windows
Data source minimum required settings for DB2 Universal Database for IBM i
Data source minimum required settings for Informix
Data source minimum required settings for Microsoft SQL Server
Data source minimum required settings for Oracle
Data source minimum required settings for Sybase

 

Related concepts

Data sources
Relational resource adapters and JCA
JDBC providers

 

Related tasks

Set a JDBC provider and data source
Set a JDBC provider
Set a data source
Create and configuring a JDBC provider and data source using the JMX API

 

Related information

WAS Supported hardware and software
DB2 product Web pages
DB2 for z/OS product Web pages
Information Management Software for z/OS Solutions Information Center