comparison Framework/PostgreSQL/PostgreSQLParameters.cpp @ 457:2f3b0688548e pg-transactions

show transaction mode in logs
author Alain Mazy <am@osimis.io>
date Tue, 23 Jan 2024 17:00:35 +0100
parents 8b7c1c423367
children f0976163dbe1
comparison
equal deleted inserted replaced
456:0ac99983abfa 457:2f3b0688548e
101 connectionRetryInterval_ = configuration.GetUnsignedIntegerValue("ConnectionRetryInterval", 5); 101 connectionRetryInterval_ = configuration.GetUnsignedIntegerValue("ConnectionRetryInterval", 5);
102 102
103 std::string transactionMode = configuration.GetStringValue("TransactionMode", "SERIALIZABLE"); 103 std::string transactionMode = configuration.GetStringValue("TransactionMode", "SERIALIZABLE");
104 if (transactionMode == "DEFAULT") 104 if (transactionMode == "DEFAULT")
105 { 105 {
106 LOG(WARNING) << "PostgreSQL: using DB default transaction mode";
106 SetIsolationMode(IsolationMode_DbDefault); 107 SetIsolationMode(IsolationMode_DbDefault);
107 } 108 }
108 else if (transactionMode == "READ COMMITTED") 109 else if (transactionMode == "READ COMMITTED")
109 { 110 {
111 LOG(WARNING) << "PostgreSQL: using READ COMMITTED transaction mode";
110 SetIsolationMode(IsolationMode_ReadCommited); 112 SetIsolationMode(IsolationMode_ReadCommited);
111 } 113 }
112 else if (transactionMode == "SERIALIZABLE") 114 else if (transactionMode == "SERIALIZABLE")
113 { 115 {
116 LOG(WARNING) << "PostgreSQL: using SERIALIZABLE transaction mode";
114 SetIsolationMode(IsolationMode_Serializable); 117 SetIsolationMode(IsolationMode_Serializable);
115 } 118 }
116 else 119 else
117 { 120 {
118 throw Orthanc::OrthancException(Orthanc::ErrorCode_BadParameterType, std::string("Invalid value for 'TransactionMode': ") + transactionMode); 121 throw Orthanc::OrthancException(Orthanc::ErrorCode_BadParameterType, std::string("Invalid value for 'TransactionMode': ") + transactionMode);