Kbase P130636: How to reconnect AppServer agents to database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/06/2008 |
|
Status: Unverified
GOAL:
How to reconnect AppServer agents to database?
GOAL:
How to programatically reconnect appServer servers to the database?
FACT(s) (Environment):
OpenEdge 10.x
Progerss 9.x
Unix
Windows
FIX:
For state-free and stateless use the following code example in an AppServer activate procedure.
For state-reset and state-aware use the following code example in an AppServer connect procedure.
The following properties need to be set in ubroker.properties file:
For activate procedure: srvrActivateProc=as_activate.p
For connect procedure: srvrConnectProc=as_connect.p
The Progress Explorer tool can also be used to set these properties in the Agent->Advanced Features screen:
In Progress Explorer, go to :
--> the AppServer broker properties,
--> section Server,
--> Advanced Features,
Examples:
/* as_activate.p */
IF NOT CONNECTED( sports2000 ) THEN
CONNECT sports2000 -S ... -H ...
/* end as_activate.p */
/* as_connect.p */
DEFINE INPUT PARAMETER user-id AS CHARACTER NO-UNDO.
DEFINE INPUT PARAMETER password AS CHARACTER NO-UNDO.
DEFINE INPUT PARAMETER app-server-info AS CHARACTER NO-UNDO.
IF NOT CONNECTED( sports2000 ) THEN
CONNECT sports2000 -S ... -H ...
/* end as_connect.p */