HomePowerBuilderAppeon Documentation Center

OraMTSConFlgs (obsolete)

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.

Obsolete DBParm

You can no longer deploy components from PowerBuilder to COM+ servers. The OraMTSConFlgs DBParm is maintained for backward compatibility to existing PowerBuilder components on COM+ servers. For new development, deploy components as .NET projects instead.

Applies to

O90 Oracle9i

O10 Oracle 10g

ORA Oracle (for 11g and later)

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).


Default value

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

To obtain an enlisted connection using the INTERNAL account:

  • Application

    Type the following in code (use | to signify a logical OR of the flags): 

    SQLCA.DBParm="OraMTSConFlgs='ORAMTS_CFLG_ALLDEFAULT|ORAMTS_CFLG_PRELIMAUTH'"
Prev  Up  Next
OnlineIndex  Home  PackageProcs