These properties vary according to the database vendor requirements
for Java™ Database
Connectivity (JDBC) driver implementations. You must set the appropriate properties
on every data source that you configure.
Use these tables for quick reference on the JDBC providers that represent
your JDBC driver classes. Each table corresponds to a specific database vendor,
product, and platform.
Following the tables are links to detailed
requirements for creating data sources that correspond to each JDBC
provider that the application server supports . The list includes information
about connection properties that are required by the database and any optional
properties that the JDBC driver supports. Use the administrative console or
the wsadmin scripting tool to define these properties on your data sources.
Table 1. Apache Derby JDBC providers. Use
the table for quick reference on database-specific JDBC providers.
Apache Derby |
JDBC provider |
Transaction support |
Version and other considerations |
Derby JDBC Provider |
One-phase |
- Does not support Version 4 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 Version 4 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 Version 4 data sources
|
Derby JDBC Provider 40 (XA) |
One and two-phase |
- Configurable only in nodes at version 7.0 and later
- Does not support Version 4 data sources
|
Derby Network Server using Derby Client |
One-phase |
- Does not support Version 4.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 application server
|
Derby Network Server using Derby Client (XA) |
One and two-phase |
- Does not support Version 4 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 application server
|
Derby Network Server using Derby Client 40 |
One-phase |
- Configurable only in nodes at version 7.0 and later
- Does not support Version 4 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 Version 4 data sources
|
Table 2. DB2 on AIX, HP-UX, Linux, Solaris and
Windows systems JDBC providers. Use the table for quick
reference on database-specific JDBC providers.
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.
Supports only one-phase commit processing, unless
you use the application server on z/OS with the type 2 JDBC driver.
On the application server for z/OS, the type 2 JDBC driver uses RRS
and supports two-phase commit processing.
|
DB2 Using IBM JCC Driver (XA) |
One and two-phase |
- Configurable in nodes that are at version 7.0 and later.
Do not use the type 2 JDBC driver on the application
server for z/OS.
|
DB2 Universal JDBC Provider |
One-phase |
N/A |
DB2 Universal JDBC Provider (XA) |
One and two-phase |
N/A |
Table 3. DB2 UDB for iSeries JDBC providers. Use the table for quick reference on database-specific JDBC
providers.
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 Universal JDBC Provider (XA) |
One and two-phase |
- Only for use when you run the application server on z/OS.
- Only driver type 4 is supported
- Does not support Version 4 data sources
|
Table 5. Informix JDBC providers. Use
the table for quick reference on database-specific JDBC providers.
Informix |
JDBC provider |
Transaction support |
Version and other considerations |
Informix Using IBM JCC Driver |
One phase |
This provider is configurable in nodes that
are at version 7.0 and later. |
Informix Using IBM JCC Driver (XA) |
One and two-phase |
This provider is 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 |
Table 6. Microsoft SQL Server JDBC providers. Use the table for quick reference on database-specific JDBC
providers.
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 |
Table 7. Oracle JDBC providers. Use
the table for quick reference on database-specific JDBC providers.
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 |
Table 8. Sybase JDBC providers. Use the table for quick reference on database-specific JDBC
providers.
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 your application and environment,
ensure that you acquire the corresponding JDBC driver at a release level supported
by this version of the application server. 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.