[logback-dev] [GIT] Logback: the generic, reliable, fast and flexible logging framework. branch, master, updated. v0.9.18-12-g705c0fa

added by portage for gitosis-gentoo git-noreply at pixie.qos.ch
Thu Jan 28 08:16:00 CET 2010

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "Logback: the generic, reliable, fast and flexible logging framework.".

The branch, master has been updated
       via  705c0faec81a065b90a8bdbf6497c122e734aace (commit)
      from  7172853f27b3339eb1c1790f96f46c0162bdf141 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------

commit 705c0faec81a065b90a8bdbf6497c122e734aace
Author: Ceki Gulcu <ceki at qos.ch>
Date:   Thu Jan 28 08:11:56 2010 +0100

    - added missing hsqldb.sql files. A live version of these files can be
    found in DBAppenderTestFixture.java in the ch.qos.logback.access.db
    and ch.qos.logback.classic.db packages under src/test.

diff --git a/logback-access/src/main/java/ch/qos/logback/access/db/dialect/hsqldb.sql b/logback-access/src/main/java/ch/qos/logback/access/db/dialect/hsqldb.sql
new file mode 100644
index 0000000..c82b677
--- /dev/null
+++ b/logback-access/src/main/java/ch/qos/logback/access/db/dialect/hsqldb.sql
@@ -0,0 +1,28 @@
+# This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender
+# It is intended for HSQL databases.
+DROP TABLE access_event_header IF EXISTS;
+DROP TABLE access_event IF EXISTS;
+CREATE TABLE access_event (
+  timestmp BIGINT NOT NULL,
+  requestURI VARCHAR(254),
+  requestURL VARCHAR(254),
+  remoteHost VARCHAR(254),
+  remoteUser VARCHAR(254),
+  remoteAddr VARCHAR(254),
+  protocol VARCHAR(254),
+  method VARCHAR(254),
+  serverName VARCHAR(254),
+  postContent VARCHAR(254),
+CREATE TABLE access_event_header (
+  event_id INT NOT NULL,
+  header_key  VARCHAR(254) NOT NULL,
+  header_value LONGVARCHAR,
+  PRIMARY KEY(event_id, header_key),
+  FOREIGN KEY (event_id) REFERENCES access_event(event_id));
\ No newline at end of file
diff --git a/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/hsqldb.sql b/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/hsqldb.sql
new file mode 100644
index 0000000..3cdeccc
--- /dev/null
+++ b/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/hsqldb.sql
@@ -0,0 +1,35 @@
+# This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender.
+# It is intended for HSQL databases. It has been tested on HSQL 1.8.07.
+DROP TABLE logging_event_exception IF EXISTS;
+DROP TABLE logging_event_property IF EXISTS;
+DROP TABLE logging_event IF EXISTS;
+CREATE TABLE logging_event (
+  timestmp BIGINT NOT NULL,
+  formatted_message LONGVARCHAR NOT NULL,
+  logger_name VARCHAR(256) NOT NULL,
+  level_string VARCHAR(256) NOT NULL,
+  thread_name VARCHAR(256),
+  reference_flag SMALLINT,
+  caller_filename VARCHAR(256), 
+  caller_class VARCHAR(256), 
+  caller_method VARCHAR(256), 
+  caller_line CHAR(4),
+CREATE TABLE logging_event_property (
+  event_id INT NOT NULL,
+  mapped_key  VARCHAR(254) NOT NULL,
+  mapped_value LONGVARCHAR,
+  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,
+  trace_line VARCHAR(256) NOT NULL,
+  PRIMARY KEY(event_id, i),
+  FOREIGN KEY (event_id) REFERENCES logging_event(event_id));
\ No newline at end of file


Summary of changes:
 .../ch/qos/logback/access/db/dialect/hsqldb.sql    |   28 ++++++++++++++++
 .../ch/qos/logback/classic/db/dialect/hsqldb.sql   |   35 ++++++++++++++++++++
 2 files changed, 63 insertions(+), 0 deletions(-)
 create mode 100644 logback-access/src/main/java/ch/qos/logback/access/db/dialect/hsqldb.sql
 create mode 100644 logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/hsqldb.sql

Logback: the generic, reliable, fast and flexible logging framework.

More information about the logback-dev mailing list