Spring boot中的log4j2:JDBC appender不将日志消息写入DB的列

Question

• 我在Gradle中排除了“logback-classic”和“spring-boot-starter-logging”依赖项。
• 我添加了'log4j-api'、'log4j-core'和'spring-boot-starter-log4j2'依赖项。

我当前的构建。Gradle如下所示：

    buildscript {
        repositories {
            mavenCentral()
        }
        dependencies {
            classpath 'org.springframework.boot:spring-boot-gradle-plugin:1.5.7.BUILD-SNAPSHOT'
        }
    }
    
    plugins {
        id "org.springframework.boot" version "1.5.7.RELEASE"
    }
    
    apply plugin: 'java'
    apply plugin: 'idea'
    apply plugin: 'io.spring.dependency-management'
    apply plugin: 'org.springframework.boot'
    apply plugin: 'war'
    
    war {
        baseName = 'CprUI'
        version =  '1.0.0-SNAPSHOT'
    }
    
    repositories {
        mavenLocal()
        mavenCentral()
        jcenter()
        maven { url "http://repo.spring.io/libs-snapshot" }
    }
    
    sourceCompatibility = 1.8
    targetCompatibility = 1.8
    
    dependencies {
        compile("org.springframework.boot:spring-boot-starter-web")
        compile("org.springframework.boot:spring-boot-starter-actuator")
        compile("org.springframework.boot:spring-boot-starter-security")
        compile("org.springframework.ldap:spring-ldap-core")
        compile("org.springframework.security:spring-security-ldap")
        compile("org.springframework:spring-tx")
        compile("com.unboundid:unboundid-ldapsdk")
        compile("org.springframework.boot:spring-boot-starter-log4j2")
        compile group: 'org.springframework.boot', name: 'spring-boot-starter-thymeleaf', version: '1.5.7.RELEASE'
        compile group: 'org.springframework.boot', name: 'spring-boot-starter-data-jpa', version: '1.5.7.RELEASE'
        compile group: 'org.springframework.boot', name: 'spring-boot-starter-parent', version: '1.5.7.RELEASE', ext: 'pom'
        compile("com.oracle:ojdbc6:11.2.0.3")
        compile("org.apache.any23:apache-any23-encoding:2.0")
        compile("org.apache.commons:commons-csv:1.5")
        compile group: 'org.thymeleaf.extras', name: 'thymeleaf-extras-springsecurity4', version: '3.0.2.RELEASE'
        compile("org.springframework.boot:spring-boot-starter-web")
        providedRuntime("org.springframework.boot:spring-boot-starter-tomcat")
        testCompile("org.springframework.boot:spring-boot-starter-test")
        testCompile("org.springframework.security:spring-security-test")
        compile group: 'org.apache.logging.log4j', name: 'log4j-api', version: '2.7'
        compile group: 'org.apache.logging.log4j', name: 'log4j-core', version: '2.7'
        compile group: 'org.springframework.boot', name: 'spring-boot-starter-log4j2', version: '2.3.1.RELEASE'
        compile group: 'org.apache.commons', name: 'commons-dbcp2', version: '2.7.0'
        compile group: 'mysql', name: 'mysql-connector-java', version: '8.0.20'
        compile group: 'org.apache.maven.plugins', name: 'maven-compiler-plugin', version: '3.8.1'
    }
    
    configurations.all {
        exclude module: 'spring-boot-starter-logging'
        exclude module: 'logback-classic'
    }

• 接下来，我创建了log4j2.properties文件，并将其放在/resources目录下。该文件如下所示:

    appenders = console, db
    appender.console.type = Console
    appender.console.name = STDOUT
    appender.console.layout.type = PatternLayout
    appender.console.layout.pattern = [%-5level] %d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %c{1} - %msg%n
    
    appender.db.type = JDBC
    appender.db.name = JDBC
    appender.db.layout.type = PatternLayout
    appender.db.layout.pattern = [%-5level] %d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %c{1} - %msg%n
    appender.db.connectionSource.type= DriverManager
    appender.db.connectionSource.connectionString = my_connection_string
    appender.db.connectionSource.username = my_username
    appender.db.connectionSource.password = my_password
    appender.db.connectionSource.driverClassName = oracle.jdbc.driver.OracleDriver
    appender.db.tableName = GDPR_LOG
    
    appender.db.columnConfigs[0].type = Column
    appender.db.columnConfigs[0].name = OPERATION_DESCRIPTION
    appender.db.columnConfigs[0].pattern =%msg
    appender.db.columnConfigs[0].isUnicode =false
    
    logger.db.name = eu.unicredit.mtr.cpr.logging
    logger.db.level = debug
    logger.db.additivity = false
    logger.db.appenderRef.db.ref = JDBC
    
    rootLogger.level = debug
    rootLogger.appenderRefs = stdout
    rootLogger.appenderRef.stdout.ref = STDOUT

null

    # LOGGING
    logging.level.org.hibernate.SQLQuery=debug
    logging.level.org.hibernate.type.descriptor.sql=trace
    logging.level.org.springframework.web=${LOG_LEVEL_SPRING:info}
    logging.level.org.hibernate=${LOG_LEVEL_SPRING:debug}
    logging.level.web=${LOG_LEVEL_SPRING:info}
    logging.config=classpath:log4j2.properties
    
    spring.datasource.url=my_datasource
    spring.datasource.username=my_user
    spring.datasource.password=my_password
    spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
    
    server.context-path=/CprUI

    @Entity
    @Table(name = "GDPR_LOG")
    public class Log {
    
        @Id
        @SequenceGenerator(name="DWH_ID_SEQ_GEN", sequenceName="DIM_CPR_COUNTERPARTY_ID", allocationSize=10)
        @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="DWH_ID_SEQ_GEN")
        @Column(name = "ITEM_ID")
        private Long id;
        @Column(name = "CREATION_TIME")
        private String creation_time;
        @Column(name = "LOG_ID")
        private String log_id;
        @Column(name = "USER_ID")
        private String user_id;
        @Column(name = "WORKSTATION_ID")
        private String workstation_id;
        @Column(name = "SESSION_ID")
        private String session_id;
        @Column(name = "OPERATION_DESCRIPTION")
        private String operation_description;
        @Column(name = "APPLICATION_CODE")
        private String app_code;
        @Column(name = "LEGAL_ENTITY")
        private String entity;
    
    //getters, setters

    @Transactional
        public void saveLogForGetAll(Log log) {
            log.setCreation_time(formatDateTime);
            log.setLog_id("SecLog");
            log.setUser_id(checkUser());
            log.setWorkstation_id(checkIP());
            log.setSession_id(session_string);
            log.setApp_code("QRP");
            log.setEntity("AG");
            logsRepository.save(log);
        }

提前谢了。

干杯！

Answer 1

你混合了两个不同的概念。要么让log4j将日志记录事件写入数据库，要么实现自己的与log4j无关的记录器。

第1部分显示您将使用log4j。好吧。但是您不需要使用相同表的JPA实体。类Log和方法SaveLogForgetAll(Log Log)并不需要。Log4j将日志记录事件保存到数据库中。

log4j的思想是，代码不应该知道日志事件将如何持久化（在文件系统中、数据库中、通过消息队列可到达的远程设备中，等等）