Where to place code to create DB Aliases in order for it to execute prior to requests? - Progress Community

Loading

Skip to Main Content

Where to place code to create DB Aliases in order for it to execute prior to requests?

When migrating code to PASOE that requires the use of database aliases, without having to include the alias creation code in all request programs, where can the alias creation code be placed in order for the aliases to automatically be available to the application code?

Feb 16, 2023
Knowledge

Title

Where to place code to create DB Aliases in order for it to execute prior to requests?

URL Name

where-to-place-code-to-create-db-aliases-in-order-for-it-to-execute-prior-to-requests

Article Number

000194306

Environment

Product: OpenEdge Version: 11.5, 11.6, 11.7, 12.x OS: All Supported Platforms

Question/Problem Description

Migrating code from an application, which references the databases using aliases to PASOE

The application code is typically run after a standard program which creates all the aliases needed by the application before any of the application code executes

Where can this alias creation code be executed in a PASOE request, in order to ensure that the application code can reference the aliases?

Steps to Reproduce

Clarifying Information

e.g.
CONNECT sports2000 -S 8977.
CREATE ALIAS "sports2k" FOR DATABASE sports2000.
CREATE ALIAS "foo"      FOR DATABASE sports2000.

The above code creates two separate aliases for the sports2000 database which can then be referenced in place of the sports2000 database name.

This is commonly used for (among others) supporting application databases which have been consolidated into a single database.

Error Message

Defect Number

Enhancement Number

Cause

Resolution

PASOE provides hooks for procedures to execute on specific events, in this scenario the hook listed below is what you want:

- sessionStartupProc - This is executed once, at the startup of the Session (Session = AVM that the request will run in)

Workaround

Notes

These hooks are documented in the <pasoe-instance>\conf\openedge.properties.README file

Keyword Phrase

Last Modified Date

2/19/2024 3:42 PM

OpenEdge DeploymentOpenEdge ArchitectureOpenEdge DevelopmentOpenEdge General DiscussionsOpenEdge Pro2OpenEdge RDBMS

Drop Files

Upload FilesOr drop files

Disclaimer

The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.

Loading

Where to place code to create DB Aliases in order for it to execute prior to requests? - Progress Community