Hi Rob, Yes, I included the ReconnectOnError clause in my configuration and the log is obtained. Any idea why the connection issue happened after the server reboot?
All these while, I did not face such problem. Thanks, Shally On Wed, Jul 28, 2010 at 9:29 PM, Rob Prouse <rob.pro...@ivara.com> wrote: > Shally, > > > > In your configuration for the AdoNetAppender, do you have ReconnectOnError > set to true? It defaults to false and is not in the example configuration. > > > > > http://logging.apache.org/log4net/release/sdk/log4net.Appender.AdoNetAppender.ReconnectOnError.html > > > > If not, add the following line to the appender and see if it helps. > > > > <reconnectOnError value=”true”> > > > > Hope this works for you, > > > > Rob Prouse > > > > *From:* shally chong [mailto:shally.ch...@gmail.com] > *Sent:* Wednesday, July 28, 2010 1:52 AM > > *To:* log4net-user@logging.apache.org > *Subject:* Fwd: ADONetAppender not logging > > > > > > Hi, > > I encountered a problem with ADONetAppender in production server after the > DC perform restart for that server. > I have a .net c# window application where it will do some data loading into > mysql server. After the data loading completed or any exception thrown > during the data loading process, log4net will capture the error and store > into mysql table as well. There will be no file loading from 2am - 6am, > where during this time, there will be no log captured into mysql. Initially, > after the file loaded into server at 6am, the log4net will start capturing > log again. All these while, the log4net is able to capture log after the > data loading process resume. But after the server being restarted, there is > no more log captured into mysql after data loading process resume. And I > have to manually restart the window services (the window application running > as window services) daily to obtain the log again. > I've tried to modify the log4net to capture log into flat file, and it's > working fine (all logs are captured after data loading process resume). > > Please take note that the data loading process is working fine and data are > inserted into mysql server correctly. The only not working is ADONetAppender > is not capturing any logs after data loading process resume. > > Please advise. > > Thanks, > Shally > > >
