Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.15
    • Fix Version/s: 2.1.0
    • Component/s: Appenders
    • Labels:
    • Environment:
      C#
    • Flags:
      Patch, Important

      Description

      I am using the AdoNetAppender to log audits to the database. I was using until some time the 1.2.13 version with a configuration for MSSQL or PostgreSQL which inserted practically data as json strings that will later be interpreted by another tool using the following appender configuration.

      EX: <appender name="NpgsqlAppender" type="log4net.Appender.AdoNetAppender">
      <filter type="log4net.Filter.LevelRangeFilter">
      <levelMin value="AUDIT" />
      <levelMax value="AUDIT" />
      </filter>
      <bufferSize value="1"/>
      <connectionType
      value="Npgsql.NpgsqlConnection, Npgsql" />
      <connectionString
      value="Server=

      {myServer}

      ;Port=5432;Database=

      {database}

      ;User Id=

      {myuser}

      ;Password=

      {mypassword}

      " />
      <commandText value="INSERT INTO audit (message) VALUES (@message);" />
      <reconnectOnError value="true" />
      <useTransactions value="false"/>
      <parameter>
      <parameterName value="@message" />
      <dbType value="String" />
      <layout type="log4net.Layout.PatternLayout" >
      <conversionPattern value="%message"/>
      </layout>
      </parameter>
      </appender>

      It worked great until I have updated to 1.2.15 and then we have noticed that the PosgreSQL appender did not worked any more. After doing some research and testing I have narrowed it down to the AdoNetAppender
      that probably has a problem with the parameters because it shows a PG error 47203 as column "message" not found.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                nachbarslumpi Dominik Psenner
                Reporter:
                xty250hp Cristian Margescu
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: