log4j에 쿼리와 파라메터 출력 세팅은 어떻게 해야되나요?
- 작성자 :
- 조*남
- 작성일 :
- 2014-10-28 12:04:03
- 조회수 :
- 1,585
- 구분 :
- 개발환경
- 진행상태 :
- 완료
Q
안녕하세요
전자정부 3.1 버전을 다운받아 개발환경을 만들어 진행중입니다.
개발하면서 콘솔에 쿼리와 파라메터값이 찍히게 하고싶어서 그러는데요
어떻게 세팅을 해야될까요??
아래는 제가 세팅한 내역입니다.
--context-datasource.xml
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<property name="url" value="jdbc:oracle:thin:@192.168.0.115:1521:PTNGII"/>
<property name="username" value="PT_NGII"/>
<property name="password" value="PT_NGII"/>
</bean>
--log4j2.xml
<?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>
<Logger name="egovframework" level="DEBUG" additivity="false">
<AppenderRef ref="console" />
</Logger>
<!-- log SQL with timing information, post execution -->
<logger name="jdbc.sqltiming" level="INFO" additivity="false">
<appender-ref ref="console" />
</logger>
<logger name="org.springframework" level="INFO" additivity="false">
<appender-ref ref="console" />
</logger>
<Root level="ERROR">
<AppenderRef ref="console" />
</Root>
</Loggers>
</Configuration>
어떻게 세팅하면 쿼리와 파라메터값들이 콘솔에 출력될수있을까요??
답변 부탁드립니다.
전자정부 3.1 버전을 다운받아 개발환경을 만들어 진행중입니다.
개발하면서 콘솔에 쿼리와 파라메터값이 찍히게 하고싶어서 그러는데요
어떻게 세팅을 해야될까요??
아래는 제가 세팅한 내역입니다.
--context-datasource.xml
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<property name="url" value="jdbc:oracle:thin:@192.168.0.115:1521:PTNGII"/>
<property name="username" value="PT_NGII"/>
<property name="password" value="PT_NGII"/>
</bean>
--log4j2.xml
<?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>
<Logger name="egovframework" level="DEBUG" additivity="false">
<AppenderRef ref="console" />
</Logger>
<!-- log SQL with timing information, post execution -->
<logger name="jdbc.sqltiming" level="INFO" additivity="false">
<appender-ref ref="console" />
</logger>
<logger name="org.springframework" level="INFO" additivity="false">
<appender-ref ref="console" />
</logger>
<Root level="ERROR">
<AppenderRef ref="console" />
</Root>
</Loggers>
</Configuration>
어떻게 세팅하면 쿼리와 파라메터값들이 콘솔에 출력될수있을까요??
답변 부탁드립니다.
A
안녕하세요. 조영남님
아래 처럼 설정을 변경해 보시기 바랍니다.
--context-datasource.xml
<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.0.115:1521:PTNGII"/>
<property name="username" value="PT_NGII"/>
<property name="password" value="PT_NGII"/>
</bean>
-- pom.xml
<dependency>
<groupId>com.googlecode.log4jdbc</groupId>
<artifactId>log4jdbc</artifactId>
<version>1.2</version>
</dependency>
--log4j2.xml
<?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>
<Logger name="egovframework" level="DEBUG" additivity="false">
<AppenderRef ref="console" />
</Logger>
<!-- log SQL with timing information, post execution -->
<Logger name="jdbc.sqltiming" level="INFO" additivity="false">
<AppenderRef ref="console" />
</Logger>
<Logger name="org.springframework" level="INFO" additivity="false">
<AppenderRef ref="console" />
</Logger>
<Root level="ERROR">
<AppenderRef ref="console" />
</Root>
</Loggers>
</Configuration>
고맙습니다.
아래 처럼 설정을 변경해 보시기 바랍니다.
--context-datasource.xml
<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.0.115:1521:PTNGII"/>
<property name="username" value="PT_NGII"/>
<property name="password" value="PT_NGII"/>
</bean>
-- pom.xml
<dependency>
<groupId>com.googlecode.log4jdbc</groupId>
<artifactId>log4jdbc</artifactId>
<version>1.2</version>
</dependency>
--log4j2.xml
<?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>
<Logger name="egovframework" level="DEBUG" additivity="false">
<AppenderRef ref="console" />
</Logger>
<!-- log SQL with timing information, post execution -->
<Logger name="jdbc.sqltiming" level="INFO" additivity="false">
<AppenderRef ref="console" />
</Logger>
<Logger name="org.springframework" level="INFO" additivity="false">
<AppenderRef ref="console" />
</Logger>
<Root level="ERROR">
<AppenderRef ref="console" />
</Root>
</Loggers>
</Configuration>
고맙습니다.