Database Appender

["Ismay, Greg (CALBRIS)" <Gr...@comalco.riotinto.com.au>]

> howdy everyone...
> 
> im using the database ADONetAppender to log to a sql server database and its all going peachy keen... for a while...
> 
> ive got the same app installed at 4 of our sites, with the appender pointing back to a central database accessible over the wan (i will probably end up using a local db at each site, but a central db was my going in position, with a "lets see how it goes before we decentralise" mentality). the wans pretty fast and im only doing production logging (ie only errors and fatals) this way.
> 
> basically, it works for a few days and sometimes up to a week or so, before the logging just stops.
> 
> forcing the loggers to reinitialised (ie by "touch"ing the log4net.config file) makes it all good again...
> 
> my question is this... are there any known problems with the db appender (or any appender) whereby a loss of connection (which can happen over the wan) over time could result in the above state (eg... maybe running out of connections in the pool due to them gradually getting "stuck")
> 
> ill troll through the code in a few minutes, but just thought id ask first.
> 
> thanks,
> 
> Greg Ismay
> 
> Specialist - Database Support (Automation Improvement)
> Comalco Aluminium Limited
> 
> Phone 	:   +61 7 3867 1853
> Fax    	:   +61 7 3867 1855
> Mobile	:   +61 4 1760 6429
>