Jim, Access isn't my favourite DB ;) but these look like good improvements.
Many thanks, Nicko > -----Original Message----- > From: Jim Rand [mailto:[EMAIL PROTECTED] > Sent: 25 March 2004 22:52 > To: [email protected] > Subject: Suggestion for Access Appender > > <!-- Revised appender for Microsoft Access. > Table definition: > Log4NetID AutoNumber (primary key) > Date Date/Time > Thread Text (Length=255) > Level Text (Length=50) > Logger Text (Length=255) > Message Memo > Exception Memo (Allow Zero Length = yes) > > Changes over prior version: > > 1) By explicitly setting the date pattern to > "%d{yyyy-MM-dd HH:mm:ss}", you > can use a Date/Time data type in Access. > > 2) By allowing a zero length in the field "Exception" > both ILog.<level> constructors > will work. > For example: _log.Info("Processing Complete"); > _log.Error("Unhandled exception in the > main thread",e.Exception); > > 3) @exception field is added. > --> > > <appender name="ADONetAppender_Access" > type="log4net.Appender.ADONetAppender"> > <param name="ConnectionString" > value="Provider=Microsoft.Jet.OLEDB.4.0;Data > Source=C:\\Usr\\Log\\Logger.mdb;User Id=;Password=;" /> > <param name="CommandText" value="INSERT INTO Log4Net > ([Date],[Thread],[Level],[Logger],[Message],[Exception]) > VALUES (@log_date, @thread, @log_level, @logger, @message, > @exception )" /> > <param name="Parameter"> > <param name="ParameterName" value="@log_date" /> > <param name="DbType" value="String" /> > <param name="Size" value="255" /> > <param name="Layout" type="log4net.Layout.PatternLayout"> > <param name="ConversionPattern" value="%d{yyyy-MM-dd > HH:mm:ss}" /> > </param> > </param> > <param name="Parameter"> > <param name="ParameterName" value="@thread" /> > <param name="DbType" value="String" /> > <param name="Size" value="255" /> > <param name="Layout" type="log4net.Layout.PatternLayout"> > <param name="ConversionPattern" value="%t" /> > </param> > </param> > <param name="Parameter"> > <param name="ParameterName" value="@log_level" /> > <param name="DbType" value="String" /> > <param name="Size" value="50" /> > <param name="Layout" type="log4net.Layout.PatternLayout"> > <param name="ConversionPattern" value="%p" /> > </param> > </param> > <param name="Parameter"> > <param name="ParameterName" value="@logger" /> > <param name="DbType" value="String" /> > <param name="Size" value="255" /> > <param name="Layout" type="log4net.Layout.PatternLayout"> > <param name="ConversionPattern" value="%c" /> > </param> > </param> > <param name="Parameter"> > <param name="ParameterName" value="@message" /> > <param name="DbType" value="String" /> > <param name="Size" value="4000" /> > <param name="Layout" type="log4net.Layout.PatternLayout"> > <param name="ConversionPattern" value="%m" /> > </param> > </param> > <param name="Parameter"> > <param name="ParameterName" value="@exception" /> > <param name="DbType" value="String" /> > <param name="Size" value="2000" /> > <param name="Layout" type="log4net.Layout.ExceptionLayout" /> > </param> > </appender> > >
