RE: [External] Asynchronous mode for AdoNetAppender.

2015-11-18 Thread Zia Haider
Thanks Nitin, It worked!! From: Goyal, Nitin Export License Required - US UTAS [mailto:nitin.go...@utas.utc.com] Sent: Wednesday, November 18, 2015 2:05 AM To: Log4NET User Subject: RE: [External] Asynchronous mode for AdoNetAppender. Check this out https://issues.apache.org/jira

RE: [External] Asynchronous mode for AdoNetAppender.

2015-11-17 Thread Goyal, Nitin Export License Required - US UTAS
hronous mode for AdoNetAppender. Hi there, I have been using log4net FileAppender for some time, but now I need to log all my data in to database. I am trying to use AdoNetAppender for that, but I it is working in synchronous mode. I noticed that FileAppender works in asynchronous mode where AdoNe

Asynchronous mode for AdoNetAppender.

2015-11-17 Thread Zia Haider
Hi there, I have been using log4net FileAppender for some time, but now I need to log all my data in to database. I am trying to use AdoNetAppender for that, but I it is working in synchronous mode. I noticed that FileAppender works in asynchronous mode where AdoNetAppender works in

RE: AdoNetAppender on Azure SQL: Works then quits working

2014-09-18 Thread Joe
It's in the FAQ: http://logging.apache.org/log4net/release/faq.html -Original Message- From: Steve Hueners [mailto:am.st...@gmail.com] Sent: 18 September 2014 12:12 To: Log4NET User Subject: Re: AdoNetAppender on Azure SQL: Works then quits working On Wed, A

Re: AdoNetAppender on Azure SQL: Works then quits working

2014-09-18 Thread Steve Hueners
On Wed, Aug 20, 2014 at 11:01 AM, Joe wrote: > and route this trace output to a file. Thanks much for your reply. I'm not clear about how to route the internal debug output to a trace file. An Azure website provides access to the file system via the project's App_Data so if I knew the precise st

RE: AdoNetAppender on Azure SQL: Works then quits working

