Uploaded image for project: 'ActiveMQ .Net'
  1. ActiveMQ .Net
  2. AMQNET-642

Log4net Adonetappender not working with postgresSQL with Error as 42703: column "message" does not exist

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.7.2
    • Fix Version/s: None
    • Component/s: WCF
    • Labels:
      None

      Description

      below is my appender:

      <appender name="AdoNetAppender_Postgres" type="MicroKnights.Logging.AdoNetAppender,MicroKnights.Log4NetAdoNetAppender">

      <bufferSize value="1" />
      <connectionType value="Npgsql.NpgsqlConnection, Npgsql, Culture=neutral" />
      <connectionString value="Host=localhost;Username=postgres;Password=1234;Database=Logging" />
      <commandText value="INSERT INTO logdebug (message1) VALUES (message)" />
      <parameter>
      <parameterName value="@log_date" />
      <dbType value="DateTime" />
      <layout type="log4net.Layout.RawTimeStampLayout" />
      </parameter>
      <parameter>
      <parameterName value="@thread" />
      <dbType value="String" />
      <size value="32" />
      <layout type="log4net.Layout.PatternLayout">
      <conversionPattern value="%t" />
      </layout>
      </parameter>
      <parameter>
      <parameterName value="@log_level" />
      <dbType value="String" />
      <size value="512" />
      <layout type="log4net.Layout.PatternLayout">
      <conversionPattern value="%p" />
      </layout>
      </parameter>
      <parameter>
      <parameterName value="@logger" />
      <dbType value="String" />
      <size value="512" />
      <layout type="log4net.Layout.PatternLayout">
      <conversionPattern value="%c" />
      </layout>
      </parameter>
      <parameter>
      <parameterName value="message" />
      <dbType value="String" />
      <size value="4000" />
      <layout type="log4net.Layout.PatternLayout">
      <conversionPattern value="%m" />
      </layout>
      </parameter>
      <parameter>
      <parameterName value="@exception" />
      <dbType value="String" />
      <size value="2000" />
      <layout type="log4net.Layout.ExceptionLayout" />
      </parameter>
      </appender>

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              gayatri.joshi gayatri joshi
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: