Author: ceki Date: Wed Oct 22 11:04:21 2008 New Revision: 1858 Added: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle.sql - copied, changed from r1857, /logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle9i.sql Removed: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/db2l.sql logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle9i.sql Log: - Removed superfluous file db2l.sql - renamed oracle9i.sql as oracle.sql Copied: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle.sql (from r1857, /logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle9i.sql) ============================================================================== --- /logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle9i.sql (original) +++ logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle.sql Wed Oct 22 11:04:21 2008 @@ -1,8 +1,9 @@ -- This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender -- --- It is intended for Oracle 9i databases. Tested on version 9.2 +-- It is intended for Oracle 9i, 10g and 11g databases. Tested on version 9.2, 10g and +-- 11g. --- The following lines are useful in cleaning any previous tables +-- The following lines are useful in cleaning any previously existing tables --drop TRIGGER logging_event_id_seq_trig; --drop SEQUENCE logging_event_id_seq; @@ -29,6 +30,11 @@ ); +-- the / suffix may or may not be needed depending on your SQL Client +-- Some SQL Clients, e.g. SQuirrel SQL has trouble with the following +-- trigger creation command, while SQLPlus (the basic SQL Client which +-- ships with Oracle) has no trouble at all. + CREATE TRIGGER logging_event_id_seq_trig BEFORE INSERT ON logging_event FOR EACH ROW @@ -38,7 +44,6 @@ FROM DUAL; END; / --- the / suffix may or may not be needed depending on your SQL Client CREATE TABLE logging_event_property