Author: ceki Date: Fri Oct 24 23:20:35 2008 New Revision: 1872 Modified: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/oracle.sql Log: comment on the TRIGGER creation Modified: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/oracle.sql ============================================================================== --- logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/oracle.sql (original) +++ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/oracle.sql Fri Oct 24 23:20:35 2008 @@ -5,6 +5,7 @@ CREATE SEQUENCE access_event_id_seq MINVALUE 1 START WITH 1; + CREATE TABLE access_event ( timestmp NUMBER(20) NOT NULL, @@ -20,6 +21,10 @@ event_id NUMBER(10) PRIMARY KEY ); +-- 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 access_event_id_seq_trig BEFORE INSERT ON access_event @@ -29,7 +34,7 @@ INTO :NEW.event_id FROM DUAL; END access_event_id_seq_trig; - +/ CREATE TABLE access_event_header (