#################################################################
# P6Spy Options File                                            #
# See documentation for detailed instructions                   #
# http://p6spy.readthedocs.org/en/latest/configandusage.html   #
#################################################################

#################################################################
# MODULES                                                       #
#                                                               #
# Module list adapts the modular functionality of P6Spy.       #
# Only modules listed are active.                              #
# (default is com.p6spy.engine.spy.P6SpyFactory)               #
# Please note that the core module (P6SpyFactory) can't be     #
# deactivated.                                                  #
# Unlike the other properties, activation of the changes on    #
# this one requires reload.                                     #
#################################################################
modulelist=com.p6spy.engine.spy.P6SpyFactory,com.p6spy.engine.logging.P6LogFactory
# Use console appender instead of file
appender=com.p6spy.engine.spy.appender.Slf4JLogger

################################################################
# CORE (P6SPY) PROPERTIES                                     #
################################################################

# A comma separated list of JDBC drivers to load and register.
# (default is empty)
#
# Note: This is normally only needed when using P6Spy in an 
# application server environment with a connection pool, where
# the connection pool may only try to load the original driver.
# The P6Spy driver must be loaded before the original driver
# and the original driver must be loaded before the pool.
# 
# Applies to the core module.
driverlist=org.postgresql.Driver

# for flushing per statement
# (default is false)
autoflush=true

# sets the date format using Java's SimpleDateFormat routine. 
# In case property is not set, milliseconds since 1970 (unix time) is used (default is empty)
dateformat=yyyy-MM-dd HH:mm:ss

# prints a stack trace for every statement logged
stacktrace=false
# if stacktrace=true, specifies the stack trace to print
stacktraceclass=

# determines if property file should be reloaded
# Please note: reload means forgetting all the previously set
# settings (even those set during runtime - via JMX)
# and starting with the clean table 
# (default is false)
reloadproperties=false

# determines how many seconds to wait before reloading the properties file.
# (default is 60)
reloadpropertiesinterval=60

# if set to true, execution time will be measured in nanoseconds.
# (default is false)
useNanoTime=false

# Name of logfile to use, note Windows users should make sure to use forward slashes in their pathname.
# (used for file logger only)
# (default is spy.log)
# logfile=../log/spy.log (주석 처리 - 콘솔 출력 사용)

# append to the p6spy log file. if this is set to false the
# log file is truncated every time. (file logger only)
# (default is true)
append=true

# class to use for formatting log messages.
# (default is: com.p6spy.engine.spy.appender.SingleLineFormat)
logMessageFormat=com.p6spy.engine.spy.appender.MultiLineFormat

# format that is used for logging of the date/time/... (has to be compatible with java.text.SimpleDateFormat)
# (default is dd-MMM-yy)
databaseDialectDateFormat=yyyy-MM-dd

# whether to expose options via JMX or not
# (default is true)
jmx=false

# if exposing options via jmx (see option above), what should be the prefix used?
# jmx names consist of: jmxPrefix + method/property name
# (default is p6spy)
jmxPrefix=p6spy

# if set to true, the execution time will be measured in nanoseconds.
# (default is false)
#useNanoTime=false

# Name of logfile to use, note Windows users should make sure to use forward slashes in their pathname.
# (used for file logger only)
# (default is spy.log)
#logfile=spy.log

# append to  the p6spy log file.  if this is set to false the
# log file is truncated every time.  (file logger only)
# (default is true)
#append=true

#################################################################
# DataSource replacement                                        #
#                                                               #
# Replace the real DataSource class in your application server #
# configuration with the name com.p6spy.engine.spy.P6DataSource#
# (that provides also connection pooling and xa support).      #
# then add the JNDI name and class name of the real            #
# DataSource here                                               #
#                                                               #
# Values set in this item cannot be reloaded using the         #
# reloadproperties variable. Once it is loaded, it remains     #
# in memory until the application is restarted.                #
#                                                               #
#################################################################
#realdatasource=/RealMySqlDS
#realdatasourceclass=com.mysql.jdbc.jdbc2.optional.MysqlDataSource

#################################################################
# DataSource properties                                         #
#                                                               #
# If you are using the DataSource support to intercept calls   #
# to a DataSource that does not use a connection pool,         #
# you must also specify the DataSource properties in the       #
# following format: p6spy.datasource.settername=value          #
#                                                               #
#################################################################
#p6spy.datasource.driver=com.mysql.jdbc.Driver
#p6spy.datasource.url=jdbc:mysql://localhost:3306/homerweb
#p6spy.datasource.user=user
#p6spy.datasource.password=password

#################################################################
# EXECUTION THRESHOLD PROPERTIES                               #
#                                                               #
# This feature applies to the standard logging of P6Spy.       #
# While the standard logging logs out every statement          #
# regardless of its execution time, this feature puts a time   #
# condition on that logging. Only statements that have taken   #
# longer than the time specified (in milliseconds) will be     #
# logged. This way it is possible to see only statements that  #
# have exceeded some high water mark.                          #
# This time is reloadable.                                     #
#                                                               #
# executionthreshold=integer time (milliseconds)               #
#                                                               #
#################################################################
executionthreshold=0

#################################################################
# P6LOG SPECIFIC PROPERTIES                                    #
#################################################################
# Filter 활성화 (exclude를 사용하려면 필수)
filter=true

# exclude: SQL patterns to exclude from logging (comma-separated)
# 주의: 모든 테이블명은 소문자로 작성 (SQL이 소문자로 변환되어 매칭됨)
# 고빈도 쿼리 제외: 웹로그, 메뉴, 공통코드
exclude=web_log,iccom.menu,com_cd,com_group_cd

################################################################
# EXECUTION THRESHOLD PROPERTIES                              #
################################################################

# This feature applies to the standard logging of P6Spy.       
# While the standard logging logs out every statement          
# regardless of its execution time, this feature puts a time   
# condition on that logging. Only statements that have taken   
# longer than the time specified (in milliseconds) will be     
# logged. This way it is possible to see only statements that  
# have exceeded some high water mark.                          
# This time is reloadable.                                     
#                                                               
# executionthreshold=integer time (milliseconds)               
#                                                               
executionthreshold=

################################################################
# P6OUTAGE SPECIFIC PROPERTIES                                #
################################################################
# Outage Detection
#
# This feature detects long-running statements that may be indicative of
# a database outage problem. If this feature is turned on, it will log any
# statement that surpasses the configurable time boundary during its execution.
# When this feature is enabled, no other statements are logged except the long
# running statements. The interval property is the boundary time set in seconds.
# For example, if this is set to 2, then any statement requiring at least 2 
# seconds will be logged. Note that the same statement will continue to be logged
# for as long as it executes. So if the interval is set to 2, and the query takes
# 7 seconds, it will be logged 3 times (at the 2, 4, and 6 second intervals).
#
# outagedetection=true|false
# outagedetectioninterval=integer time (seconds)
#
outagedetection=false
outagedetectioninterval=

################################################################
# P6LOG SPECIFIC PROPERTIES                                   #
################################################################
# no properties currently available 