ADONetAppender through a firewall

[Dave Hutz <da...@cgadc.com>]

We have been running into trouble while using ADONetAppender to log to a database that is behind a firewall.

In short, the firewall times-out idle connections, and log4net doesn't reconnect to the database once the connection is broken.

I added some code like this, and it seems to fix the problem.

/// <summary>
/// This method determines if there is a sense in attempting to append.
/// </summary>
/// <remarks>
/// <para>
/// This method checks if the db is open.  If it isn't, it opens it.
/// </para>
/// </remarks>
/// <returns><c>false</c> if any of the preconditions fail.</returns>
override protected bool PreAppendCheck()
{
	if (!base.PreAppendCheck())
	{
		return false;
	}
	if (m_dbConnection==null ||
	    m_dbConnection.State!=ConnectionState.Open)
	{
		InitialiseDatabaseConnection();
		InitialiseDatabaseCommand(); //must reinitialize the command if we redo the connection
	}
	return true; //it throws above if it fails
}



Could you include this (or something like it) into the main code?

Thanks,
	Dave