ReleaseConnectionOption (obsolete)

Description

Specifies how EAServer should behave when it releases control of a connection. This parameter applies only when a PowerBuilder custom class user object is deployed as an EAServer component.

Obsolete parameter

ReleaseConnectionOption parameter is obsolete, because EAServer is no longer supported since PowerBuilder 2017.

Applies to

ODBC

O90 Oracle9i

O10 Oracle 10g

ORA Oracle (for 11g and later)

Syntax

ReleaseConnectionOption='value'

Parameter

Description

value

Specifies how EAServer should behave when it releases control of a connection. Values are:

  • JAG_CM_UNUSED

    (Default) A connection taken from a cache is placed back in the cache and a connection created outside of a cache is closed and destroyed.

  • JAG_CM_DROP

    The connection is forced to close and is deallocated. If the connection came from a cache, a new connection is created in its place.


Default value

ReleaseConnectionOption='JAG_CM_UNUSED'

Usage

Use JAG_CM_DROP to destroy a connection when errors have made it unusable. This parameter cannot be set dynamically. The value set when the connection is made remains in effect until it is disconnected.

Examples

On the EAServer page in the Database Profile Setup dialog box, select JAG_CM_DROP from the Release Connection Option drop-down list. The PowerScript syntax for the ReleaseConnectionOption parameter displays on the Preview page:

SQLCA.DBParm="ReleaseConnectionOption='JAG_CM_DROP'"

Copy the syntax from the Preview page into your script.

See also

CacheName (obsolete)

GetConnectionOption (obsolete)

UseContextObject (obsolete)