GetConnectionOption (obsolete)

Description

Specifies how EAServer should behave if all connections in a cache are being used. This parameter applies only when a PowerBuilder custom class user object is deployed as an EAServer component.

Obsolete parameter

GetConnectionOption 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

GetConnectionOption='value'

Parameter

Description

value

Specifies how EAServer should behave if all connections in a cache are being used. Values are:

  • JAG_CM_FORCE

    (Default) Allocates and opens a new connection. The new connection is not cached and is deallocated when the connection is explicitly or implicitly closed by the component.

  • JAG_CM_NOWAIT

    Fails with an error if no connection can be made.

  • JAG_CM_WAIT

    Does not return until a connection is available.


Default value

GetConnectionOption='JAG_CM_FORCE'

Usage

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_NOWAIT from the Get Connection Option drop-down list. The PowerScript syntax for the GetConnectionOption parameter displays on the Preview page:

SQLCA.DBParm="GetConnectionOption='JAG_CM_NOWAIT'"

Copy the syntax from the Preview page into your script.

See also

CacheName (obsolete)

ReleaseConnectionOption (obsolete)

UseContextObject (obsolete)