OraMTSConFlgs

Description

Specifies the behavior of a transactional PowerBuilder component deployed to COM+. This parameter applies only when a PowerBuilder custom class user object is deployed as a COM+ component and is connecting to an Oracle 8.1.5 or higher database.

Applies to

O84 Oracle 8.x and Oracle8i (8.1.5 or higher database connections only)
O90 Oracle9i

Syntax

OraMTSConFlgs = 'value'

Parameter	Description
value	Specifies the behavior of a transactional component deployed to COM+. Values are: All Default (Default) Obtains a pooled connection and enlists the connection in any COM+ transaction, if one exists (ORAMTS_CFLG_ALLDEFAULT). No Implicit Enlistment Obtains a pooled connection but does not enlist the resource in any COM+ transaction even if the component is transactional (ORAMTS_CFLG_NOIMPLICIT). Unique Server Session Requests a single OCI session per OCI Server. Since multiplexing is not supported in Version 8.1.5, this option is always used (ORAMTS_CFLG_UNIQUESRVR). SYSDBA Login Required if connecting as SYSDBA (ORAMTS_CFLG_SYSDBALOGN). SYSOPER Login Required if connecting as SYSOPER (ORAMTS_CFLG_SYSOPRLOGN). Preliminary INTERNAL Login Required if connecting as INTERNAL (ORAMTS_CFLG_PRELIMAUTH).

Parameter

Description

value

Specifies the behavior of a transactional component deployed to COM+. Values are:

All Default (Default) Obtains a pooled connection and enlists the connection in any COM+ transaction, if one exists (ORAMTS_CFLG_ALLDEFAULT).
No Implicit Enlistment Obtains a pooled connection but does not enlist the resource in any COM+ transaction even if the component is transactional (ORAMTS_CFLG_NOIMPLICIT).
Unique Server Session Requests a single OCI session per OCI Server. Since multiplexing is not supported in Version 8.1.5, this option is always used (ORAMTS_CFLG_UNIQUESRVR).
SYSDBA Login Required if connecting as SYSDBA (ORAMTS_CFLG_SYSDBALOGN).
SYSOPER Login Required if connecting as SYSOPER (ORAMTS_CFLG_SYSOPRLOGN).
Preliminary INTERNAL Login Required if connecting as INTERNAL (ORAMTS_CFLG_PRELIMAUTH).

Default

OraMTSConFlgs = 'ORAMTS_CFLG_ALLDEFAULT'

Usage

If a transactional PowerBuilder component deployed to COM+ uses a PowerBuilder native interface to connect to an Oracle 8.1.5 or higher database, COM+ attempts to obtain a pooled connection and enlist the connection in a transaction. You can specify different behavior by selecting one or more of the available options.

When the Oracle database interface is running under COM+, ThreadSafe mode is enabled by default and the value of the ThreadSafe parameter is ignored.

This parameter cannot be set dynamically. The value set when the connection is made remains in effect until it is disconnected.

These values are not mutually exclusive. They are chained using the pipe character in the parameter.

Requirements for COM+ transactional support Oracle Services for COM+ must be installed and configured.

Examples

Example 1

To obtain an enlisted connection using the INTERNAL account:

Database profile Select the Preliminary INTERNAL Login check box on the EAServer/COM+ tab in the Database Profile Setup dialog box. The All Default check box is selected by default.
Application Type the following in code (use | to signify a logical OR of the flags):
```
SQLCA.DBParm = "OraMTSConFlgs = 'ORAMTS_CFLG_ALLDEFAULT|ORAMTS_CFLG_PRELIMAUTH'"
```