Details
-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
None
-
None
Description
I've spoke with Ceki about this and he acknowledged it as a bug / improvement. The issue is that other appenders which use the patternlayout (email, file) log the datetime, but the database appender logs a timestamp to the logging_event table. The timestamp is not consistent and less useful since a conversion process needs to be done to figure out the actual datetime that the event was logged to the database.
Solution: Switch the "timestmp" column in the logging_event table from timestamp to datetime and update the databaseappender to work with the new column type.
Acceptance Test: Log an entry to the database using the databaseappender. The log entry in the database should show the datetime, not a timestamp.