GetConnectionOption

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.

Applies to

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

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.

NoteUsing the SYJ interface Sybase EAServer uses a slightly different version of the CT-Lib software. Therefore, at runtime, you need to use the SYJ database interface rather than SYC to connect to an Adaptive Server Enterprise database. The SYJ Database Profile Setup dialog box provides a convenient way to set the appropriate connection parameters and then copy the syntax from the Preview tab into the script for your Transaction object.

You cannot use the SYJ interface, however, to connect to the database in the PowerBuilder development environment. Therefore, during the development phase (before the component has been deployed to EAServer), you must use SYC to connect to the database.

For information on how to use PowerBuilder to build EAServer components, see Application Techniques.

Examples

Example 1

On the EAServer tab 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 tab:

SQLCA.DBParm = "GetConnectionOption = 'JAG_CM_NOWAIT'"

Copy the syntax from the Preview tab into your script.

See also