log4j sample

1. log4j.xml

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j='http://jakarta.apache.org/log4j/'>

   

<!-- Fileappender -- >

    <appender name="report_APPENDER" class="org.apache.log4j.FileAppender">  
        <param name="Threshold" value="INFO" />
        <param name="file" value="D:/report.log" />  
        <layout class="org.apache.log4j.PatternLayout">  
            <param name="ConversionPattern" value="%-5p: %c - %m%n" />  
        </layout>  
    </appender>  
      
    <logger name="REPORT_LOGGER" additivity="false">  
        <level value="INFO" />  
        <appender-ref ref="report_APPENDER" />  
    </logger>  

   

<!-- ConsoleAppender-- >

    <appender name="consoleAppender" class="org.apache.log4j.ConsoleAppender">
        <param name="Threshold" value="INFO" />
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%d%-5p  [%c{1}] %m %n" />
       </layout>

    </appender>

<!-- JDBCAppender-- >

<appender name="jdbcAppender" class="org.apache.log4j.jdbc.JDBCAppender">
        <param name="URL" value="jdbc:oracle:thin:@192.168.8.120:1521:G3" />
        <param name="Driver" value="oracle.jdbc.driver.OracleDriver" />
        <param name="User" value="ACHADMIN" />
        <param name="Password" value="ACHADMIN" />
          <param name="commit" value="true" />
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern"
              value="INSERT INTO LOGGING_SAMPLES_TEST (log_date,log_level, location, message) VALUES ('%d{yyyy-MM-dd HH:mm:ss}', '%p', '%C;%L;%t', '%m' )"  
            />
        </layout>
    </appender>

    <logger name="jdbcLogger">
        <level value="debug"/>
        <appender-ref ref="jdbcAppender"/>
    </logger>
    
    <root>  
        <priority value="debug" />  
        <appender-ref ref="consoleAppender" />  
         <appender-ref ref="report_APPENDER" />  
         <appender-ref ref="jdbcAppender" />  
    </root>  
 

</log4j:configuration>

2.Test Class :

package com.spring.log4j;

import org.apache.log4j.Logger;
import org.apache.log4j.xml.DOMConfigurator;

public class JDBCLogging {

    static Logger logger=Logger.getLogger(JDBCLogging.class);
             
    public static void main(String[] args) {
        DOMConfigurator.configure("log4j.xml");
        System.out.println("xiayanhua");
        logger.debug("This is debug log");
        logger.info("This is info log");
        logger.warn("This is warn log");
        logger.error("this is error log");
        logger.fatal("this is fatal log");
        System.out.println("2222222xiayanhua");
    }
}

3.Database table creation

create table LOGGING_SAMPLES_TEST(
 log_date date,
 log_level varchar(100),
 location varchar(100),
 message varchar(100)

)