[
https://issues.apache.org/jira/browse/AMQNET-642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17163608#comment-17163608
]
gayatri joshi commented on AMQNET-642:
--------------------------------------
Anyone please help on this... issue
> 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
> Priority: Major
>
> 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)
