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

[noreply.ceki at qos.ch]

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