{"id":2436,"date":"2024-11-01T09:03:07","date_gmt":"2024-11-01T00:03:07","guid":{"rendered":"http:\/\/blog.moramcnt.com\/?p=2436"},"modified":"2024-11-01T09:03:07","modified_gmt":"2024-11-01T00:03:07","slug":"log4jdbc2%eb%a5%bc-%ec%82%ac%ec%9a%a9%ed%95%98%ec%97%ac-%eb%a1%9c%ea%b7%b8%ec%84%a4%ec%a0%95","status":"publish","type":"post","link":"http:\/\/blog.moramcnt.com\/?p=2436","title":{"rendered":"Log4jdbc2\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub85c\uadf8\uc124\uc815"},"content":{"rendered":"

I. \ubaa9\ud45c<\/strong><\/p>\n

\uae30\uc874\uc5d0 SQL\ubb38\uc7a5\ub4f1\uc744 \ub85c\uadf8\ub85c \ucd9c\ub825\ud558\uc5ec \ubcf4\uba74 \uac1c\ud589\ub3c4 \uc5c6\uc774 \ud55c\uc904\uc5d0 \ub098\uc624\ub294\ub4f1\uc758 \ubcf4\uae30\uc5d0 \ubd88\ud3b8\ud55c \uc810\uc774 \ub9ce\uc544, \uc774\ub97c \uac1c\uc120\ud558\uace0\uc790 Log4jdbc2\ub97c \uc124\uc815\ud558\uae30\ub85c \ud558\uc600\ub2e4.<\/p>\n

II. \uac1c\ubc1c\ubc0f \uc5f0\uad6c\ub0b4\uc6a9<\/strong><\/p>\n

1. pom.xml \uc5d0 \uc544\ub798\uc640 \uac19\uc774 \ucd94\uac00<\/p>\n\n\n\n
<dependency><\/p>\n

<groupId>org.bgee.log4jdbc-log4j2<\/groupId><\/p>\n

<artifactId>log4jdbc-log4j2-jdbc4.1<\/artifactId><\/p>\n

<version>1.16<\/version><\/p>\n

<\/dependency><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

2. Globals.properties \ud30c\uc77c \uc218\uc815<\/p>\n\n\n\n
Globals.DriverClassName=oracle.jdbc.driver.OracleDriver<\/p>\n

Globals.Url=jdbc:oracle:thin:@localhost:1521:TESTDB<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\uc704\uc640 \uac19\uc774 \ubd80\ubd84\uc744 \ucc3e\uc544 \uc544\ub798\ucc98\ub7fc \uc218\uc815<\/p>\n\n\n\n
Globals.DriverClassName=net.sf.log4jdbc.sql.jdbcapi.DriverSpy<\/p>\n

Globals.Url=jdbc:log4jdbc<\/b>:oracle:thin:@localhost:1521\/TESTDB<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

 <\/p>\n

3. log4jdbc.log4j2.properties \uc0dd\uc131<\/p>\n\n\n\n
log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator<\/p>\n

log4jdbc.dump.sql.maxlinelength=0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

4. \ub85c\uadf8\ud30c\uc77c \uc124\uc815 : log4j2.xml<\/p>\n\n\n\n
<logger name=”jdbc.resultset” level=”OFF” additivity=”false”><AppenderRef ref=”console”\/><\/logger><\/p>\n

<logger name=”jdbc.resultsettable” level=”${logLevel}” additivity=”false”><AppenderRef ref=”console”\/><AppenderRef ref=”appRollingFile”\/><\/logger><\/p>\n

<logger name=”jdbc.sqltiming” level=”OFF” additivity=”false”><AppenderRef ref=”console”\/><\/logger><\/p>\n

<logger name=”jdbc.sqlonly” level=”${logLevel}” additivity=”false”><AppenderRef ref=”console”\/><AppenderRef ref=”appRollingFile” \/><\/logger><\/p>\n

<logger name=”jdbc.audit” level=”OFF” additivity=”false”><AppenderRef ref=”appRollingFile” \/><\/logger><\/p>\n

<logger name=”org.mybatis” level=”OFF” additivity=”false”><AppenderRef ref=”appRollingFile” \/><\/logger><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

III. \uacb0\ub860<\/p>\n

\uc544\ub798\uc640 \uac19\uc774 Mybatis\uc5d0 \uc788\ub294 SQL\ubb38\uc7a5\uc774 \uc798 \ucd9c\ub825\ub418\uc5c8\ub2e4.<\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

I. \ubaa9\ud45c \uae30\uc874\uc5d0 SQL\ubb38\uc7a5\ub4f1\uc744 \ub85c\uadf8\ub85c \ucd9c\ub825\ud558\uc5ec \ubcf4\uba74 \uac1c\ud589\ub3c4 \uc5c6\uc774 \ud55c\uc904\uc5d0 \ub098\uc624\ub294\ub4f1\uc758 \ubcf4\uae30\uc5d0 \ubd88\ud3b8\ud55c \uc810\uc774 \ub9ce\uc544, \uc774\ub97c \uac1c\uc120\ud558\uace0\uc790 Log4jdbc2\ub97c \uc124\uc815\ud558\uae30\ub85c \ud558\uc600\ub2e4. II. \uac1c\ubc1c\ubc0f \uc5f0\uad6c\ub0b4\uc6a9 1. pom.xml \uc5d0 \uc544\ub798\uc640 \uac19\uc774 \ucd94\uac00 <dependency> <groupId>org.bgee.log4jdbc-log4j2<\/groupId> <artifactId>log4jdbc-log4j2-jdbc4.1<\/artifactId> <version>1.16<\/version> <\/dependency>   2. Globals.properties \ud30c\uc77c \uc218\uc815 Globals.DriverClassName=oracle.jdbc.driver.OracleDriver Globals.Url=jdbc:oracle:thin:@localhost:1521:TESTDB \uc704\uc640 \uac19\uc774 \ubd80\ubd84\uc744 \ucc3e\uc544 \uc544\ub798\ucc98\ub7fc \uc218\uc815 Globals.DriverClassName=net.sf.log4jdbc.sql.jdbcapi.DriverSpy Globals.Url=jdbc:log4jdbc:oracle:thin:@localhost:1521\/TESTDB     3. log4jdbc.log4j2.properties \uc0dd\uc131 log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[6,7],"tags":[313,315,314],"class_list":["post-2436","post","type-post","status-publish","format-standard","hentry","category-java","category-7","tag-log4jdbc2","tag-315","tag-314"],"_links":{"self":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts\/2436","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2436"}],"version-history":[{"count":2,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts\/2436\/revisions"}],"predecessor-version":[{"id":2439,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts\/2436\/revisions\/2439"}],"wp:attachment":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2436"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}