angoca / log4db2

A logging utility like log4j for IBM Db2 SQL PL
https://angoca.github.io/log4db2/
BSD 2-Clause "Simplified" License
7 stars 2 forks source link

Integration with logback DBAppender #92

Open angoca opened 10 years ago

angoca commented 10 years ago

The DBAppender of logback uses many elements that are not available with LOG4DB2 mainly because logback uses Java. Elements like class, package, method, line o thread_name However, other elements like timestamp, formatted_message, logger_name and level_string, could be used to adapt log4db2 with logback. Write a documentation about this.

http://logback.qos.ch/manual/appenders.html

CREATE TABLE logging_event ( timestmp BIGINT NOT NULL, formatted_message VARCHAR(4000) NOT NULL, logger_name VARCHAR(254) NOT NULL, level_string VARCHAR(254) NOT NULL, thread_name VARCHAR(254), reference_flag SMALLINT, arg0 VARCHAR(254), arg1 VARCHAR(254), arg2 VARCHAR(254), arg3 VARCHAR(254), caller_filename VARCHAR(254) NOT NULL, caller_class VARCHAR(254) NOT NULL, caller_method VARCHAR(254) NOT NULL, caller_line CHAR(4) NOT NULL, event_id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1) );