728x90
반응형
pom.xml
1
2
3
4
5
|
<dependency>
<groupId>org.bgee.log4jdbc-log4j2</groupId>
<artifactId>log4jdbc-log4j2-jdbc4</artifactId>
<version>1.16</version>
</dependency>
|
cs |
C:\TEST\eGovFrameDev-3.8.0-64bit\workspace\TEST\src\main\resources\egovframework\egovProps\globals.properties
Globals.maria.DriverClassName=net.sf.log4jdbc.sql.jdbcapi.DriverSpy
Globals.maria.Url=jdbc:log4jdbc:mysql://10.123.123.123:3306/testdb?serverTimezone=UTC&useUnicode=true
Globals.maria.UserName =test
Globals.maria.Password =test
C:\TEST\eGovFrameDev-3.8.0-64bit\workspace\TEST\src\main\resources\log4jdbc.log4j2.properties
log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator
log4j2.xml (20210730일자)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
|
<?xml version="1.0" encoding="UTF-8"?>
<Configuration>
<Appenders>
<Console name="console" target="SYSTEM_OUT">
<!-- <PatternLayout pattern="[log4j]%d %5p [%c] %m%n" /> -->
<PatternLayout pattern="%d %m%n %-5p %l" />
</Console>
</Appenders>
<Loggers>
<Logger name="java.sql" level="DEBUG" additivity="false">
<AppenderRef ref="console" />
</Logger>
<Logger name="com.ibatis" level="DEBUG" additivity="false">
<AppenderRef ref="console"/>
</Logger>
<Logger name="java.sql.Connection" level="DEBUG" additivity="false">
<AppenderRef ref="console" />
</Logger>
<Logger name="java.sql.PreparedStatement" level="OFF" additivity="false">
<AppenderRef ref="console" />
</Logger>
<Logger name="java.sql.Statement" level="OFF" additivity="false">
<AppenderRef ref="console" />
</Logger>
<Logger name="java.sql.ResultSet" level="OFF" additivity="false">
<AppenderRef ref="console" />
</Logger>
<!-- 베이스 패키지 구조로 잡아줘야 함. -->
<Logger name="org.springframework" level="DEBUG" additivity="false">
<AppenderRef ref="console" />
</Logger>
<Logger name="egovframework" level="DEBUG" additivity="false">
<AppenderRef ref="console" />
</Logger>
<Logger name="test" level="DEBUG" additivity="false">
<AppenderRef ref="console" />
</Logger>
<logger name="org.apache.commons.digester.Digester" level ="OFF" additivity="false">
<AppenderRef ref="Console"/>
</logger>
<!-- log SQL with timing information, post execution -->
<!-- SQL 연결 상태 출력 -->
<Logger name="jdbc.connection" level="OFF" additivity="false">
<AppenderRef ref="console" />
</Logger>
<!-- SQL만 출력 -->
<Logger name="jdbc.sqlonly" level="OFF" additivity="false">
<AppenderRef ref="console" />
</Logger>
<!-- SQL과 경과 시간을 함께 출력 -->
<Logger name="jdbc.sqltiming" level="INFO" additivity="false">
<AppenderRef ref="console" />
<AppenderRef ref="file" />
</Logger>
<!-- SQL결과 상세하기 -->
<Logger name="jdbc.audit" level="OFF" additivity="false">
<AppenderRef ref="console" />
</Logger>
<!-- SQL결과 상세하게 -->
<Logger name="jdbc.resultset" level="OFF" additivity="false">
<AppenderRef ref="console" />
</Logger>
<!-- 결과 TABLE 형태로 출력 -->
<Logger name="jdbc.resultsettable" level="OFF" additivity="false">
<AppenderRef ref="console" />
</Logger>
<!-- ===================================== -->
<!-- Possible Log Levels: -->
<!-- ===================================== -->
<!-- FATAL, ERROR, WARN, INFO, DEBUG, TRACE-->
<Root level="DEBUG">
<AppenderRef ref="console" />
<AppenderRef ref="file" />
</Root>
</Loggers>
</Configuration>
|
cs |
728x90
반응형