Skip to content

SAIF.Framework.Connection business rules

This page captures business rules enforced by clsConnection, the sole class in this library.

BR-001: Explicit Oracle credentials bypass the remote connection-resolution service

Field Value
Statement If explicit Oracle credentials were provided at construction, clsConnection bypasses the remote ConnectInfo web service and builds the connection string locally using those credentials.
Trigger m_ConnectStringOverride = True, set when the caller uses the New(inOracleUser, inOraclePassword) constructor overload.
Enforcement clsConnection.getConnection (Oracle overload), clsConnection.vb.
Outcome A locally composed Oracle connection string (Data Source=...;User ID=...;...) is used instead of a web-service-resolved string.
Source SAIF.Framework.Connection\clsConnection.vb

BR-002: Load Balance Timeout is always stripped from Oracle connection strings

Field Value
Statement The Load Balance Timeout=900; clause is always removed from the final Oracle connection string, regardless of source (local override or web-service-resolved).*
Trigger Always, in the Oracle getConnection overload.
Enforcement clsConnection.vb (CnString.Replace("Load Balance Timeout=900;", "")).
Outcome The final Oracle connection string never contains a Load Balance Timeout setting.
Source SAIF.Framework.Connection\clsConnection.vb

BR-003: ZSPECIALCHAR token is restored to a control character in web-service-resolved Oracle strings

Field Value
Statement The token ZSPECIALCHAR returned by the remote ConnectInfo.GetOracleConnectString call is replaced with the BEL control character (Chr(7)), apparently to escape a special character (likely a password character) that cannot be transmitted directly through the SOAP contract.*
Trigger Only applies when the web-service-resolved (non-override) Oracle path is used.
Enforcement clsConnection.vb.
Outcome Connection strings containing an escaped special character are restored to their literal control-character form before being assigned to the caller's OracleConnection.ConnectionString.
Source SAIF.Framework.Connection\clsConnection.vb

BR-004: SQL Server connection resolution always delegates to the remote web service

Field Value
Statement SQL Server connection resolution always delegates to the remote ConnectInfo.GetSQLConnectString web service; there is no local-override path for SQL Server.
Trigger Always, in the SQL Server getConnection overload.
Enforcement clsConnection.vb.
Outcome The SQL Server connection string is always sourced from the ConnectInfo SOAP service; a ConnectInfo service outage prevents SQL Server connection resolution entirely for this overload.
Source SAIF.Framework.Connection\clsConnection.vb

Notes

  • BR-002 and BR-003 are undocumented in code comments; their business rationale is inferred from observed behavior only.*
  • These four rules are the complete set of business rules identified in this library; no additional validation, authorization, or workflow rules were found.

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

  • SAIF.Framework.Connection\clsConnection.vb