Fields in the LEI Connection Document - 4

See the following tables for descriptions of the connection document fields.

Connectivity

The Connectivity options are described as follows.

Oracle connection document connectivity options

Field

Description

Name

Specifies a unique name that identifies this connection. The maximum number of characters allowed is 255.

Oracle Version

There is only one field value available for all supported Oracle versions.

Host String

Specifies the Service Name as defined in your local tnsnames.ora file. Service names are simple names commonly used to specify the location of database services on a network.

User Name

Specifies the user name required to log in to the Oracle database.

Password

Specifies the password associated with the preceding user name. This displays as hidden text.

Password encryption is described in the "Introduction to Lotus® Connectors" chapter.

Alternate Default Test Translation Format

Enables you to override the existing text translation format with an alternative default.

Use this option to enter an alternative default Oracle text format if the standard default results in improper translation. The text format must be supported by Oracle.

Connection Options

The Connection Options section provides options for managing data transactions, creating tables, and logging SQL commands. These settings have no effect on Advanced RealTime activities.

Transaction Options

When you select the Transaction Options tab, the following options appear. The Transaction Options apply to operations that create, modify, or delete data.

Oracle connetion document transaction options bmp

Field

Description

Rollback:

Select "Rollback upon Error" if you want all transactions rolled back at disconnect time when an activity using this connection terminates in an error state.

Commit Options:

Specifies how commit actions should occur. The choices are as follows.

  • Commit At Disconnect: Enable this option to commit changes to the database as the database is being disconnected at the end of the operation. This is the default Commit option.
  • Commit Every N Operations: Commits changes periodically after a specified number of changes are made. This number is specified as the Commit Frequency.
  • Commit Every Operation: When enabled, this option causes immediate commits for each change to the database. Note that this option reduces performance.

Commit Frequency

This is used with the option Commit Every N Operations to specify how many actions must occur before the changes are committed.

Logging Options

The Logging Options provide a feature for including any SQL statements generated during an activity to be included in the activity log.

Oracle connection document log options bmp

Field

Description

SQL Statements Option:

Select "Output SQL Statements to Log" to include in the activity log all SQL statements generated during processing of the activity.

Note: Selecting this option slows down performance. Use it only for troubleshooting.

Log Warning Statements:

Select "Output Warnings to Log" to enable warning statements to display in the activity log.

Selection Type

Regardless of which Options tab you select, the following option is available.

Oracle connection document selectoin type options bmp

Field

Description

Selection Type

Enables you to specify the metadata type for a connection.

  • Select Table to connect to an Oracle table.
  • Select View to connect to an Oracle view.
  • Select Procedure to connect to an Oracle stored procedure.

Spaces in a table or column name are not permitted.

Table Options

These settings display a current list of tables and allow you to specify which tables will be accessed and how. You can also specify a table name not shown in the list by selecting the Manual button.

Oracle connection document table options bmp

Field

Description

Owner

Lists the available owner names for the preceding table, view, or procedure selection type in the specified database.

A selection list displays all Oracle owners. Choose the owner of the table, view, or procedure being connected to from the list (Optional).

Name

Lists the available table, view, or procedure names defined for the specified owner.

A selection list displays all Oracle tables, views, or procedures for the selected owner. Choose the table, view, or procedure to connect to.

If an owner is not specified, all names are listed for the specified Selection Type.

Spaces in a table or column name are not permitted.

Column(s)

Lists the columns or parameters (stored procedure) defined for the specified name.

Spaces in a table or column name are not permitted.