Hi All,

I've spent about 4 hours today trying to get this working and have
totally failed so far.

I can't even really find much info on how to configure this purely in
Code.  In fact there is precious little I can find on the net in fact.

Here is the code I'm using the set up the AdoNetAppender in my app:


public static void ConfigureDatabaseAppender(string connString)
{
PatternLayout layout = GetDefaultLayout();
_sqlDatabaseAppender = new AdoNetAppender();
_sqlDatabaseAppender.Layout = layout;
_sqlDatabaseAppender.UseTransactions = false;
_sqlDatabaseAppender.BufferSize = 1;

_sqlDatabaseAppender.CommandType = System.Data.CommandType.Text;
_sqlDatabaseAppender.ConnectionString = connString;
_sqlDatabaseAppender.CommandText = "INSERT INTO Log
([Date],[Level],[Thread],[Logger],[Message],[Exception]) VALUES
(@log_date, @log_level, @thread, @logger, @message, @exception)";
AdoNetAppenderParameter logDate = new AdoNetAppenderParameter();
RawTimeStampLayout dateLayout = new RawTimeStampLayout();
logDate.ParameterName = "@log_date";
logDate.Layout = dateLayout;
logDate.DbType = System.Data.DbType.DateTime;
_sqlDatabaseAppender.AddParameter(logDate);
AdoNetAppenderParameter logThread = new AdoNetAppenderParameter();
logThread.ParameterName = "@thread";
logThread.Size = 255;
logThread.DbType = System.Data.DbType.String;
_sqlDatabaseAppender.AddParameter(logThread);
AdoNetAppenderParameter logLevel = new AdoNetAppenderParameter();
logLevel.ParameterName = "@log_level";
logLevel.Size = 50;
logLevel.DbType = System.Data.DbType.String;
_sqlDatabaseAppender.AddParameter(logLevel);
AdoNetAppenderParameter logLogger = new AdoNetAppenderParameter();
logLogger.ParameterName = "@logger";
logLogger.Size = 255;
logLogger.DbType = System.Data.DbType.String;
_sqlDatabaseAppender.AddParameter(logLogger);
AdoNetAppenderParameter logMessage = new AdoNetAppenderParameter();
logMessage.ParameterName = "@message";
logMessage.Size = 4000;
logMessage.DbType = System.Data.DbType.String;
_sqlDatabaseAppender.AddParameter(logMessage);
AdoNetAppenderParameter logException = new AdoNetAppenderParameter();
logException.ParameterName = "@exception";
logException.Size = 2000;
logException.DbType = System.Data.DbType.String;
_sqlDatabaseAppender.AddParameter(logException);
_sqlDatabaseAppender.ActivateOptions();

BasicConfigurator.Configure(_sqlDatabaseAppender);
}

Any help would be great.

James.

Have you already gotten AdoNetAppender to work from a app.config /
web.config first?  If not, I'd suggest getting that to work first.  You
may learn something in that process and it'll spark a realization of
what you're missing in the from-code approach?

I may have to try that.  Currently it just fails with an "Oject
reference not set to an instance of an object."

Thanks,

James.

No I haven't - and to be fair, I did try doing this a while ago:

<code file='global.asax' method='Application_Start'>

            log4net.Config.XmlConfigurator.Configure();

            //reset the logger to use the default con string - so we
only need to change it on one place
            var hier =
              log4net.LogManager.GetRepository() as
log4net.Repository.Hierarchy.Hierarchy;

            if (hier != null)
            {
                //get ADONetAppender
                var adoAppender =
(log4net.Appender.AdoNetAppender)hier.GetLogger("root",hier.LoggerFactory).GetAppender("AdoNetAppender");
                var adoAppender =
(log4net.Appender.AdoNetAppender)hier.Root.AppendersΎ]
                if (adoAppender != null)
                {
                    adoAppender.ConnectionString =
AppSettings.GetConfigurationString("MainConnection");
                    adoAppender.ActivateOptions(); //refresh settings
of appender
                }
            }

</code>

and failed - but this is possibly because of a few things outside the
responsibility of the log4net codebase.

There's nothing wrong working through a poroblem - to help improve the
situ - but just rubbishing it won't help anyone.

w://

Hi Again,

<snip>
</code>

Indeed, this isn't the most straight forward thing.

>and failed - but this is possibly because of a few things outside the
>responsibility of the log4net codebase.

>There's nothing wrong working through a poroblem - to help improve the
>situ - but just rubbishing it won't help anyone.

Sure, but when  your back is against the wall and you've been given a
day to write a complete logging library running up against this problem
when *everything* else works as expected is a bit frustrating.

What is even weirder is that I now have dates going into the database
... However, everything else is null ...

I've just pulled it down to two fields now, using this as a pattern:

"%date %level"

Date logs find ... Level is always null ...

You are right, rubbishing it is plain stupid on my part.

Cheers,

James.

Cracked it ...

            AdoNetAppenderParameter logLevel = new
AdoNetAppenderParameter();
            logLevel.ParameterName = "@log_level";
            logLevel.Layout = new Layout2RawLayoutAdapter(new
PatternLayout("%level"));
            logLevel.Size = 50;
            logLevel.DbType = System.Data.DbType.String;
            _sqlDatabaseAppender.AddParameter(logLevel);

Regards,

James.

bet that was a 'punching hands in the air' geek moment from hell!!!!

> bet that was a 'punching hands in the air' geek moment from hell!!!!

Indeed ... I may even make a cup of tea to celebrate! :)

Cheers,

James.

You could have also copied the built-in TimeStamp layout

        // log4net.Layout
        public class RawTimeStampLayout : IRawLayout
        {
            public object Format(LoggingEvent loggingEvent)
            {
                return loggingEvent.TimeStamp;
            }
        }

and made your own Level layout:

        public class RawLevelLayout : IRawLayout
        {
            public object Format(LoggingEvent loggingEvent)
            {
                return loggingEvent.Level;
            }
        }