2014-08-20 Thread Joe
I'd try enabling Log4net tracing () and route this trace output to a file. It might give you a clue as to what's happening - perhaps AdoNetAppender is not recovering from a database connection failure properly. -Original Message- From: Steve Hueners [mailto:am.st...@gmail.

Re: AdoNetAppender on Azure SQL: Works then quits working

2014-08-19 Thread Steve Hueners
It happened again last night - I had a line logged at 2014-08-19 00:59:59.537 (gmt) then nothing until I restarted the website. On Mon, Aug 18, 2014 at 3:07 PM, Steve Hueners wrote: > Last week I stepped thru the hoops required to configure a connection > string for my Azure SQL db and confirmed

AdoNetAppender on Azure SQL: Works then quits working

2014-08-18 Thread Steve Hueners
Last week I stepped thru the hoops required to configure a connection string for my Azure SQL db and confirmed that logging was working as expected. Log messages were stored for several days, but at some point, the logging ceased. I re-published the site (without changing anything related to Log4N

AdoNetAppender - Wrong Values in Some Columns

2014-07-02 Thread Brian Broughton
Hello, I have configured an AdoNetAppender in code (see below). I do end up with a record inserted into the table. The values inserted into the Date, Message and Exception columns are correct. However, the Thread, Level and Logger columns all contain the contents of "%message. If I use a

Re: AdoNetAppender not working PostgreSQL database using Npgsql

2014-05-30 Thread Dominik Psenner
Glad you were able to sort it out on your own and be sure that it would have taken ages to find this. :-) Cheers 2014-05-30 21:32 GMT+02:00 Rob Richardson : > Sorry to bother you. The problem turns out to be what seems to me an > unbelievable bug (feature?) in the PostgreSQL administration to

RE: AdoNetAppender not working PostgreSQL database using Npgsql

2014-05-30 Thread Rob Richardson
Sorry to bother you. The problem turns out to be what seems to me an unbelievable bug (feature?) in the PostgreSQL administration tool PGAdmin shipped with version 9.3: if you use that tool to create a table, the name of the table includes double quotes. I decided, just for grins, to try the

AdoNetAppender not working PostgreSQL database using Npgsql

2014-05-30 Thread Rob Richardson
Greetings! I am trying to get an AdoNetAppender to work, and I'm not succeeding. For now, all I'm trying to do is to write a constant message to a database table. Along with the AdoNetAppender, I have a RollingFileAppender that is working well. I should get one record in my log

Re: Help needed with debugging AdoNetAppender

2014-02-22 Thread d_k
If its easily reproducible you can get the source code and debug the AdoNetAppender. On Fri, Feb 21, 2014 at 5:48 PM, Tom Williams wrote: > We're using log4net 1.2.11 to log to a SQL Server database from an > internal Windows service. For the most part, log4net is working very we

Help needed with debugging AdoNetAppender

2014-02-21 Thread Tom Williams
o "true" in the log4net.config file but the database connection doesn't appear to get re-established. Anyway, I found how to enable log4net internal debugging and when I enable it, I get log messages but nothing from the AdoNetAppender. I can see the AdoNetAppender being setup, but when I su

Re: Log4net ADONetAppender

2013-08-16 Thread Peter K
og4net configuration (XML) within an appender. > > ** ** > > *Von:* Peter K [mailto:pkfxtranspare...@gmail.com] > *Gesendet:* Dienstag, 13. August 2013 22:33 > *An:* Log4NET User > *Betreff:* Re: Log4net ADONetAppender > > ** ** > > Thanks for the response. >

AW: Log4net ADONetAppender

2013-08-13 Thread Dominik Psenner
Hard to tell. It should be some type (i.e. class) that is mentioned in the log4net configuration (XML) within an appender. Von: Peter K [mailto:pkfxtranspare...@gmail.com] Gesendet: Dienstag, 13. August 2013 22:33 An: Log4NET User Betreff: Re: Log4net ADONetAppender Thanks for the

Re: Log4net ADONetAppender

2013-08-13 Thread Peter K
gt; Hello, >> >> I recently migrated an application to a new server (Windows 2008 Server >> R2, SQL Server 2008 R2, Poweshell) and everything works except I get an >> error when trying to log to the database. >> >> log4net:ERROR XmlHiera

Re: Log4net ADONetAppender

2013-08-13 Thread Dominik Psenner
rver 2008 R2, Poweshell) and everything works except I get an > error when trying to log to the database. > > log4net:ERROR XmlHierarchyConfigurator: Could not create Appender > [ADONetAppender] of type [log4net.Appender.ADONetAppender]. Reported error > follows. >

Log4net ADONetAppender

2013-08-13 Thread Peter K
Hello, I recently migrated an application to a new server (Windows 2008 Server R2, SQL Server 2008 R2, Poweshell) and everything works except I get an error when trying to log to the database. log4net:ERROR XmlHierarchyConfigurator: Could not create Appender [ADONetAppender] of type

ADONetAppender: First log message after reconnect won't be logged

2012-03-29 Thread Christoph
Hi all, I've a problem with the ADONetAppender. I'm developing C# client-application which is logging to a mysql-database. The application often runs for several days without being restart. Therefore, it isn't uncommon that the db-connection is terminated or broken, so I'

Re: log4net AdoNetAppender common connectionstring value

2012-02-02 Thread Ron Grabowski
@logging.apache.org Sent: Wednesday, February 1, 2012 7:16 PM Subject: Re: log4net AdoNetAppender common connectionstring value " I do something along that line. I have a connection string inside machine.config and I wrapped l4n in a wrapper dll that's used in many projects. I actually deploy

Re: log4net AdoNetAppender common connectionstring value

2012-02-01 Thread mmingfeilam
;   so you are doing this programmatically, is there a way to do it using the configuration file, something along the line of: -- View this message in context: http://old.nabble.com/log4net-AdoNetAppender-common-connectionstring-value-tp33244792p33245873.html Sent from the Log4net - Users mailing list archive at Nabble.com.

Re: log4net AdoNetAppender common connectionstring value

2012-02-01 Thread Todd
of appender          }     }     }     }   From: mmingfeilam To: log4net-user@logging.apache.org Sent: Wednesday, February 1, 2012 2:12 PM Subject: log4net AdoNetAppender common connectionstring value i have two exes in

log4net AdoNetAppender common connectionstring value

