Thank you for your assistance, indeed with a buffersize = "1" �vents are stored directly in base. But i have always a problem with the Windows services: Indeed on my server, i have a service which turns but no �vent is registered in base, even with a buffersize = "1". If you could also help me on this problem, Thank.
Selon Nicko Cadell <[EMAIL PROTECTED]>: > The ADONetAppender is able to buffer events before writing them to the > DB. > The buffer size is controlled the following configuration: > > <param name="bufferSize" value="100" /> > > This means that the appender will not write anything to the DB until it > has buffered 100 events, it will then write all the events in the buffer > in one go. When log4net shuts down the appender will try to write > anything still in its buffer. > > If you want the appender to write immediately to the DB then set the > bufferSize to 0. > > Nicko > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: 19 July 2004 13:54 > > To: [email protected] > > Subject: ADONETAPPENDER > > > > > > > > Hello, > > I want to use the appender ADOnetappender to write messages > > in a sqlserver database. I use this appender configuration: > > > > <appender name="ADONetAppender_SqlServer" > > type="log4net.Appender.ADONetAppender"> > > <param name="bufferSize" value="100" /> > > <param name="ConnectionType" > > value="System.Data.SqlClient.SqlConnection, > > System.Data, Version=1.0.3300.0, Culture=neutral, > > PublicKeyToken=b77a5c561934e089" /> > > <param name="ConnectionString" value="data > > source=SERV-ANTENNA1;initial catalog=LOG;integrated > > security=SSPI;persist security info=False;User > > ID=TOTO;Password=TOTO" /> > > <param name="CommandText" value="INSERT INTO LOG > > ([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="DateTime" /> > > <param name="Layout" > > type="log4net.Layout.PatternLayout"> > > <param name="ConversionPattern" > > value="%d{yyyy'-'MM'-'dd > > HH':'mm':'ss'.'fff}" /> > > </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> > > </param> > > > > But I am confronted with several problems: > > > > - first problem: I use Windows services, and message from > > these services are not written in database . > > - Second probleme: Messages are written only when the user > > quit application. > > > > If you could help me to solve these problem, thank you for > > your assistance. > > >
