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

[Paul Krause]

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.

Thanks,
Paul

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

Hi,everyone,
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">
          <driverClass>com.mysql.jdbc.Driver</driverClass>
          <url>jdbc:MySQL://127.0.0.1:3306/EventDataBase<http://127.0.0.1:3306/EventDataBase></url>
          <user>root</user>
          <password>root</password>
      </connectionSource>
  </appender>

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.
[https://mail.bjut.edu.cn/?q=compose.output&action=mail.attach&aid=20715&mid=919&part=1.2&method=show]
_______________________________________________
logback-user mailing list
logback-user at qos.ch<mailto:logback-user at qos.ch>
http://mailman.qos.ch/mailman/listinfo/logback-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.qos.ch/pipermail/logback-user/attachments/20160314/5a73dccb/attachment.html>