#log4j.rootLogger=ERROR, C
log4j.logger.org.firebird=ERROR, C
log4j.logger.org.firebirdsql=ERROR, C
log4j.logger.org.apache.joran=ERROR, C
log4j.logger.org.apache.log4j.joran.action=ERROR, C

log4j.logger.org.apache.log4j.jdbcplus.examples=DEBUG, JDBC, JDBC2
#log4j.logger.org.apache.log4j.jdbcplus.examples=INFO, JDBC_COMPARE_TEST

# console appender
log4j.appender.C=org.apache.log4j.ConsoleAppender
log4j.appender.C.layout=org.apache.log4j.PatternLayout
log4j.appender.C.layout.ConversionPattern=%d [%t] %-5p %c %x - %m%n

# JDBC appender using custom handlers, 2a)
log4j.appender.JDBC=org.apache.log4j.jdbcplus.JDBCAppender
log4j.appender.JDBC.connector=org.apache.log4j.jdbcplus.examples.FirebirdPoolConnectionHandler
log4j.appender.JDBC.sqlhandler=org.apache.log4j.jdbcplus.examples.SqlHandler
log4j.appender.JDBC.dbclass=org.firebirdsql.jdbc.FBDriver
log4j.appender.JDBC.buffer=1
log4j.appender.JDBC.commit=true
log4j.appender.JDBC.layout=org.apache.log4j.PatternLayout
log4j.appender.JDBC.layout.ConversionPattern=%m

# JDBC appender directly, 2b)
log4j.appender.JDBC2=org.apache.log4j.jdbcplus.JDBCAppender
# created db alias in aliases.conf: danko = D:\Programme\Firebird\Firebird1.5\Data\danko.fdb
log4j.appender.JDBC2.url=jdbc:firebirdsql:localhost/3050:danko
log4j.appender.JDBC2.dbclass=org.firebirdsql.jdbc.FBDriver
log4j.appender.JDBC2.username=danko
log4j.appender.JDBC2.password=danko
#log4j.appender.JDBC2.sql=INSERT INTO LOG_LOG4J2 (MSG) VALUES ('@MSG@')
#next: example for most functions/log types
log4j.appender.JDBC2.sql=INSERT INTO LOGTEST (id, prio, iprio, cat, thread, msg, layout_msg, throwable, ndc, mdc, mdc2, info, addon, the_date, the_time, the_timestamp, created_by) VALUES (@INC@, '@PRIO@', @IPRIO@, '@CAT@', '@THREAD@', '@MSG@', '@LAYOUT:1@', '@THROWABLE@', '@NDC@', '@MDC:MyMDC@', '@MDC:MyMDC2@', 'info timestamp: @TIMESTAMP@', '@LAYOUT@', cast ('@LAYOUT:3@' as date), cast ('@LAYOUT:4@' as time), cast ('@LAYOUT:3@ @LAYOUT:4@' as timestamp), 'me')
log4j.appender.JDBC2.layout=org.apache.log4j.PatternLayout
# conversion pattern with 4 parts separated by #, second is empty
log4j.appender.JDBC2.layout.ConversionPattern=[%t] %m %l##%d{dd.MM.yyyy}#%d{HH:mm:ss}
log4j.appender.JDBC2.layoutPartsDelimiter=#
log4j.appender.JDBC2.buffer=1
log4j.appender.JDBC2.commit=true
log4j.appender.JDBC2.quoteReplace=true
log4j.appender.JDBC2.throwableMaxChars=3000

# test to compare this option with PreparedStatement configuration
log4j.appender.JDBC_COMPARE_TEST=org.apache.log4j.jdbcplus.JDBCAppender
log4j.appender.JDBC_COMPARE_TEST.url=jdbc:firebirdsql:localhost/3050:danko
log4j.appender.JDBC_COMPARE_TEST.dbclass=org.firebirdsql.jdbc.FBDriver
log4j.appender.JDBC_COMPARE_TEST.username=danko
log4j.appender.JDBC_COMPARE_TEST.password=danko
log4j.appender.JDBC_COMPARE_TEST.sql=INSERT INTO LOGTEST (id, prio, cat, thread, msg, layout_msg, throwable, ndc, mdc, mdc2, info, addon, the_date, the_time, the_timestamp, created_by) VALUES (@INC@, '@PRIO@', '@CAT@', '@THREAD@', '@MSG@', '@LAYOUT:1@', '@THROWABLE@', '@NDC@', '@MDC:MyMDC@', '@MDC:MyMDC2@', '@TIMESTAMP@', '@LAYOUT@', null, null, null, 'me')
log4j.appender.JDBC_COMPARE_TEST.layout=org.apache.log4j.PatternLayout
# conversion pattern with 4 parts separated by #, second is empty
log4j.appender.JDBC_COMPARE_TEST.layout.ConversionPattern=[%t] %m##%d{dd.MM.yyyy}#%d{HH:mm:ss}
log4j.appender.JDBC_COMPARE_TEST.layoutPartsDelimiter=#