gayatri joshi created AMQNET-642:
------------------------------------
Summary: Log4net Adonetappender not working with postgresSQL with
Error as 42703: column "message" does not exist
Key: AMQNET-642
URL: https://issues.apache.org/jira/browse/AMQNET-642
Project: ActiveMQ .Net
Issue Type: Bug
Components: WCF
Affects Versions: 1.7.2
Reporter: gayatri joshi
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>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
