private void CloseTestDBConnection(TDataBase ADBAccessObject, string AConnectionName = null, bool ALogNumberOfConnections = false) { if (ALogNumberOfConnections) { if (FDBType == TDBType.PostgreSQL) { TLogging.Log(" CloseTestDBConnection: Number of open DB Connections on PostgreSQL BEFORE closing Database connection: " + TDataBase.GetNumberOfDBConnections(FDBType) + ADBAccessObject.GetDBConnectionIdentifier()); } } TLogging.Log(" CloseTestDBConnection: Closing connection to Database..." + ADBAccessObject.GetDBConnectionIdentifier()); ADBAccessObject.CloseDBConnection(); TLogging.Log(" CloseTestDBConnection: Database connection closed." + TDataBase.GetDBConnectionName(AConnectionName)); if (ALogNumberOfConnections) { if (FDBType == TDBType.PostgreSQL) { TLogging.Log(" CloseTestDBConnection: Number of open DB Connections on PostgreSQL AFTER closing Database connection: " + TDataBase.GetNumberOfDBConnections(FDBType) + TDataBase.GetDBConnectionName(AConnectionName)); } } }
/// <summary> /// modified version taken from Ict.Petra.Server.App.Main::TServerManager /// </summary> private TDataBase EstablishDBConnectionAndReturnIt(string AConnectionName = null, bool ALogNumberOfConnections = false) { TDataBase ReturnValue; if (ALogNumberOfConnections) { if (FDBType == TDBType.PostgreSQL) { TLogging.Log(" EstablishDBConnectionAndReturnIt: Number of open DB Connections on PostgreSQL BEFORE Connecting to Database: " + TDataBase.GetNumberOfDBConnections(FDBType) + TDataBase.GetDBConnectionName(AConnectionName)); } } TLogging.Log(" EstablishDBConnectionAndReturnIt: Establishing connection to Database..." + TDataBase.GetDBConnectionName(AConnectionName)); ReturnValue = new TDataBase(); TLogging.DebugLevel = TAppSettingsManager.GetInt16("Server.DebugLevel", 10); try { ReturnValue.EstablishDBConnection(FDBType, TAppSettingsManager.GetValue("Server.DBHostOrFile"), TAppSettingsManager.GetValue("Server.DBPort"), TAppSettingsManager.GetValue("Server.DBName"), TAppSettingsManager.GetValue("Server.DBUserName"), TAppSettingsManager.GetValue("Server.DBPassword"), "", AConnectionName); } catch (Exception Exc) { TLogging.Log(" EstablishDBConnectionAndReturnIt: Encountered Exception while trying to establish connection to Database " + TDataBase.GetDBConnectionName(AConnectionName) + Environment.NewLine + Exc.ToString()); throw; } TLogging.Log(" EstablishDBConnectionAndReturnIt: Connected to Database." + ReturnValue.GetDBConnectionIdentifier()); if (ALogNumberOfConnections) { if (FDBType == TDBType.PostgreSQL) { TLogging.Log(" EstablishDBConnectionAndReturnIt: Number of open DB Connections on PostgreSQL AFTER Connecting to Database: " + TDataBase.GetNumberOfDBConnections(FDBType) + ReturnValue.GetDBConnectionIdentifier()); } } return(ReturnValue); }