log4j.xml에 java.sql logger 추가 결과

2011-07-04 11:03:31,281 DEBUG [java.sql.Connection] {conn-100000} Connection
2011-07-04 11:03:31,281 DEBUG [java.sql.Connection] {conn-100001} Connection
2011-07-04 11:03:31,281 DEBUG [java.sql.Connection] {conn-100000} Preparing Statement:        INSERT INTO COMTNWEBLOG      ( REQUST_ID       , URL       , RQESTER_ID       , RQESTER_IP       , OCCRRNC_DE )    VALUES ( ?       , ?       , ?       , ?       , TO_CHAR(sysdate, 'YYYYMMDD'))    
2011-07-04 11:03:31,281 DEBUG [java.sql.Connection] {conn-100001} Preparing Statement:        INSERT INTO COMTNWEBLOG      ( REQUST_ID       , URL       , RQESTER_ID       , RQESTER_IP       , OCCRRNC_DE )    VALUES ( ?       , ?       , ?       , ?       , TO_CHAR(sysdate, 'YYYYMMDD'))    
2011-07-04 11:03:31,296 DEBUG [java.sql.PreparedStatement] {pstm-100003} Executing Statement:        INSERT INTO COMTNWEBLOG      ( REQUST_ID       , URL       , RQESTER_ID       , RQESTER_IP       , OCCRRNC_DE )    VALUES ( ?       , ?       , ?       , ?       , TO_CHAR(sysdate, 'YYYYMMDD'))    
2011-07-04 11:03:31,296 DEBUG [java.sql.PreparedStatement] {pstm-100003} Parameters: [WEBLOG_0000000000209, /uat/uia/egovLoginUsr.do, , 127.0.0.1]
2011-07-04 11:03:31,296 DEBUG [java.sql.PreparedStatement] {pstm-100003} Types: [java.lang.String, java.lang.String, java.lang.String, java.lang.String]
2011-07-04 11:03:31,296 DEBUG [java.sql.PreparedStatement] {pstm-100002} Executing Statement:        INSERT INTO COMTNWEBLOG      ( REQUST_ID       , URL       , RQESTER_ID       , RQESTER_IP       , OCCRRNC_DE )    VALUES ( ?       , ?       , ?       , ?       , TO_CHAR(sysdate, 'YYYYMMDD'))    
2011-07-04 11:03:31,296 DEBUG [java.sql.PreparedStatement] {pstm-100002} Parameters: [WEBLOG_0000000000210, /uat/uia/egovLoginUsr.do, , 127.0.0.1]
2011-07-04 11:03:31,296 DEBUG [java.sql.PreparedStatement] {pstm-100002} Types: [java.lang.String, java.lang.String, java.lang.String, java.lang.String]
2011-07-04 11:04:43,328 DEBUG [java.sql.Connection] {conn-100004} Connection
2011-07-04 11:04:43,343 DEBUG [java.sql.Connection] {conn-100004} Preparing Statement:                           SELECT emplyr_id AS id         , emplyr_nm AS name         , password AS password         , ihidnum AS ihidNum         , email_adres AS email         , 'USR' AS userSe         , orgnzt_id AS orgnztId         , uniq_id AS uniqId      FROM COMTNEMPLYRINFO     WHERE emplyr_id = ?       AND password = ?       AND emplyr_sttus_code = 'P'        
2011-07-04 11:04:43,343 DEBUG [java.sql.PreparedStatement] {pstm-100005} Executing Statement:                           SELECT emplyr_id AS id         , emplyr_nm AS name         , password AS password         , ihidnum AS ihidNum         , email_adres AS email         , 'USR' AS userSe         , orgnzt_id AS orgnztId         , uniq_id AS uniqId      FROM COMTNEMPLYRINFO     WHERE emplyr_id = ?       AND password = ?       AND emplyr_sttus_code = 'P'        
2011-07-04 11:04:43,343 DEBUG [java.sql.PreparedStatement] {pstm-100005} Parameters: [TEST1, a4ayc/80/OGda4BO/1o/V0etpOqiLx1JwB5S3beHW0s=]
2011-07-04 11:04:43,343 DEBUG [java.sql.PreparedStatement] {pstm-100005} Types: [java.lang.String, java.lang.String]
2011-07-04 11:04:43,390 DEBUG [java.sql.ResultSet] {rset-100006} ResultSet
2011-07-04 11:04:43,390 DEBUG [java.sql.ResultSet] {rset-100006} Header: [id, name, ihidNum, email, password, userSe, orgnztId, uniqId]
2011-07-04 11:04:43,390 DEBUG [java.sql.ResultSet] {rset-100006} Result: [TEST1, 테스트1, 1111111111118, a3@aa.aa, a4ayc/80/OGda4BO/1o/V0etpOqiLx1JwB5S3beHW0s=, USR, ORGNZT_0000000000000, USRCNFRM_00000000000]
2011-07-04 11:04:43,390 DEBUG [java.sql.Connection] {conn-100007} Connection
2011-07-04 11:04:43,390 DEBUG [java.sql.Connection] {conn-100007} Preparing Statement:              SELECT A.USER_ID,                    A.USER_NM,                    A.USER_SE,                    B.IP_INFO,                    B.DPLCT_PERM_AT,                    NVL(B.LMTT_AT,'N') AS LMTT_AT,                    B.LAST_UPDUSR_ID,                    B.LAST_UPDUSR_PNTTM,                    DECODE(B.EMPLYR_ID, NULL, 'N', 'Y') AS REG_YN               FROM COMVNUSERMASTER A LEFT OUTER JOIN COMTNLOGINPOLICY B                 ON A.USER_ID = B.EMPLYR_ID                 WHERE 1 = 1                AND A.USER_ID = ?    
2011-07-04 11:04:43,390 DEBUG [java.sql.PreparedStatement] {pstm-100008} Executing Statement:              SELECT A.USER_ID,                    A.USER_NM,                    A.USER_SE,                    B.IP_INFO,                    B.DPLCT_PERM_AT,                    NVL(B.LMTT_AT,'N') AS LMTT_AT,                    B.LAST_UPDUSR_ID,                    B.LAST_UPDUSR_PNTTM,                    DECODE(B.EMPLYR_ID, NULL, 'N', 'Y') AS REG_YN               FROM COMVNUSERMASTER A LEFT OUTER JOIN COMTNLOGINPOLICY B                 ON A.USER_ID = B.EMPLYR_ID                 WHERE 1 = 1                AND A.USER_ID = ?    
2011-07-04 11:04:43,390 DEBUG [java.sql.PreparedStatement] {pstm-100008} Parameters: [TEST1]
2011-07-04 11:04:43,390 DEBUG [java.sql.PreparedStatement] {pstm-100008} Types: [java.lang.String]
2011-07-04 11:04:43,406 DEBUG [java.sql.ResultSet] {rset-100009} ResultSet
2011-07-04 11:04:43,406 DEBUG [java.sql.ResultSet] {rset-100009} Header: [USER_ID, USER_NM, USER_SE, IP_INFO, DPLCT_PERM_AT, LMTT_AT, LAST_UPDUSR_ID, LAST_UPDUSR_PNTTM, REG_YN]
2011-07-04 11:04:43,406 DEBUG [java.sql.ResultSet] {rset-100009} Result: [TEST1, 테스트1, USR, null, null, N, null, null, N]
2011-07-04 11:04:43,421 DEBUG [java.sql.Connection] {conn-100010} Connection
2011-07-04 11:04:43,421 DEBUG [java.sql.Connection] {conn-100010} Preparing Statement:        INSERT INTO COMTNWEBLOG      ( REQUST_ID       , URL       , RQESTER_ID       , RQESTER_IP       , OCCRRNC_DE )    VALUES ( ?       , ?       , ?       , ?       , TO_CHAR(sysdate, 'YYYYMMDD'))    
2011-07-04 11:04:43,421 DEBUG [java.sql.PreparedStatement] {pstm-100011} Executing Statement:        INSERT INTO COMTNWEBLOG      ( REQUST_ID       , URL       , RQESTER_ID       , RQESTER_IP       , OCCRRNC_DE )    VALUES ( ?       , ?       , ?       , ?       , TO_CHAR(sysdate, 'YYYYMMDD'))    
2011-07-04 11:04:43,421 DEBUG [java.sql.PreparedStatement] {pstm-100011} Parameters: [WEBLOG_0000000000211, /uat/uia/actionLogin.do, , 127.0.0.1]
2011-07-04 11:04:43,421 DEBUG [java.sql.PreparedStatement] {pstm-100011} Types: [java.lang.String, java.lang.String, java.lang.String, java.lang.String]
2011-07-04 11:04:43,578 DEBUG [java.sql.Connection] {conn-100012} Connection
2011-07-04 11:04:43,578 DEBUG [java.sql.Connection] {conn-100012} Preparing Statement:        INSERT INTO COMTNWEBLOG      ( REQUST_ID       , URL       , RQESTER_ID       , RQESTER_IP       , OCCRRNC_DE )    VALUES ( ?       , ?       , ?       , ?       , TO_CHAR(sysdate, 'YYYYMMDD'))    
2011-07-04 11:04:43,578 DEBUG [java.sql.PreparedStatement] {pstm-100013} Executing Statement:        INSERT INTO COMTNWEBLOG      ( REQUST_ID       , URL       , RQESTER_ID       , RQESTER_IP       , OCCRRNC_DE )    VALUES ( ?       , ?       , ?       , ?       , TO_CHAR(sysdate, 'YYYYMMDD'))    
2011-07-04 11:04:43,578 DEBUG [java.sql.PreparedStatement] {pstm-100013} Parameters: [WEBLOG_0000000000212, /uat/uia/egovLoginUsr.do, , 127.0.0.1]
2011-07-04 11:04:43,578 DEBUG [java.sql.PreparedStatement] {pstm-100013} Types: [java.lang.String, java.lang.String, java.lang.String, java.lang.String]