Friday, May 18, 2012
 
The best way to analyze your logs! Minimize
Log4Net Mail Archive
Login
Register
 Log4Net Mail archive   

The Log4Net mailing list is a great source of information about using log4Net, in this forum we collect all the messages in the log4net user list and some selected threads from the developer list.

Forums > Log4Net > Log4Net Mail archive
Subject: SQL Appender and date time format
Prev Next
You are not authorized to post a reply.

Author Messages
nbplopes
Posts:2
03/03/2008 10:56 AM  
Hi,

I'm trying to use the SQL Appender with the RC version.

I configured access to my log table as advised and I have no SQL Connection errors. I also have more then 300 entries in my log table created in the last hour.

The problem is that no entries are displayed in the Summary section.

I did a trace and found the following script being executed (just an excerpt):

.............
Insert #Period Values (1, 'Last Hour', 'Shows events for the past hour', '20080303 03:51:49.662', '20080303 04:51:49.662' )
Insert #Period Values (2, 'Previous Hour', 'Shows events for the previous hour', '20080303 02:51:49.662', '20080303 03:51:49.662' )
Insert #Period Values (3, '22 Hours before', 'Shows events for the past 24 hours', '20080302 04:51:49.662', '20080303 02:51:49.662' )
Insert #Period Values (4, 'Yesterday', 'Shows events for the previous 24 hours', '20080301 04:51:49.662', '20080302 04:51:49.662' )
Insert #Period Values (5, 'Week before', 'Shows events for the the week before yesterday', '20080223 04:51:49.662', '20080301 04:51:49.662' )
Insert #Period Values (6, 'Month before', 'Shows events for the the month before the week before', '20080123 04:51:49.662', '20080223 04:51:49.662' )
Insert #Period Values (7, 'Older', 'Shows older events', '19090123 04:51:49.662', '20080123 04:51:49.662' )

...........

It seams that the date time format used are wrong (not using the 24 hour format). This since the entries in the log table were created at between 14:00 and 16:00 and not not between 02:00 and 04:00 if you know what I mean.

Is there any settings I need to tweek or is this a bug in the RC.

Thanks in advance for any help.

Nuno
nbplopes
Posts:2
03/03/2008 11:17 AM  
May I also add when I put the mouse over the "Last Hour" in the summary section the tooltip shows "... 05:11:53 ..." when we are now 17:11:53

I have not changed date formats in the web.config:





So I was expecting 17:11:53 rather then 05:11:53.

Nuno
herrbanan
Posts:1
05/29/2008 8:07 AM  
I have the same problem as you guys.
You are not authorized to post a reply.
Forums > Log4Net > Log4Net Mail archive > SQL Appender and date time format


ActiveForums 3.7

 

 

 

 

 

 

 

 

Log4Net Dashboard

Log analysis and monitoring made easy!

Log4Net Dashboard is a log viewer that can read log statements from a variety of logging output targets.

You can download a free developer version.

  

Check it out!

On the demonstration site you can try it  with live data.demo.l4ndash.com - Try Log4Net Dashboard with live data

The mail archive is a copy of all the mail sent to the mail address: log4net-user@logging.apache.org, organized as a forum.

If you would like to participate in the mail list, send a mail to log4net-user-subscribe@logging.apache.org.

More information about the mailing list is available on: http://logging.apache.org/log4net/support.html

 

A complete topic list is available and can be viewed here (warning, it takes some time to load)

 
Copyright 2005-2008 by FaktNet AS Terms Of Use Privacy Statement