[logback-dev] [JIRA] Created: (LBCORE-177) DatabaseAppender logs timestamp to logging_event table rather than datetime

[Dawson Mossman (JIRA)]

DatabaseAppender logs timestamp to logging_event table rather than datetime
---------------------------------------------------------------------------

                 Key: LBCORE-177
                 URL: http://jira.qos.ch/browse/LBCORE-177
             Project: logback-core
          Issue Type: Bug
          Components: Appender
    Affects Versions: 0.9.26
            Reporter: Dawson Mossman
            Assignee: Logback dev list


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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.qos.ch/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira