[logback-dev] svn commit: r1872 - logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect

noreply.ceki at qos.ch noreply.ceki at qos.ch
Fri Oct 24 23:20:35 CEST 2008


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
   (


More information about the logback-dev mailing list