[logback-user] Some questions about DBAppender of the logback

Paul Krause pkrause at investsoftech.com
Mon Mar 14 11:10:41 UTC 2016

I've never understood why DBAppender logs the time using a long instead of a java.sql.Timestamp. It's quite annoying and I never found a way to change it.

What I wound up doing instead to write a SQL function to convert milliseconds to a DATETIME (you can find it on stack overflow) and incorporating that into a view.


On Mar 14, 2016, at 02:35, Yun He <canalyun at gmail.com<mailto:canalyun at gmail.com>> wrote:

Following is my logback.xml about implement DBAppender just to storage the log message to mysql database.
 <appender name="DB" class="ch.qos.logback.classic.db.DBAppender">
      <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource">

then: The following is the result ,the log message was storage in the mysql database,but the "timestmp" filed in the table named logging_event ,the timestmp's pattern is not as{HH:mm:ss.SSS} just as the consoleAppender,can I transform it's pattern to {HH:mm:ss:SSS} ? Could you please give me some help?I have tried add <encoder> <pattern>%d{HH:mm:ss.SSS} </pattern></encoder> as the ConsoleAppender's logback.xml,but I failed.
logback-user mailing list
logback-user at qos.ch<mailto:logback-user at qos.ch>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.qos.ch/pipermail/logback-user/attachments/20160314/5a73dccb/attachment.html>

More information about the logback-user mailing list