Skip Navigation Links | |
Exit Print View | |
Configuring Project Components for Oracle Java CAPS Database Adapters Java CAPS Documentation |
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
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
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
VSAM Adapter Outbound Connectivity Map Properties
When you connect an External Application to a Collaboration, the NetBeans IDE automatically assigns the appropriate adapter to the link. Each adapter is supplied with a list of adapter connections (transaction support levels) from which to choose.
Transaction support levels supported by the Sybase Adapter include:
For more information on Transaction Support Levels, refer to:
The Outbound Adapter Properties include outbound parameters used by the external database.
Table 25 Outbound Adapter—Outbound Connection Properties
|
The Outbound XA Adapter Properties include outbound parameters used by the external database.
Table 26 Outbound Adapter—Outbound XA Connection Properties
|
The Outbound Sybase non-Transactional Adapter Properties include outbound parameters used by the external database.
Table 27 Outbound Adapter—Outbound non-Transactional Properties
|
The types of transaction support levels used in Java CAPS 5.1.X may be different from the support levels used in Java CAPS 6.3. Projects that are imported from a Java CAPS 5.1.X version can potentially display different results, depending on whether the 5.1.X Java Collaboration Definition (JCD) included multiple (insert/update/delete) operations. This only affects non-XA transactions. If you are using an XA transaction, then you can skip this section.
In 5.1.X, five new records are to be inserted into a table. If the last record fails to insert (such as when a duplicate key exists), all previous records will have been inserted. This is the behavior of NoTransaction support.
In 6.0, five new records are to be inserted into a table. If one of the records fails to insert (such as when a duplicate key exists), the other four records will not be inserted. This is the behavior of the LocalTransaction.
In order to achieve the same result as in 5.1.X versions, you can choose the method below:
In the Connectivity Map, delete the link to the database external application, then reconnect the link and select NoTransaction.
Fill in the NoTransaction property for the database external system under the Environment.
Rebuild the Project.
Note that there are no changes when migrating from ICAN version 5.0.5 and Java CAPS 6.0.
Under the scenario noted above, if you want 6.0 behavior for a LocalTransaction, then set your adapter connection to be Outbound Sybase non-Transactional Adapter (NoTransaction).
The Configuration properties window opens, displaying the default properties for the adapter.