RE: Suggestion for Access Appender

[Nicko Cadell <ni...@neoworks.com>]

Jim,

Access isn't my favourite DB ;) but these look like good improvements.

Many thanks,
Nicko 

> -----Original Message-----
> From: Jim Rand [mailto:jimrand@ix.netcom.com] 
> Sent: 25 March 2004 22:52
> To: log4net-dev@logging.apache.org
> 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>
> 
>