Free cookie consent management tool by TermsFeed Policy Generator

Ignore:
Timestamp:
06/25/09 13:54:15 (15 years ago)
Author:
svonolfe
Message:

Further avoided out of memory exceptions by updating the JobResult DAO (#372)

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/sources/HeuristicLab.Hive.Server.ADODataAccess/3.2/dsHiveServer.xsd

    r2092 r2099  
    609609                <DeleteCommand>
    610610                  <DbCommand CommandType="Text" ModifiedByUser="false">
    611                     <CommandText>DELETE FROM [dbo].[JobResult] WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsNull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)) AND ((@IsNull_DateFinished = 1 AND [DateFinished] IS NULL) OR ([DateFinished] = @Original_DateFinished)))</CommandText>
     611                    <CommandText>DELETE FROM [JobResult] WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsNull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)) AND ((@IsNull_DateFinished = 1 AND [DateFinished] IS NULL) OR ([DateFinished] = @Original_DateFinished)))</CommandText>
    612612                    <Parameters>
    613613                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_JobResultId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobResultId" SourceColumnNullMapping="false" SourceVersion="Original" />
    … …  
    625625                <InsertCommand>
    626626                  <DbCommand CommandType="Text" ModifiedByUser="false">
    627                     <CommandText>INSERT INTO [dbo].[JobResult] ([JobResultId], [JobId], [JobResult], [Message], [Percentage], [ResourceId], [DateFinished]) VALUES (@JobResultId, @JobId, @JobResult, @Message, @Percentage, @ResourceId, @DateFinished);
    628 SELECT JobResultId, JobId, JobResult, Message, Percentage, ResourceId, DateFinished FROM JobResult WHERE (JobResultId = @JobResultId)</CommandText>
     627                    <CommandText>INSERT INTO [JobResult] ([JobResultId], [JobId], [Message], [Percentage], [ResourceId], [DateFinished]) VALUES (@JobResultId, @JobId, @Message, @Percentage, @ResourceId, @DateFinished);
     628SELECT JobResultId, JobId, Message, Percentage, ResourceId, DateFinished FROM JobResult WHERE (JobResultId = @JobResultId)</CommandText>
    629629                    <Parameters>
    630630                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@JobResultId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobResultId" SourceColumnNullMapping="false" SourceVersion="Current" />
    631631                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
    632                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@JobResult" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="JobResult" SourceColumnNullMapping="false" SourceVersion="Current" />
    633632                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Message" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="false" SourceVersion="Current" />
    634633                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Percentage" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Percentage" SourceColumnNullMapping="false" SourceVersion="Current" />
    … …  
    640639                <SelectCommand>
    641640                  <DbCommand CommandType="Text" ModifiedByUser="true">
    642                     <CommandText>SELECT * FROM dbo.JobResult</CommandText>
     641                    <CommandText>SELECT     JobResultId, JobId, Message, Percentage, ResourceId, DateFinished
     642FROM         JobResult</CommandText>
    643643                    <Parameters />
    644644                  </DbCommand>
    … …  
    646646                <UpdateCommand>
    647647                  <DbCommand CommandType="Text" ModifiedByUser="false">
    648                     <CommandText>UPDATE [dbo].[JobResult] SET [JobResultId] = @JobResultId, [JobId] = @JobId, [JobResult] = @JobResult, [Message] = @Message, [Percentage] = @Percentage, [ResourceId] = @ResourceId, [DateFinished] = @DateFinished WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsNull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)) AND ((@IsNull_DateFinished = 1 AND [DateFinished] IS NULL) OR ([DateFinished] = @Original_DateFinished)));
    649 SELECT JobResultId, JobId, JobResult, Message, Percentage, ResourceId, DateFinished FROM JobResult WHERE (JobResultId = @JobResultId)</CommandText>
     648                    <CommandText>UPDATE [JobResult] SET [JobResultId] = @JobResultId, [JobId] = @JobId, [Message] = @Message, [Percentage] = @Percentage, [ResourceId] = @ResourceId, [DateFinished] = @DateFinished WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsNull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)) AND ((@IsNull_DateFinished = 1 AND [DateFinished] IS NULL) OR ([DateFinished] = @Original_DateFinished)));
     649SELECT JobResultId, JobId, Message, Percentage, ResourceId, DateFinished FROM JobResult WHERE (JobResultId = @JobResultId)</CommandText>
    650650                    <Parameters>
    651651                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@JobResultId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobResultId" SourceColumnNullMapping="false" SourceVersion="Current" />
    652652                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
    653                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@JobResult" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="JobResult" SourceColumnNullMapping="false" SourceVersion="Current" />
    654653                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Message" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="false" SourceVersion="Current" />
    655654                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Percentage" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Percentage" SourceColumnNullMapping="false" SourceVersion="Current" />
    … …  
    673672              <Mapping SourceColumn="JobResultId" DataSetColumn="JobResultId" />
    674673              <Mapping SourceColumn="JobId" DataSetColumn="JobId" />
    675               <Mapping SourceColumn="JobResult" DataSetColumn="JobResult" />
    676674              <Mapping SourceColumn="Message" DataSetColumn="Message" />
    677675              <Mapping SourceColumn="Percentage" DataSetColumn="Percentage" />
    … …  
    683681                <SelectCommand>
    684682                  <DbCommand CommandType="Text" ModifiedByUser="true">
    685                     <CommandText>SELECT DateFinished, JobId, JobResult, JobResultId, Message, Percentage, ResourceId FROM JobResult WHERE (JobResultId = @Id)</CommandText>
     683                    <CommandText>SELECT DateFinished, JobId, JobResultId, Message, Percentage, ResourceId FROM JobResult WHERE (JobResultId = @Id)</CommandText>
    686684                    <Parameters>
    687685                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="JobResultId" DataSourceName="[HeuristicLab.Hive].dbo.JobResult" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="JobResultId" SourceColumnNullMapping="false" SourceVersion="Current" />
    … …  
    693691                <SelectCommand>
    694692                  <DbCommand CommandType="Text" ModifiedByUser="true">
    695                     <CommandText>SELECT DateFinished, JobId, JobResult, JobResultId, Message, Percentage, ResourceId FROM JobResult WHERE (JobId = @JobId)</CommandText>
     693                    <CommandText>SELECT DateFinished, JobId, JobResultId, Message, Percentage, ResourceId FROM JobResult WHERE (JobId = @JobId)</CommandText>
    696694                    <Parameters>
    697695                      <Parameter AllowDbNull="true" AutogeneratedName="JobId" ColumnName="JobId" DataSourceName="[HeuristicLab.Hive].dbo.JobResult" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
    … …  
    703701                <SelectCommand>
    704702                  <DbCommand CommandType="Text" ModifiedByUser="true">
    705                     <CommandText>SELECT TOP 1 JobResult.*  FROM JobResult WHERE JobId = @JobId ORDER BY DateFinished DESC </CommandText>
     703                    <CommandText>SELECT TOP (1) DateFinished, JobId, JobResultId, Message, Percentage, ResourceId FROM JobResult WHERE (JobId = @JobId) ORDER BY DateFinished DESC</CommandText>
    706704                    <Parameters>
    707705                      <Parameter AllowDbNull="true" AutogeneratedName="JobId" ColumnName="JobId" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.JobResult" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
    … …  
    709707                  </DbCommand>
    710708                </SelectCommand>
     709              </DbSource>
     710              <DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.JobResult" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetSerializedJobResultById" Modifier="Public" Name="GetSerializedJobResultById" QueryType="Scalar" ScalarCallRetval="System.Byte[], mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetSerializedJobResultById">
     711                <SelectCommand>
     712                  <DbCommand CommandType="Text" ModifiedByUser="true">
     713                    <CommandText>SELECT JobResult FROM JobResult WHERE JobResultId = @Id</CommandText>
     714                    <Parameters>
     715                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="JobResultId" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.JobResult" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="JobResultId" SourceColumnNullMapping="false" SourceVersion="Current" />
     716                    </Parameters>
     717                  </DbCommand>
     718                </SelectCommand>
     719              </DbSource>
     720              <DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateSerializedJobResultById" Modifier="Public" Name="UpdateSerializedJobResultById" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateSerializedJobResultById">
     721                <UpdateCommand>
     722                  <DbCommand CommandType="Text" ModifiedByUser="true">
     723                    <CommandText>UPDATE JobResult SET JobResult = @JobResult WHERE JobResultId = @Id</CommandText>
     724                    <Parameters>
     725                      <Parameter AllowDbNull="true" AutogeneratedName="JobResult" ColumnName="JobResult" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.JobResult" DataTypeServer="varbinary(MAX)" DbType="Binary" Direction="Input" ParameterName="@JobResult" Precision="0" ProviderType="VarBinary" Scale="0" Size="2147483647" SourceColumn="JobResult" SourceColumnNullMapping="false" SourceVersion="Current" />
     726                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="JobResultId" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.JobResult" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="JobResultId" SourceColumnNullMapping="false" SourceVersion="Original" />
     727                    </Parameters>
     728                  </DbCommand>
     729                </UpdateCommand>
    711730              </DbSource>
    712731            </Sources>
    … …  
    11331152              <xs:element name="JobResultId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="JobResultId" msprop:Generator_ColumnVarNameInTable="columnJobResultId" msprop:Generator_ColumnPropNameInRow="JobResultId" msprop:Generator_ColumnPropNameInTable="JobResultIdColumn" type="xs:string" />
    11341153              <xs:element name="JobId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="JobId" msprop:Generator_ColumnVarNameInTable="columnJobId" msprop:Generator_ColumnPropNameInRow="JobId" msprop:Generator_ColumnPropNameInTable="JobIdColumn" type="xs:string" minOccurs="0" />
    1135               <xs:element name="JobResult" msprop:Generator_UserColumnName="JobResult" msprop:Generator_ColumnVarNameInTable="columnJobResult" msprop:Generator_ColumnPropNameInRow="JobResult" msprop:Generator_ColumnPropNameInTable="JobResultColumn" type="xs:base64Binary" minOccurs="0" />
    11361154              <xs:element name="Message" msprop:Generator_UserColumnName="Message" msprop:Generator_ColumnVarNameInTable="columnMessage" msprop:Generator_ColumnPropNameInRow="Message" msprop:Generator_ColumnPropNameInTable="MessageColumn" minOccurs="0">
    11371155                <xs:simpleType>
Note: See TracChangeset for help on using the changeset viewer.