logback 存数据库_Logback日志写入数据库

依赖

ch.qos.logback

logback-classic

1.1.7

ch.qos.logback

logback-core

1.1.7

ch.qos.logback

logback-access

1.1.7

org.slf4j

slf4j-api

1.7.21

mysql

mysql-connector-java

5.1.38

c3p0

c3p0

0.9.1.2

logback.xml

com.mysql.jdbc.Driver

jdbc:mysql://192.168.99.122:3306/cloud_meta_platform

root

root

建表

执行logback-classicjar包中的建表语句

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,

<