ReleaseConnectionOption database parameter
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.
Controls
-
JDB JDBC
-
ODBC
-
O90 Oracle9i
-
O10 Oracle 10g
-
ORA Oracle 11g
-
SYJ SAP Adaptive Server Enterprise
Syntax
|
1 |
ReleaseConnectionOption='<span>value</span>' |
|
Parameter |
Description |
|---|---|
|
value |
Specifies how EAServer should behave
|
Default
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.
Using 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 ASE or 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 page
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 ASE or SYC to connect to the
database.
For information on how to use PowerBuilder to build EAServer
components, see Application Techniques.
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:
|
1 |
SQLCA.DbParameter="ReleaseConnectionOption='JAG_CM_DROP'" |
Copy the syntax from the Preview page into your script.