log4jdbc 사용하여 로그찍기

1. pom.xml

repositories 에 추가

<repository> <id>egovframe</id> <url>http://www.egovframe.go.kr/maven/</url> <releases> <enabled>true</enabled> </releases> <snapshots> <enabled>false</enabled> </snapshots> </repository>

dependencies 에 추가

<!-- Logging --> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>${org.slf4j-version}</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>jcl-over-slf4j</artifactId> <version>${org.slf4j-version}</version> <scope>runtime</scope> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-log4j12</artifactId> <version>${org.slf4j-version}</version> <scope>runtime</scope> </dependency> <dependency> <groupId>net.sf</groupId> <artifactId>log4jdbc3</artifactId> <version>1.1</version> </dependency>

2. applicationContext.xml 수정

repositories 에 추가

<!-- ======================================================================== DataSource ======================================================================== --> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="net.sf.log4jdbc.DriverSpy"/> <property name="url" value="jdbc:log4jdbc:oracle:thin:@192.168.1.4:1521:DEV"/> <property name="username" value="asdf"/> <property name="password" value="1234qwer"/> </bean>

3. log4j.xml 추가 (log4j.properties 위치에)

<?xml version="1.0" encoding="ISO-8859-1"?> <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd"> <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/" debug="false"> <appender name="console" class="org.apache.log4j.ConsoleAppender"> <layout class="org.apache.log4j.PatternLayout"> <param name="ConversionPattern" value="%d{ABSOLUTE} %5p %50.50c:%4L - %m%n" /> </layout> </appender> <appender name="file" class="org.apache.log4j.RollingFileAppender"> <param name="file" value="c:/log/enm/cjkpi.log" /> <param name="Append" value="true" /> <param name="MaxFileSize" value="10240KB" /> <param name="MaxBackupIndex" value="100" /> <layout class="org.apache.log4j.PatternLayout"> <param name="ConversionPattern" value="%d{ABSOLUTE} %5p %50.50c:%4L - %m%n" /> </layout> </appender> <!-- log SQL with timing information, post execution --> <logger name="jdbc.sqlonly" additivity="false"> <level value="OFF" /> <appender-ref ref="console" /> <appender-ref ref="file" /> </logger> <logger name="jdbc.sqltiming" additivity="false"> <level value="INFO" /> <appender-ref ref="console" /> <appender-ref ref="file" /> </logger> <logger name="jdbc.audit" additivity="false"> <level value="ERROR" /> <appender-ref ref="console" /> <appender-ref ref="file" /> </logger> <logger name="jdbc.resultset" additivity="false"> <level value="ERROR" /> <appender-ref ref="console" /> <appender-ref ref="file" /> </logger> <logger name="org.springframework" additivity="false"> <level value="DEBUG" /> <appender-ref ref="console" /> <appender-ref ref="file" /> </logger> <logger name="org.springframework.jdbc" additivity="false"> <level value="DEBUG" /> <appender-ref ref="console" /> <appender-ref ref="file" /> </logger> <root> <level value="DEBUG" /> <appender-ref ref="console" /> <appender-ref ref="file" /> </root> </log4j:configuration>

web.xml 수정

<context-param> <param-name>log4jConfigLocation</param-name> <param-value>classpath:spring/log4j.xml</param-value> <-- 이부분 수정 </context-param>