Uploaded image for project: 'logback'
  1. logback
  2. LOGBACK-148

DatabaseAppender logs timestamp to logging_event table rather than datetime

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • None
    • logback-core
    • 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.

      Attachments

        Activity

          People

            logback-dev Logback dev list
            dawsonm Dawson Mossman
            Votes:
            6 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: