Kbase P12656: How to check if webspeed agents are connected to database, using web-disp.p?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/25/2010 |
|
Status: Verified
GOAL:
How to check if webspeed agents are connected to database, using web-disp.p?
GOAL:
Using web-disp.p, how to verify if the webspeed agents are connected to a database?
GOAL:
How to check if webspeed agents are connected to database?
GOAL:
Where to put database connection logic per session base for webspeed?
FACT(s) (Environment):
WebSpeed 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
Customize the startup procedure for agents. You can find a copy of web-disp.p
in <DLC>/src/web/objects.
Add the following code at the begininng of WEB-NOTIFY trigger:
IF NOT CONNECTED( "logical-name-here" ) THEN DO:
/* shared memory connection */
CONNECT <db-path>/logical-name-here .
/* client server connection */
CONNECT logical-name-here -S service -H hostname -N TCP.
/* use .pf file */
CONNECT -pf <pf location>/connection-file.pf .
/* in this case the pf file must contain only db connection parameters */
/* also, each database must have one pf file */
END.After the code is modified, follow these steps
1. Save the file as web-disp.p and compile it in a temp directory.
2. Move the web-disp.r file into the \tty\web\objects folder, back up the original web-disp.r first
3. Restart the broker