<properties>
  <slf4j.version>1.7.6</slf4j.version>
  <!-- current log4j 2 release -->
  <log4j.version>2.0-rc1</log4j.version> 
</properties>

<dependencies>
  <dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-api</artifactId>
    <version>${slf4j.version}</version>
  </dependency>
  <!-- Binding for Log4J -->
  <dependency>
    <groupId>org.apache.logging.log4j</groupId>
    <artifactId>log4j-slf4j-impl</artifactId>
    <version>${log4j.version}</version>
  </dependency>
  <!-- Log4j API and Core implementation required for binding -->
  <dependency>
    <groupId>org.apache.logging.log4j</groupId>
    <artifactId>log4j-api</artifactId>
    <version>${log4j.version}</version>
  </dependency>
  <dependency>
    <groupId>org.apache.logging.log4j</groupId>
    <artifactId>log4j-core</artifactId>
    <version>${log4j.version}</version>
  </dependency>

 <dependency>



    <groupId>org.bgee.log4jdbc-log4j2</groupId>



    <artifactId>log4jdbc-log4j2-jdbc4.1</artifactId>



    <version>1.16</version>



 </dependency> 






</dependencies> 





Maven



















log4j.xml


<Configuration>
 <Appenders>

  <Console name="console_root" target="SYSTEM_OUT">
   <PatternLayout pattern="%d %5p %m%n" />
  </Console>

  <Console name="console_com" target="SYSTEM_OUT">
   <PatternLayout pattern="%d %5p [%c] %m%n" />
  </Console>

  <RollingFile name="file" fileName="/logs/all.log" filePattern="/logs/%i.%d{yyyy-MM-dd}.log">

   <PatternLayout pattern="%d{HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
   <Policies>
    <SizeBasedTriggeringPolicy size="10MB" />
   </Policies>
   <DefaultRolloverStrategy max="1000" fileIndex="min" />
  </RollingFile>
 </Appenders>
 <Loggers>
  <Logger name="java.sql" level="INFO" additivity="false">
   <AppenderRef ref="console_com" />
  </Logger>
  <Logger name="jdbc.sqltiming" level="INFO" additivity="false">
   <AppenderRef ref="console_com" />
  </Logger>

  <Logger name="egovframework" level="INFO" additivity="false">
   <AppenderRef ref="console" />
  </Logger>

  <Logger name="org.springframework" level="INFO" additivity="false">
   <AppenderRef ref="console" />
  </Logger>

  <Root level="INFO">
   <AppenderRef ref="console" />
  </Root>

 </Loggers>

</Configuration>









spring.datasource.driverClassName=net.sf.log4jdbc.sql.jdbcapi.DriverSpy







spring.datasource.url=jdbc:log4jdbc:mariadb://localhost:3306/test