I got the following sql script to create table from Logback package and I ran it and created tables. and I have event_id data field in the tables. # This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender # # It is intended for PostgreSQL databases. DROP TABLE logging_event_property; DROP TABLE logging_event_exception; DROP SEQUENCE logging_event_id_seq; DROP TABLE logging_event; CREATE SEQUENCE logging_event_id_seq MINVALUE 1 START 1; CREATE TABLE logging_event ( timestmp BIGINT NOT NULL, formatted_message TEXT NOT NULL, logger_name VARCHAR(254) NOT NULL, level_string VARCHAR(254) NOT NULL, thread_name VARCHAR(254), reference_flag SMALLINT, 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 INT DEFAULT nextval('logging_event_id_seq') PRIMARY KEY ); CREATE TABLE logging_event_property ( event_id INT NOT NULL, mapped_key VARCHAR(254) NOT NULL, mapped_value VARCHAR(1024), PRIMARY KEY(event_id, mapped_key), FOREIGN KEY (event_id) REFERENCES logging_event(event_id) ); CREATE TABLE logging_event_exception ( event_id INT NOT NULL, i SMALLINT NOT NULL, trace_line VARCHAR(254) NOT NULL, PRIMARY KEY(event_id, i), FOREIGN KEY (event_id) REFERENCES logging_event(event_id) ); Ceki Gülcü wrote:
On 04/03/2010 5:59 PM, Mohammad Haider wrote:
Thank you for quick reply.
I got the following output after putting the <statusListener> tag
12:58:33,750 |-ERROR in ch.qos.logback.classic.db.DBAppender[DB] - problem appending event org.postgresql.util.PSQLException: ERROR: column "EVENT_ID" does not exist
The error message "Column EVENT_ID does not exist" seems rather explicit to me.
_______________________________________________ Logback-user mailing list Logback-user@qos.ch http://qos.ch/mailman/listinfo/logback-user
-- Thanks * Mohammad Firoj Haider* Software Developer LashPoint Inc <http://www.lashpoint.com> Email: mohammadh@lashpoint.com <mailto:mohammadh@lashpoint.com> Blog: The Daily Programming <http://www.codinglogs.blogspot.com/> Lashpoint mini logo