################################################################################
#
#    Licensed to the Apache Software Foundation (ASF) under one or more
#    contributor license agreements.  See the NOTICE file distributed with
#    this work for additional information regarding copyright ownership.
#    The ASF licenses this file to You under the Apache License, Version 2.0
#    (the "License"); you may not use this file except in compliance with
#    the License.  You may obtain a copy of the License at
#
#       http://www.apache.org/licenses/LICENSE-2.0
#
#    Unless required by applicable law or agreed to in writing, software
#    distributed under the License is distributed on an "AS IS" BASIS,
#    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
#    See the License for the specific language governing permissions and
#    limitations under the License.
#
################################################################################

# Root logger
#log4j.rootLogger=INFO, out, osgi:VmLogAppender
log4j.rootLogger=WARN, out, osgi:VmLogAppender

# CONSOLE appender not used by default
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} | %-5.5p | %-16.16t | %-32.32c{1} | %-32.32C %4L | %m%n

# File appender
log4j.appender.out=org.apache.log4j.FileAppender
log4j.appender.out.layout=org.apache.log4j.PatternLayout
log4j.appender.out.layout.ConversionPattern=%d{ABSOLUTE} | %-5.5p | %-32.32c{1} | %m%n
log4j.appender.out.file=${karaf.base}/data/log/karaf.log
log4j.appender.out.append=true
### Directs messages to a virtual repository database table (FUR-1567) ###

# Define the DB appender - filter SQL queries and parameter binding messages
log4j.appender.DB=edu.utah.further.core.util.log.FilteredJdbcAppender
log4j.appender.DB.URL=jdbc:oracle:thin:@dev-db.further.utah.edu:1521:FURTHER
log4j.appender.DB.driver=oracle.jdbc.OracleDriver
log4j.appender.DB.user=virtual_repository
log4j.appender.DB.password=v1rtu4lr3p0
log4j.appender.DB.sql=INSERT INTO LOGS VALUES(to_date('%d{dd-MMM-yyyy HH:mm:ss}', 'dd-mm-yyyy hh24:mi:ss'),'%C','%m')
log4j.appender.DB.layout=edu.utah.further.core.util.log.EscapedPatternLayout
# Filter expressions based on regular expressions delimited by '@'
log4j.appender.DB.includePatterns=update.*@select.*@insert.*@update.*@delete.*@binding.*

#--------------------
# Logging levels
#--------------------

log4j.logger.org.springframework.oxm.jaxb=WARN

#--------------------
# FURTHeR Code
#--------------------

#log4j.logger.edu.utah.further=DEBUG
log4j.logger.edu.utah.further.core.camel=WARN
log4j.logger.edu.utah.further.core.util=WARN
log4j.logger.edu.utah.further.core.chain=INFO
log4j.logger.edu.utah.further.core.data=WARN
log4j.logger.edu.utah.further.dts=WARN
log4j.logger.edu.utah.further.mdr=INFO
log4j.logger.edu.utah.further.fqe.ds.api.factory=WARN
log4j.logger.edu.utah.further.fqe.impl.service.route=WARN
log4j.logger.edu.utah.further.fqe.ws=WARN
log4j.logger.edu.utah.further.ds.impl.service.metadata=WARN
log4j.logger.edu.utah.further.ds.impl.lifecycle=WARN
log4j.logger.edu.utah.further.osgi.shell=WARN

# Result set paging
#log4j.logger.edu.utah.further.core.data.hibernate.page=TRACE
#log4j.logger.edu.utah.further.ds.impl.service.query.logic=TRACE

log4j.logger.edu.utah.further.ds.impl.service.query.processor.InitializerQp=DEBUG
log4j.logger.org.hibernate.SQL=DEBUG, DB
log4j.logger.org.hibernate.type=TRACE, DB