logback

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <timestamp key="byDate" datePattern="yyyyMMdd" />
    
<appender name="rolling" class="ch.qos.logback.core.rolling.RollingFileAppender">
    <Encoding>UTF-8</Encoding>   
    <file>logs/run-${byDate}.log</file>
    <rollingPolicy class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy">   
        <fileNamePattern>logs/run-%d{yyyy-MM-dd}.%i.log.zip</fileNamePattern>
        <maxHistory>7</maxHistory>
        <minIndex>1</minIndex>
        <maxIndex>3</maxIndex>
    </rollingPolicy>
    
    <triggeringPolicy class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy">   
      <maxFileSize>10MB</maxFileSize>   
    </triggeringPolicy>
    
    <encoder>
        <pattern>%date{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{60}.%method\(%file:%line\) - %msg%n</pattern>   
    </encoder>   
</appender>  

    <!-- log output to console -->
    <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
     <Encoding>UTF-8</Encoding>   
        <encoder>
            <pattern>%date{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{60}.%method\(%file:%line\) - %msg%n</pattern>
        </encoder>
    </appender>
    
    <!-- log output to db -->
    <appender name="DB" class="ch.qos.logback.classic.db.DBAppender">
        <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource">
            <dataSource class="org.sqlite.SQLiteDataSource">
                <driverClass>org.sqlite.JDBC</driverClass>
                <url>jdbc:sqlite:D:/workspace/personalFinance/PersonalFiance/db/finance.db</url>
                <user></user>
                <password></password>
            </dataSource>
        </connectionSource>
    </appender>
    
    <!-- show parameters for hibernate sql 专为 Hibernate 定制 -->  
    <logger name="org.hibernate.type.descriptor.sql.BasicBinder"  level="TRACE" />  
    <logger name="org.hibernate.type.descriptor.sql.BasicExtractor"  level="DEBUG" />  
    <logger name="org.hibernate.SQL" level="DEBUG" />  
    <logger name="org.hibernate.engine.QueryParameters" level="DEBUG" />  
    <logger name="org.hibernate.engine.query.HQLQueryPlan" level="DEBUG" />  
    <!-- TRACE, DEBUG, INFO, WARN, ERROR, ALL , OFF -->
    <root level="INFO">  
        <appender-ref ref="STDOUT" />  
        <!--<appender-ref ref="DB" />-->
        <appender-ref ref="rolling" />  
    </root>  
</configuration>