Consultor Eletrônico

Status: Verified

GOAL:

What is the DATABASES environment variable in WebSpeed?

GOAL:

How to enable database reconnect feature in WebSpeed?

GOAL:

How to configure the DATABASES environment variable in WebSpeed?

GOAL:

How do I make webspeed agents reconnect to databases when the connection has terminated?

FACT(s) (Environment):

WebSpeed 3.1D
WebSpeed 3.1E
OpenEdge 10.x

FIX:

In WebSpeed 3.1D and higher, there is a predefined environment variable, DATABASES, that can be set in WebSpeed environment session. The value is formatted as;

"Logical database name = [connection parameters | program name]"

This parameter can do the following:
1. Specify which databases are associated with WebSpeed Agents
2. Lists connection parameters
3. Specify a database program (a program could start the database before connecting to it).

The WebSpeed Agent will automatically try to connect to these databases if not connected when a web-request is received.

Steps to configure within Progress Explorer,
1. Select the WebSpeed broker that you need to add the environment variable on
2. Right click on the WS broker, go to properties
3. Select Environment Variables, on the right panel, in Name files, add "DATABASES",
4. In Value field, add Logical database name = [connection parameters | program name]

For example,
db1=-pf c:\databases\db1.pf or -pf c:\databases\db1.pf

If you use connections parameters instead of pf file enter DATABASES in NAME and value
db1=-db c:\databases\db1

Steps to configure within the Ubroker.properties file,
If you directly modify the ubroker.properties file, the entry looks like following under [Environment.brokername]

DATABASES=db1=-pf c:\databases\db1.pf or
DATABASES=-pf c:\databases\db1.pf or
DATABASES= -db c:\databases\db1