JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Configuring Project Components for Oracle Java CAPS Database Adapters     Java CAPS Documentation
search filter icon
search icon

Document Information

Configuring Java CAPS Project Components for Database Adapters

Configuring Java CAPS Adapter Connectivity Map Properties

To Add an Adapter to the Connectivity Map

To Configure Adapter Connectivity Map Properties

DB2 Connect Adapter Inbound Connectivity Map Properties

DB2 Connect Type 4 Adapter - Inbound Parameter Settings

DB2 Connect Adapter - Inbound Parameter Settings

DB2 Connect Adapter Outbound Connectivity Map Properties

DB2 Connect Type 4 Adapter - Outbound JDBC Connector Settings

DB2 Connect XA Adapter - Outbound JDBC Connector Settings

DB2 Connect Adapter - Outbound JDBC Connector Settings

DB2 Connect non-Transactional Type 4 Adapter - Outbound JDBC Connector Settings

DB2 Connect Type 4 XA Adapter - Outbound JDBC Connector Settings

DB2 Connect non-Transactional Adapter - Outbound JDBC Connector Settings

DB2 Adapter Inbound Connectivity Map Properties

DB2 Adapter Inbound Properties for Windows and UNIX

DB2 Adapter Inbound Properties for z/OS and AS/400

DB2 Adapter Outbound Connectivity Map Properties

DB2 Adapter Outbound Properties for Windows and UNIX

DB2 Adapter Outbound Properties for z/OS and AS/400

Informix Adapter Connectivity Map Properties Configuration

Informix Adapter -- Outbound Adapter Properties

Informix Adapter -- Outbound XA Adapter Properties

Outbound non-Transactional Adapter Properties

Transaction Support Levels Between Different Versions

Example:

JDBC/ODBC Adapter Connectivity Map Properties Configuration

JDBC/ODBC Adapter -- Outbound Adapter Properties

JDBC/ODBC Adapter -- Outbound non-Transactional Adapter Properties

JDBC/ODBC Adapter -- Outbound XA Adapter Properties

Transaction Support Levels Between Different Versions

Example:

Oracle Adapter Inbound Connectivity Map Properties

Oracle Adapter Outbound Connectivity Map Properties

Oracle Adapter Outbound Properties

Oracle Adapter Outbound non-Transactional Properties

Oracle Adapter Outbound with XA Support Properties

SQL Server Adapter Inbound Connectivity Map Properties

SQL Server Adapter Outbound Connectivity Map Properties

SQL Server Adapter -- Outbound Properties

SQL Server Adapter -- Outbound non-Transactional Properties

SQL Server Adapter -- Outbound with XA Support Properties

Sybase Adapter Connectivity Map Properties

Sybase Adapter -- Outbound Properties

Sybase Adapter -- Outbound XA Properties

Sybase Adapter -- Outbound non-Transactional Properties

Transaction Support Levels Between Different Versions

Example:

VSAM Adapter Outbound Connectivity Map Properties

VSAM Adapter -- Outbound Properties

VSAM Adapter -- Outbound non-Transactional Properties

VSAM Adapter Outbound Connectivity Map Properties

The VSAM configuration parameters, accessed from the Connectivity Map, are organized into the following sections:

VSAM Adapter — Outbound Properties

The VSAM Outbound Adapter Properties include outbound parameters used by the external database.

Table 28 Outbound Adapter — JDBC Connector Settings

Name
Description
Required Value
Description
VSAM Connection Pool Datasource.
A valid string.
ClassName
The Java class in the JDBC driver that is used to implement the ConnectionPoolDataSource interface.
A valid class name.

The default is: com.cac.jdbc. ConnectionPoolDataSource


Note - Do not change this value.


VSAM Adapter — Outbound non-Transactional Properties

You can create VSAM databases with or without logging enabled. If logging is disabled, then Non-Transactional mode must be used. Because data logs are not retained during Non-Transactional execution of SQL calls, data recovery is not possible during accidental or unscheduled shutdown of the database server.

Disabled logging also prevents transactions—enclosed in BEGIN-Tran and END-Tran statements—from occurring. This means that Non-Transactional mode cannot be used in XA (two-phase commit) transactions.

The Outbound non-Transactional adapter Properties listed in the following table include parameters used by the external database.

Table 29 Outbound VSAM non-Transactional adapter Connectivity Map Properties

Name
Description
Required Value
Description
A description for the database.
A valid string. The default is VSAM non-Transactional Connection Pool Datasource.
ClassName
The Java class in the JDBC driver that is used to implement the non-Transactional ConnectionPoolDataSource interface.
A valid class name. The default is com.cac.jdbc. ConnectionPoolDataSource.