/// <summary> /// Run this Database query. /// If FReportingQueryCancelFlag is set, this returns immediately with an empty table. /// The query can be cancelled WHILE IT IS RUNNING. In this case the returned table may be partially filled. /// </summary> /// <remarks>For details on the Arguments that can be passed with <paramref name="AOptionalColumnNameMapping"/>, /// <paramref name="ASelectCommandTimeout"/>, <paramref name="AParameterDefinitions"/>, /// <paramref name="AParameterValues"/>, <paramref name="APrepareSelectCommand"/>, /// <paramref name="AProgressUpdateEveryNRecs"/> and /// <paramref name="AMultipleParamQueryProgressUpdateCallback"/> please see their respective XML Comments on /// Method <see cref="TDataBase.SelectUsingDataAdapterMulti"/>!/</remarks> /// <returns>DataTable. May be empty (even with no fields defined!) if cancellation happens or has happened.</returns> public DataTable RunQueryMultiParams(String Query, String TableName, TDBTransaction Trans, TDataBase.TOptionalColumnMappingDelegate AOptionalColumnNameMapping = null, int ASelectCommandTimeout = -1, DbParameter[] AParameterDefinitions = null, List <object[]> AParameterValues = null, bool APrepareSelectCommand = false, Int16 AProgressUpdateEveryNRecs = 0, TDataBase.MultipleParamQueryProgressUpdateDelegate AMultipleParamQueryProgressUpdateCallback = null) { var ResultDT = new DataTable(TableName); try { FPrivateDatabaseObj.SelectUsingDataAdapterMulti(Query, Trans, ref ResultDT, AOptionalColumnNameMapping, ASelectCommandTimeout, AParameterDefinitions, AParameterValues, APrepareSelectCommand, AProgressUpdateEveryNRecs, AMultipleParamQueryProgressUpdateCallback); } catch (PostgresException Exp) { if (Exp.SqlState == "57014") // Exception with Code 57014 is what Npgsql raises as a response to a Cancel request of a Command { TLogging.LogAtLevel(7, this.GetType().FullName + ".RunQuery: Query got cancelled; proper reply from Npgsql!"); } else if (Exp.SqlState == "25P02") // Exception with Code 25P02 is what Npgsql raises as a response to a cancellation of a request of a Command when that happens in another code path (eg. on a different Thread [e.g. Partner Find { // screen: Cancel got pressed while Report Query ran, for instance]) TLogging.LogAtLevel(1, this.GetType().FullName + ".RunQuery: Query got cancelled (likely trought another code path [likely on another Thread]); proper reply from Npgsql!"); } else { TLogging.Log(this.GetType().FullName + ".RunQuery: Query got cancelled; general PostgresException occured: " + Exp.ToString()); } return(null); } catch (Exception Exc) { TLogging.Log("ReportingQueryWithCancelOption: Query Raised exception: " + Exc.ToString() + "\nQuery: " + Query); FRunQueryException = Exc; /* * WE MUST 'SWALLOW' ANY EXCEPTION HERE, OTHERWISE THE WHOLE * PETRASERVER WILL GO DOWN!!! (THIS BEHAVIOUR IS NEW WITH .NET 2.0.) * * --> ANY EXCEPTION THAT WOULD LEAVE THIS METHOD WOULD BE SEEN AS AN <-- * --> UNHANDLED EXCEPTION IN A THREAD, AND THE .NET/MONO RUNTIME <-- * --> WOULD BRING DOWN THE WHOLE PETRASERVER PROCESS AS A CONSEQUENCE. <-- * */ } return(ResultDT); }
/// <summary> /// Run this Database query. /// If FReportingQueryCancelFlag is set, this returns immediately with an empty table. /// The query can be cancelled WHILE IT IS RUNNING. In this case the returned table may be partially filled. /// </summary> /// <returns>DataTable. May be empty (even with no fields defined!) if cancellation happens or has happened.</returns> public DataTable RunQuery(String Query, String TableName, TDBTransaction Trans, TDataBase.TOptionalColumnMappingDelegate AOptionalColumnNameMapping = null, int ASelectCommandTimeout = -1, DbParameter[] AParametersArray = null) { List <object[]> ParameterValues = null; List <object> ObjectValues = null; if (AParametersArray != null) { ParameterValues = new List <object[]>(1); ObjectValues = new List <object>(); for (int Counter = 0; Counter < AParametersArray.Length; Counter++) { ObjectValues.Add(AParametersArray[Counter].Value); } ParameterValues.Add(ObjectValues.ToArray()); } return(RunQueryMultiParams(Query, TableName, Trans, AOptionalColumnNameMapping, ASelectCommandTimeout, AParametersArray, ParameterValues, false)); }