What version of Postgresql are you using? Our company is using 9.4.5 and log4net 1.2.15 with no issues.
On Mon, Dec 12, 2016 at 7:30 AM, Cristian Margescu (JIRA) <j...@apache.org> wrote: > > [ https://issues.apache.org/jira/browse/LOG4NET-538?page= > com.atlassian.jira.plugin.system.issuetabpanels:comment- > tabpanel&focusedCommentId=15741894#comment-15741894 ] > > Cristian Margescu commented on LOG4NET-538: > ------------------------------------------- > > Hi, > I would be glad to but I have time as of 20th this month. So if there is > no real hurry would be my pleasure. you can contact me per email with > details. > Thank You > > > AdoNetAppender to PostgreSQL > > ---------------------------- > > > > Key: LOG4NET-538 > > URL: https://issues.apache.org/jira/browse/LOG4NET-538 > > Project: Log4net > > Issue Type: Bug > > Components: Appenders > > Affects Versions: 1.2.15 > > Environment: C# > > Reporter: Cristian Margescu > > Labels: patch > > > > 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. > > > > > > -- > This message was sent by Atlassian JIRA > (v6.3.4#6332) >