2012-02-01 Thread mmingfeilam
i have two exes in my solution that are run simultaeneously. each exe has a log4net.xml file with a AdoNetAppender in it: is there any way to move the value of the connectionstring to a common file and just reference it by name? would it be possible to move the

Re: Log4Net Error on DB Connect AdoNetAppender

2011-07-11 Thread Ron Grabowski
Try adding an ErrorHandler on the appender: http://logging.apache.org/log4net/release/sdk/log4net.Core.IErrorHandler.html AdoNetAppender adoAppender = newAdoNetAppender(); adoAppender.ErrorHandler = new FileAppenderErrorHandler(); From: meisenstein To: log4net

Log4Net Error on DB Connect AdoNetAppender

2011-07-11 Thread meisenstein
I have my AdoNetAppender as code instead of as a XML config file, log4net.Appender.AdoNetAppender adoAppender = new log4net.Appender.AdoNetAppender(); I would like to catch an error if the database it's trying to connect to is down, so that I can switch over to the file appender. Th

How to add multiple AdoNetAppender?

2010-12-16 Thread raysefo
Hi, I m using one AdoNetAppender and it works great. But i need to log into another table so i would like to add another AdoNetAppender. I added another one with appropriate configurations but no logging occured for the new table. Here is my web.config

RE: ADONetAppender not logging

2010-07-30 Thread Rob Prouse
...@gmail.com] Sent: Thursday, July 29, 2010 9:13 PM To: Log4NET User Subject: Re: ADONetAppender not logging Hi Rob, I notice that and I've included it in my configuration files. I'm able to trap the mysql connection error with the internal logging file. Exception: "an established

Re: ADONetAppender not logging

2010-07-29 Thread shally chong
29, 2010 at 8:10 PM, Rob Prouse wrote: > Shally, > > > > Looking at the code for AdoNetAppender, it will not log if the connection > is lost and the reconnect fails. It will however output problems to its > internal logging. I think your best option right now is to enable l

RE: ADONetAppender not logging

2010-07-29 Thread Rob Prouse
Shally, Looking at the code for AdoNetAppender, it will not log if the connection is lost and the reconnect fails. It will however output problems to its internal logging. I think your best option right now is to enable log4net's internal logging and see if it can help diagnose the pr

Re: ADONetAppender not logging

2010-07-28 Thread shally chong
hat changed on the server to cause the > failure. There may be a bug in the AdoNetAppender, but whatever changed on > the server probably caused the bug to appear, so knowing what changed will > help us track down the problem. > > > > My first thoughts are an update to the

RE: ADONetAppender not logging

2010-07-28 Thread Rob Prouse
the failure. There may be a bug in the AdoNetAppender, but whatever changed on the server probably caused the bug to appear, so knowing what changed will help us track down the problem. My first thoughts are an update to the .NET runtime, or to the MySQL server. Rob Prouse From: shally

Re: ADONetAppender not logging

2010-07-28 Thread shally chong
lly, > > > > 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

RE: ADONetAppender not logging

2010-07-28 Thread Rob Prouse
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

Fwd: ADONetAppender not logging

2010-07-27 Thread shally chong
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

RE: AdoNetAppender field sizes

2010-05-14 Thread Watson, Gary
whole message. Silly mistake, huh? Many thanks for your help. Gary From: Ross Hinkley [mailto:rosshink...@gmail.com] Sent: 11 May 2010 18:40 To: Log4NET User Subject: Re: AdoNetAppender field sizes I tried to recreate your problem on my local machine using your configuration. I agree with Ron

Re: AdoNetAppender field sizes

2010-05-11 Thread Ross Hinkley
Procedure", but it is still truncating. > > -Original Message- > From: Ron Grabowski [mailto:rongrabow...@yahoo.com] > Sent: 11 May 2010 01:57 > To: Log4NET User > Subject: Re: AdoNetAppender field sizes > > The config looks correct to me. Are you sure you want to u

RE: AdoNetAppender field sizes

2010-05-11 Thread Watson, Gary
riginal Message- From: Ron Grabowski [mailto:rongrabow...@yahoo.com] Sent: 11 May 2010 01:57 To: Log4NET User Subject: Re: AdoNetAppender field sizes The config looks correct to me. Are you sure you want to use the .NET 1.0 version of System.Data? Does this make a difference? - O

