log4j2 & Maven

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
 <appenders>
  <console name="console" target="SYSTEM_OUT">
   <patternlayout pattern="%d %5p [%c] %m%n" />
  </Console>
 </Appenders>
   
 <loggers>

  <root level="info">
   <appenderref ref="console" />
  </Root>
  
   <logger name="jdbc.sqlonly" additivity ="false">            
       <level value="error" />  
       <appender-ref ref="console" />    
   </logger>  
   <logger name="jdbc.resultsettable" additivity ="false">          
       <level value="error" />    
       <appender-ref ref="console" />
   </logger>          
 
 </Loggers>
</Configuration>

pom.xml


<dependency>
<groupid>org.bgee.log4jdbc-log4j2</groupid>
<artifactid>log4jdbc-log4j2-jdbc4</artifactid>
<version>1.16</version>
</dependency>

<dependency>
<groupid>org.lazyluke</groupid>
<artifactid>log4jdbc-remix</artifactid>
<version>0.2.7</version>
</dependency>








dataSource


<pre><code>




<bean id="dataSource" class="...">  
    <property name="driverClass" value="${datasource.driverClassName}">  
    <property name="jdbcUrl" value="${datasource.url}">  
    <property name="user" value="${datasource.username}">  
    <property name="password" value="${datasource.password}">  
    ...  
</property></property></property></property></bean>  
 
  

<!-- DataBase -->  
<bean id="dataSourceSpied" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">  
 <property name="driverClassName" value="com.mysql.jdbc.Driver">  
 <property name="url" value="jdbc:mysql://localhost:3306/hnsnmn_db">  
 <property name="username" value="hnsnmn">  
 <property name="password" value="0000">  
</property></property></property></property></bean>  
<bean id="dataSource" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">  
 <constructor-arg ref="dataSourceSpied">  
 <property name="logFormatter">  
  <bean class="net.sf.log4jdbc.tools.Log4JdbcCustomFormatter">  
   <property name="loggingType" value="MULTI_LINE">  
   <property name="margin" value="19">  
   <property name="sqlPrefix" value="SQL:::">  
  </property></property></property></bean>  
 </property>  
</constructor-arg></bean>  





</code></pre>