<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body dir="auto">
<div>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. </div>
<div id="AppleMailSignature"><br>
</div>
<div id="AppleMailSignature">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. <br>
<br>
Thanks,
<div>Paul</div>
</div>
<div><br>
On Mar 14, 2016, at 02:35, Yun He <<a href="mailto:canalyun@gmail.com">canalyun@gmail.com</a>> wrote:<br>
<br>
</div>
<blockquote type="cite">
<div>
<div dir="ltr"><span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">Hi,everyone,</span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">
<span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">Following is my logback.xml about implement DBAppender just to storage the log message to mysql database.</span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">
<span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"> <appender name="DB" class="ch.qos.logback.classic.db.DBAppender"></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">
<span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"> <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource"></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">
<span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"> <driverClass>com.mysql.jdbc.Driver</driverClass></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">
<span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"> <url>jdbc:MySQL://<a href="http://127.0.0.1:3306/EventDataBase">127.0.0.1:3306/EventDataBase</a></url></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">
<span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"> <user>root</user></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">
<span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"> <password>root</password></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">
<span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"> </connectionSource></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">
<span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"> </appender></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">
<br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">
<span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">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</span><span class="" style="line-height:22.4px;color:rgb(0,0,0);font-family:Simsun;font-size:14px">{HH:mm:ss.SSS}</span><span class="" style="line-height:22.4px;color:rgb(0,0,0);font-family:Simsun;font-size:14px"> </span><span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"></pattern></encoder>
as the ConsoleAppender's logback.xml,but I failed.</span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">
<img src="https://mail.bjut.edu.cn/?q=compose.output&action=mail.attach&aid=20715&mid=919&part=1.2&method=show" style="color: rgb(0, 0, 0); font-family: Simsun; font-size: 14px; line-height: 21px;"></div>
</div>
</blockquote>
<blockquote type="cite">
<div><span>_______________________________________________</span><br>
<span>logback-user mailing list</span><br>
<span><a href="mailto:logback-user@qos.ch">logback-user@qos.ch</a></span><br>
<span><a href="http://mailman.qos.ch/mailman/listinfo/logback-user">http://mailman.qos.ch/mailman/listinfo/logback-user</a></span></div>
</blockquote>
</body>
</html>