Re: AdoNetAppender field sizes

2010-05-10 Thread Ron Grabowski
The config looks correct to me. Are you sure you want to use the .NET 1.0 version of System.Data? Does this make a difference? - Original Message From: "Watson, Gary" To: "log4net-user@logging.apache.org" Sent: Mon, May 10, 2010 8:19:48 AM Subject: AdoNet

AdoNetAppender field sizes

2010-05-10 Thread Watson, Gary
Hello, I am using the AdoNetAppender in log4net to write error messages to a SQL Server 2000 database. Here is the configuration I am using, taken from my app.config file

RE: Experiencing locks while using AdoNetAppender

2009-08-19 Thread Patrick Kalkman
User Onderwerp: Re: Experiencing locks while using AdoNetAppender I think that's how SQLite works. Have you tried writing to a single .db file from multiple threads without using log4net? From: Patrick Kalkman To: log4net-user@logging.apache.org Sent: Tu

Re: Experiencing locks while using AdoNetAppender

2009-08-18 Thread Michael Schall
how SQLite works. Have you tried writing to a single .db file from multiple threads without using log4net? From: Patrick Kalkman To: log4net-user@logging.apache.org Sent: Tuesday, August 18, 2009 8:29:17 AM Subject: Experiencing locks while using AdoNetAppender Hi, I am using the AdoNetAp

Re: Experiencing locks while using AdoNetAppender

2009-08-18 Thread Ron Grabowski
while using AdoNetAppender Experiencing locks while using AdoNetAppender Hi, I am using the AdoNetAppender for logging messages from multiple application. All the applications log into one sqllite database. Sometimes when a lot of information is logged I am experiencing exceptions like: log4net:

RE: Experiencing locks while using AdoNetAppender

