logback入库配置

淩亂°似流年 2022-09-25 14:26 163阅读 0赞

使用logback将日志入库

可添加配置在logback.xml中

<appender name="DB" class="ch.qos.logback.classic.db.DBAppender">  
            <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource">  
               <dataSource  
                class="com.alibaba.druid.pool.DruidDataSource">  
              <driverClass>com.mysql.jdbc.Driver</driverClass>  
              <url>jdbc:mysql://ip:3306/数据库名</url>  
              <user>root</user>  
              <password>root</password>  
              </dataSource>  
            </connectionSource>  
          </appender>

需要建表

BEGIN;  
    DROP TABLE IF EXISTS logging_event_property;  
    DROP TABLE IF EXISTS logging_event_exception;  
    DROP TABLE IF EXISTS logging_event;  
    COMMIT;  
      
    BEGIN;  
    CREATE TABLE logging_event   
      (  
        timestmp         BIGINT NOT NULL,  
        formatted_message  TEXT NOT NULL,  
        logger_name       VARCHAR(254) NOT NULL,  
        level_string      VARCHAR(254) NOT NULL,  
        thread_name       VARCHAR(254),  
        reference_flag    SMALLINT,  
        arg0              VARCHAR(254),  
        arg1              VARCHAR(254),  
        arg2              VARCHAR(254),  
        arg3              VARCHAR(254),  
        caller_filename   VARCHAR(254) NOT NULL,  
        caller_class      VARCHAR(254) NOT NULL,  
        caller_method     VARCHAR(254) NOT NULL,  
        caller_line       CHAR(4) NOT NULL,  
        event_id          BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY  
      );  
    COMMIT;  
    BEGIN;  
    CREATE TABLE logging_event_property  
      (  
        event_id          BIGINT NOT NULL,  
        mapped_key        VARCHAR(254) NOT NULL,  
        mapped_value      TEXT,  
        PRIMARY KEY(event_id, mapped_key),  
        FOREIGN KEY (event_id) REFERENCES logging_event(event_id)  
      );  
    COMMIT;  
    BEGIN;  
    CREATE TABLE logging_event_exception  
      (  
        event_id         BIGINT NOT NULL,  
        i                SMALLINT NOT NULL,  
        trace_line       VARCHAR(254) NOT NULL,  
        PRIMARY KEY(event_id, i),  
        FOREIGN KEY (event_id) REFERENCES logging_event(event_id)  
      );  
    COMMIT;

然后在logback中使用该appender

本文参考自：http://blog.csdn.net/csh602583095/article/details/40581601