ceki 2004/05/04 03:04:42
Modified: src/java/org/apache/log4j/db/dialect oracle.sql
Log:
- Added (untested!) support for oracle dialect.
- Added missing Apache copyright
Revision Changes Path
1.2 +32 -4 logging-log4j/src/java/org/apache/log4j/db/dialect/oracle.sql
Index: oracle.sql
===================================================================
RCS file: /home/cvs/logging-log4j/src/java/org/apache/log4j/db/dialect/oracle.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- oracle.sql 4 May 2004 09:36:03 -0000 1.1
+++ oracle.sql 4 May 2004 10:04:42 -0000 1.2
@@ -1,11 +1,39 @@
+# The following SQL script is untested in the sense that it has not
+# been executed against an Oracle database. Thus, it can contain typos
+# or can contain incorrect SQL statements.
-CREATE SEQUENCE event_id_seq;
-CREATE OR REPLACE TRIGGER event_id_seq_trig
+
+CREATE SEQUENCE logging_event_id_seq MINVALUE 1 START WITH 1;
+
+CREATE TABLE logging_event
+ (
+ sequence_number BIGINT NOT NULL,
+ timestamp BIGINT NOT NULL,
+ rendered_message TEXT NOT NULL,
+ logger_name VARCHAR(254) NOT NULL,
+ ndc TEXT,
+ thread_name VARCHAR(254),
+ id INT PRIMARY KEY
+ );
+
+CREATE TRIGGER logging_event_id_seq_trig
BEFORE INSERT ON logging_event
FOR EACH ROW
BEGIN
- SELECT logging_event_seq.NEXTVAL
+ SELECT logging_event_id_seq.NEXTVAL
INTO :NEW.id
FROM DUAL;
- END event_id_seq_trig;
\ No newline at end of file
+ END logging_event_id_seq_trig;
+
+CREATE TABLE mdc
+ (
+ event_id INT NOT NULL,
+ mapped_key VARCHAR(254) NOT NULL,
+ mapped_value VARCHAR(254),
+ PRIMARY KEY(event_id, mapped_key),
+ FOREIGN KEY (event_id) REFERENCES logging_event(id)
+ );
+
+
+
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
