log4j2 쿼리로그만 찍히게 하고 싶습니다.

Question

사용 버전log4j-api-2.17.2log4j-core-2.17.2log4j-jul-2.17.2log4jslf4j-impl-2.17.2log4jdbc-log4j2-jdbc4.1-1.16 쿼리 로그가 아래와 같이 찍히고 있습니다.2022-05-13 15:13:19,390 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: 2. Connection opened. {executed in 30ms} 2022-05-13 15:13:19,390 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: 2. Connection.new Connection returned 2022-05-13 15:13:19,390 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: 2. Connection.getAutoCommit() returned true 2022-05-13 15:13:19,390 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: 2. PreparedStatement.new PreparedStatement returned 2022-05-13 15:13:19,391 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: 2. Connection.prepareStatement(select count(*) from user) returned net.sf.log4jdbc.sql.jdbcapi.PreparedStatementSpy&#64;241a1a2 2022-05-13 15:13:19,397 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: 2. select count(*) from user {executed in 6 ms} 2022-05-13 15:13:19,398 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: 2. PreparedStatement.execute() returned true 2022-05-13 15:13:19,398 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: 2. ResultSet.new ResultSet returned 2022-05-13 15:13:19,398 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: 2. PreparedStatement.getResultSet() returned net.sf.log4jdbc.sql.jdbcapi.ResultSetSpy&#64;3d7502ed 2022-05-13 15:13:19,398 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: 2. ResultSet.getMetaData() returned org.mariadb.jdbc.MariaDbResultSetMetaData&#64;7aedb778 2022-05-13 15:13:19,398 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: 2. ResultSet.getType() returned 1003 2022-05-13 15:13:19,398 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: 2. ResultSet.isClosed() returned false 2022-05-13 15:13:19,399 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: 2. ResultSet.next() returned true 2022-05-13 15:13:19,399 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: 2. ResultSet.getInt(count(*)) returned 1 2022-05-13 15:13:19,399 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: 2. ResultSet.isClosed() returned false 2022-05-13 15:13:19,399 INFO [http-nio-8080-exec-1] log4jdbc.log4j2: |---------| |count(*) | |---------| |1 | |---------| 보통 log4j2.xml 에 설정할때logger name을 jdbc.sqlonly 이런식으로 특정해서 설정하잖아요.근데 저는 class가 전부 log4jdbc.log4j2로 찍혀서 쿼리만 찍히게 하고 싶은데 쿼리만 특정할 수가 없습니다.이럴때는 어떻게 분리할수가 있을까요?

하이열 · Answer

현재 로깅 수준이 INFO 인데용다른 클래스의 로깅수준을 DEBUG 수준으로 낮추세요

KeepCool · Answer

자문자답.log4jdbc.log4j2.properties 파일에log4jdbc.spylogdelegator.name&#61;net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator를 설정하지 않아서 class가 분리가 안됐었네요.저같은 분들 있으시면 참고하시길...

log4j2 쿼리로그만 찍히게 하고 싶습니다.

2개의 답변

Q&A 목록