2009-08-18 Thread Karim Bourouba
Hi, I have seen similar behaviour when working with Access. I know this wont help, but I found it to be a limitation of file based databases unfortunately :( Subject: Experiencing locks while using AdoNetAppender Date: Tue, 18 Aug 2009 14:29:17 +0200 From: p...@hoogendoorn.nl To

Experiencing locks while using AdoNetAppender

2009-08-18 Thread Patrick Kalkman
Hi, I am using the AdoNetAppender for logging messages from multiple application. All the applications log into one sqllite database. Sometimes when a lot of information is logged I am experiencing exceptions like: log4net:ERROR [AdoNetAppender] Exception while writing to database

Re: Getting AdoNetAppender parameters using Log4Net API

2009-06-19 Thread Ron Grabowski
Surprisingly the parameters collection isn't exposed publicly so you'd have to extend the built-in AdoNetAppender and expose them: public class AdoNetAppender2 : AdoNetAppender { public AdoNetAppenderParameter[] GetParameters() { return m_parameters.Cast

Getting AdoNetAppender parameters using Log4Net API

2009-06-19 Thread Cankut Eskin
Hello, I've defined some extra parameters for AdoNetAppender in log4net config file. Everything works fine. Here is one of my extra parameters defined: I wonder if there is some way in Log4Net API to get information about the param

RE: Using AdoNetAppender

2009-06-17 Thread James Green
rabow...@yahoo.com] Sent: 16 June 2009 23:00 To: Log4NET User Subject: Re: Using AdoNetAppender Its quite difficult to document every possible usage of a library. In addition to these documents: http://logging.apache.org/log4net/release/config-examples.html http://logging.apache.org/log4net/releas

Re: Using AdoNetAppender

2009-06-16 Thread Ron Grabowski
Sent: Tuesday, June 16, 2009 5:58:12 AM Subject: RE: Using AdoNetAppender Cracked it ... AdoNetAppenderParameter logLevel = new AdoNetAppenderParameter(); logLevel.ParameterName = "@log_level"; logLevel.Layout = new Layout2RawLayoutAdapter(new PatternLayo

Re: Using AdoNetAppender

2009-06-16 Thread Ron Grabowski
/log4net.Appender.AdoNetAppenderParameter.Layout.html There's about 8,000 search results on Google for AdoNetAppender. A lot of the documentation is focused on XML examples because that's how the majority of the users configure log4net. I'll glady add your code configurat

RE: Using AdoNetAppender

2009-06-16 Thread James Green
> 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.

Re: Using AdoNetAppender

2009-06-16 Thread Wayne Douglas
bet that was a 'punching hands in the air' geek moment from hell On Tue, Jun 16, 2009 at 10:58 AM, James Green wrote: > Cracked it ... > >            AdoNetAppenderParameter logLevel = new > AdoNetAppenderParameter(); >            logLevel.ParameterName = "@log_level"; >            logLevel.La

RE: Using AdoNetAppender

2009-06-16 Thread James Green
Cracked it ... AdoNetAppenderParameter logLevel = new AdoNetAppenderParameter(); logLevel.ParameterName = "@log_level"; logLevel.Layout = new Layout2RawLayoutAdapter(new PatternLayout("%level")); logLevel.Size = 50; logLevel.DbType = Syst

RE: Using AdoNetAppender

2009-06-16 Thread James Green
Hi Again, 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 anyon

Re: Using AdoNetAppender

2009-06-16 Thread Wayne Douglas
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");   

RE: Using AdoNetAppender

2009-06-16 Thread James Green
r desirable. James. _ From: codingvi...@googlemail.com [mailto:codingvi...@googlemail.com] On Behalf Of Wayne Douglas Sent: 16 June 2009 09:58 To: Log4NET User Subject: Re: Using AdoNetAppender why don't you write a fluent interface for it!?!? I think that for FREE software provided with SO

Re: Using AdoNetAppender

2009-06-16 Thread Wayne Douglas
horrific > piece of code!! Surely this is doable in pure C#? > > I'm amazed that this AdoNetAppender is so poorly documented and has so few > examples. It's starting to put me off log4net! > > James. > > -- > *From:* Ron Grabowski [

RE: Using AdoNetAppender

2009-06-16 Thread James Green
Hi Again, Surely, this is all pointing to a far bigger problem. That is an horrific piece of code!! Surely this is doable in pure C#? I'm amazed that this AdoNetAppender is so poorly documented and has so few examples. It's starting to put me off log4net! James. _

RE: Using AdoNetAppender

2009-06-16 Thread James Green
[mailto:rongrabow...@yahoo.com] Sent: 15 June 2009 22:01 To: Log4NET User Subject: Re: Using AdoNetAppender If you don't specify a ConnectionType AdoNetAppender defaults to using OleDbConnection which has a different connection string format than the more common SqlConnection. Are you sur

Re: Using AdoNetAppender

2009-06-15 Thread Ron Grabowski
: Monday, June 15, 2009 12:04:16 PM Subject: RE: Using AdoNetAppender I think I'm going to have to try the config file method first. I'm wrapping log4net and I don't want to cause every consuming component to require loads of config information in it just for logging purposes.

Re: Using AdoNetAppender

2009-06-15 Thread Ron Grabowski
If you don't specify a ConnectionType AdoNetAppender defaults to using OleDbConnection which has a different connection string format than the more common SqlConnection. Are you sure you want to use OleDbConnection? Why not write a simple ConsoleApplication to test your code and look a

RE: Using AdoNetAppender

2009-06-15 Thread James Green
ender ... *sigh* ... Cheers, James. _ From: codingvi...@googlemail.com [mailto:codingvi...@googlemail.com] On Behalf Of Wayne Douglas Sent: 15 June 2009 16:57 To: Log4NET User Subject: Re: Using AdoNetAppender AppConfig is much simpler - you should start with that then convert to this

Re: Using AdoNetAppender

2009-06-15 Thread Wayne Douglas
nce of an object." > > Thanks, > > James. > > -Original Message- > From: Matt Lund [mailto:ml...@control4.com] > Sent: 15 June 2009 16:28 > To: Log4NET User > Subject: RE: Using AdoNetAppender > > Have you already gotten AdoNetAppender to work from a app.

RE: Using AdoNetAppender

2009-06-15 Thread James Green
I may have to try that. Currently it just fails with an "Oject reference not set to an instance of an object." Thanks, James. -Original Message- From: Matt Lund [mailto:ml...@control4.com] Sent: 15 June 2009 16:28 To: Log4NET User Subject: RE: Using AdoNetAppender Have y

RE: Using AdoNetAppender

2009-06-15 Thread Matt Lund
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? -Original Message--

Using AdoNetAppender

2009-06-15 Thread James Green
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

Re: AdoNetAppender connection timeouts

2008-11-19 Thread Ron Grabowski
Sounds like you want to extend AdoNetAppender, add a Timer with a callback that periodically ensures the Connection is connected every X seconds. From: Hadley Willan <[EMAIL PROTECTED]> To: Log4NET User Sent: Monday, November 17, 2008 12:55:25 AM Subje

RE: AdoNetAppender connection timeouts

2008-11-16 Thread Hadley Willan
Willan [mailto:[EMAIL PROTECTED] Sent: Monday, 17 November 2008 14:16 To: Log4NET User Subject: RE: AdoNetAppender connection timeouts Hi all, I've done some testing by writing a small test app that loops through, throws an ArgumentException, gets caught and logs the exception to log4net.

RE: AdoNetAppender connection timeouts

2008-11-16 Thread Hadley Willan
[49] (6)ms Timing[50] (41554)ms Timing[51] (8)ms Timing[52] (3)ms Timing[53] (3)ms Timing[54] (3)ms Timing[55] (3)ms From: Hadley Willan [mailto:[EMAIL PROTECTED] Sent: Monday, 17 November 2008 09:48 To: Log4NET User Subject: RE: AdoNetAppender connection ti

RE: AdoNetAppender connection timeouts

2008-11-16 Thread Hadley Willan
he timeout? Thanks Hadley From: Ron Grabowski [mailto:[EMAIL PROTECTED] Sent: Monday, 17 November 2008 00:55 To: Log4NET User Subject: Re: AdoNetAppender connection timeouts The AdoNetAppender keeps a reference to an open connection. At some point it e

RE: AdoNetAppender connection timeouts

2008-11-16 Thread Hadley Willan
Regards Hadley From: Ron Grabowski [mailto:[EMAIL PROTECTED] Sent: Monday, 17 November 2008 00:55 To: Log4NET User Subject: Re: AdoNetAppender connection timeouts The AdoNetAppender keeps a reference to an open connection. At some point it ensures th

Re: AdoNetAppender connection timeouts

2008-11-16 Thread Ron Grabowski
The AdoNetAppender keeps a reference to an open connection. At some point it ensures the connection is open: // shortened somewhat...the actual code is longer if (m_reconnectOnError && m_dbConnection.State != ConnectionState.Open) { LogLog.Debug("Attempting to reconnec

AdoNetAppender connection timeouts

2008-11-13 Thread Hadley Willan
Hi peoples, How does the ADO.Net appender handle intermittent connections? I'm assuming that it's holding a connection open and appending? I have set to ensure an immediate call to a stored proc for logging. So basically, do I need to worry about whether or not my connection to the ot

Rolling database table appender (AdoNetAppender)

2008-11-10 Thread asunar
Scenario: ASP.NET 2.0 application using AdoNetAppender to log custom data to a SQL Server 2005 database table. Question: Is there a way to configure log4net so that the size of the database table or number of records in the table don't exceed a certain threshold? For ex. Can we conf

RE: Partial configuration of an AdoNetAppender in the config File

2008-10-23 Thread Bernhard Heinzel
Not longer needed, found a work around. Bernhard From: [EMAIL PROTECTED] To: log4net-user@logging.apache.org Subject: Partial configuration of an AdoNetAppender in the config File Date: Thu, 23 Oct 2008 07:55:04 +0200 Good Morning, Is it possible to partially configure an

Partial configuration of an AdoNetAppender in the config File

2008-10-22 Thread Bernhard Heinzel
Good Morning, Is it possible to partially configure an AdoNetAppender with an config File and later pass him in the source code the connetion string and type? So I try to use the sample config below to to configur with XMLConfiguration and then pass the connetion string and type but I don&#

RE: How to pass password to AdoNetAppender?

2008-10-22 Thread Bernhard Heinzel
Thanks for the many answers. It works with storing the encrypted password in the config file. So Problem solved. Regards Bernhard > Subject: RE: How to pass password to AdoNetAppender? > Date: Wed, 22 Oct 2008 11:17:08 -0400 > From: [EMAIL PROTECTED] > To: log4net-user@loggin

RE: How to pass password to AdoNetAppender?

2008-10-22 Thread Jeegnesh Sheth
as same? From: Bernhard Heinzel [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2008 11:11 AM To: Log4NET User Subject: RE: How to pass password to AdoNetAppender? Thanks Michael. But my Problem is that I have to configure the AdoNetAppender with a config file so I don't

RE: How to pass password to AdoNetAppender?

2008-10-22 Thread Roy Chastain
. -- Roy Chastain -Original Message- From: Bernhard Heinzel [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2008 11:11 To: Log4NET User Subject: RE: How to pass password to AdoNetAppender? Thanks Michael. But my Problem is that I have

RE: How to pass password to AdoNetAppender?

2008-10-22 Thread Michael Richman
Sent: Wednesday, October 22, 2008 8:11 AM To: Log4NET User Subject: RE: How to pass password to AdoNetAppender? Thanks Michael. But my Problem is that I have to configure the AdoNetAppender with a config file so I don't have to recompile if I change the database. ___

RE: How to pass password to AdoNetAppender?

2008-10-22 Thread Bernhard Heinzel
Thanks Michael. But my Problem is that I have to configure the AdoNetAppender with a config file so I don't have to recompile if I change the database. From: [EMAIL PROTECTED] To: log4net-user@logging.apache.org Date: Wed, 22 Oct 2008 07:55:41 -0700 Subject: RE: How to pass passwo

RE: How to pass password to AdoNetAppender?

2008-10-22 Thread Michael Richman
You can set the connection string in code, here is some sample code, you only have to do this once and then you can use the AdoNetAppender multiple times. log4net.Config.XmlConfigurator.Configure(); log4net.Repository.Hierarchy.Hierarchy h = (log4net.Repository.Hierarchy.Hierarchy

RE: How to pass password to AdoNetAppender?

2008-10-22 Thread Bernhard Heinzel
Thanks Georg. Unfortunatly integrated Security is not an option. Seems it is not as trivial as it seems... Any other suggestions? Bernhard From: [EMAIL PROTECTED] To: log4net-user@logging.apache.org Subject: RE: How to pass password to AdoNetAppender? Date: Wed, 22 Oct 2008 14:56:36 +0200

RE: How to pass password to AdoNetAppender?

2008-10-22 Thread Georg Jansen
. oktober 2008 14:08 To: lLog4NET Users Subject: How to pass password to AdoNetAppender? Hi, another Question from the new guy. I want to pass the username and password for the database to the AdoNetAppender. The two ways I found were: * Plaintext in the config file. * 'Plaintext' in the

How to pass password to AdoNetAppender?

2008-10-22 Thread Bernhard Heinzel
Hi, another Question from the new guy. I want to pass the username and password for the database to the AdoNetAppender. The two ways I found were: * Plaintext in the config file. * 'Plaintext' in the sourcecode. Both ways are not optimal, so were I missing something? Is there a smart

RE: AdoNetAppender Connection String

2008-10-20 Thread Gourlay, Colin
: ... lots of stuff in here ... -Original Message- From: Dag Christensen [mailto:[EMAIL PROTECTED] Sent: 16 October 2008 14:58 To: Log4NET User Subject: RE: AdoNetAppender Connection String Importance: Low Shouldn't be a TextWriterAppender there. Can you post your configuration

RE: AdoNetAppender Connection String

2008-10-16 Thread Dag Christensen
Shouldn't be a TextWriterAppender there. Can you post your configuration file? Not answering your question but as a workaround you could loop through the list of appenders returned and find the first (or named) instance of AdoNetAppender you're looking for. Regards, Dag From: Gour

AdoNetAppender Connection String

2008-10-16 Thread Gourlay, Colin
Hierarchy log4netHierarchy = LogManager.GetRepository() as Hierarchy; // magic number used because there should only ever be one appender defined in this application // the appender variable evaluates to null! AdoNetAppender appender

closed connection errors with AdoNetAppender & MySQL Connector/NET

2008-09-15 Thread Chris Jerdonek
Hi, Has anyone ever experienced frequent "closed connection" errors in log4net while using the AdoNetAppender with MySQL Connector/NET in an ASP.NET application (stack traces below)? I know this isn't strictly a log4net question, but I'm wondering if anything about log4net m

Re: ASP.NET, AdoNetAppender and deferred property execution

2008-08-22 Thread Jerry Shea
D]> > To: log4net-user@logging.apache.org > Sent: Monday, August 11, 2008 12:30:43 AM > Subject: Re: ASP.NET, AdoNetAppender and deferred property execution > > Hi Everyone, > > Apologies for sending multiple messages about this, but I guess my initial > question was buried a

Re: ASP.NET, AdoNetAppender and deferred property execution

2008-08-11 Thread Ron Grabowski
008 12:30:43 AM Subject: Re: ASP.NET, AdoNetAppender and deferred property execution Hi Everyone, Apologies for sending multiple messages about this, but I guess my initial question was buried at the bottom of email#1. Does anyone have a idea as to how I can force properties to be resolved at log

Re: ASP.NET, AdoNetAppender and deferred property execution

2008-08-10 Thread Jerry Shea
Hi Everyone, Apologies for sending multiple messages about this, but I guess my initial question was buried at the bottom of email#1. Does anyone have a idea as to how I can force properties to be resolved at log time rather than flush time? Thx, Jerry 2008/8/7 Jerry Shea <[EMAIL PROTECTED]>

Re: ASP.NET, AdoNetAppender and deferred property execution

2008-08-07 Thread Jerry Shea
Yes I have confirmed that this is the case - when the AdoNetAppender's buffer flushes then and only then are the properties evaluated.

ASP.NET, AdoNetAppender and deferred property execution

2008-08-07 Thread Jerry Shea
= "-"; if (HttpContext.Current != null && HttpContext.Current.Session != null && HttpContext.Current.Session["client"] != null) retval = (string)HttpContext.Current.Session["client"]; return retval; } } My log4net is con

FW: AdoNetAppender: can not read custom properties from LoggingEvent using configuration file

2008-07-23 Thread Andrei Leca
I used a extended log using example: http://svn.apache.org/viewvc/logging/log4net/trunk/extensions/net/1.0/log4ne t.Ext.EventID/cs/src/EventIDLogImpl.cs?view=co . I have properties InstanceId that is setted in extended log: LoggingEvent loggingEvent = new

Re: logging additional message-specific data with AdoNetAppender

2008-05-12 Thread sarika_luckymca
Hi, Guys I am in soup. I am trying to use log to database using adoNetAppender. I am working on visual studio 2005 with vb.net. nothing is showing in my database. Also I m not getting any error messages. I am not sure if it is some version problem. my appender is

Re: logging additional message-specific data with AdoNetAppender

2008-05-10 Thread Ron Grabowski
t;[EMAIL PROTECTED]> To: Log4NET User Sent: Saturday, May 10, 2008 10:51:12 AM Subject: RE: logging additional message-specific data with AdoNetAppender Thanks for your input, Peter and William. What I'm leaning towards is making a simple wrapper of LogManager and ILog so that when I call

RE: logging additional message-specific data with AdoNetAppender

2008-05-10 Thread Chris Jerdonek
tain to. --Chris -- Chris Jerdonek Software Developer P: (415) 357-3618 Ext. 1357 Granicus, Inc. -Original Message- From: William R. Daniels, Jr. [mailto:[EMAIL PROTECTED] Sent: Friday, May 09, 2008 3:00 PM To: Log4NET User Subject: RE: logging additional message-specific data with Ado

RE: logging additional message-specific data with AdoNetAppender

2008-05-09 Thread William R. Daniels, Jr.
> -Original Message- > From: Chris Jerdonek [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 08, 2008 7:49 PM > To: log4net-user@logging.apache.org > Subject: logging additional message-specific data with AdoNetAppender > > Hi, we've been using log4net for a few

Re: logging additional message-specific data with AdoNetAppender

2008-05-09 Thread Peter Drier
for about the same. I have a design question. > > What would be the "correct" way to do the following? > > We'd like to log to a database using the AdoNetAppender. From our code, > when we call things like log.Debug, log.Info, log.Warn, etc. we'd like to be >

  1   2   3   >