November 2006 - logback-dev

svn commit: r1024 - logback/trunk/logback-core/src/main/java/ch/qos/logback/core/rolling
by noreply.ceki＠qos.ch 28 Nov '06

28 Nov '06

Author: ceki Date: Tue Nov 28 22:49:12 2006 New Revision: 1024 Modified: logback/trunk/logback-core/src/main/java/ch/qos/logback/core/rolling/TimeBasedRollingPolicy.java Log: correcting URL Modified: logback/trunk/logback-core/src/main/java/ch/qos/logback/core/rolling/TimeBasedRollingPolicy.java ============================================================================== --- logback/trunk/logback-core/src/main/java/ch/qos/logback/core/rolling/TimeBasedRollingPolicy.java (original) +++ logback/trunk/logback-core/src/main/java/ch/qos/logback/core/rolling/TimeBasedRollingPolicy.java Tue Nov 28 22:49:12 2006 @@ -33,7 +33,7 @@ static final String FNP_NOT_SET = "The FileNamePattern option must be set before using TimeBasedRollingPolicy. "; static final String SEE_FNP_NOT_SET = - "See also http://logback.qos.ch/doc/codes.html#tbr_fnp_not_set"; + "See also http://logback.qos.ch/codes.html#tbr_fnp_not_set"; RollingCalendar rc; long nextCheck; Date lastCheck = new Date();

1 0

svn commit: r1023 - logback/trunk/logback-examples/src/main/java/chapter4/conf/access
by noreply.seb＠qos.ch 28 Nov '06

28 Nov '06

Author: seb Date: Tue Nov 28 20:55:24 2006 New Revision: 1023 Added: logback/trunk/logback-examples/src/main/java/chapter4/conf/access/logback-DB.xml Log: Added a sample configuration for access' DBAppender Added: logback/trunk/logback-examples/src/main/java/chapter4/conf/access/logback-DB.xml ============================================================================== --- (empty file) +++ logback/trunk/logback-examples/src/main/java/chapter4/conf/access/logback-DB.xml Tue Nov 28 20:55:24 2006 @@ -0,0 +1,14 @@ +<configuration> + + <appender name="DB" class="ch.qos.logback.access.db.DBAppender"> + <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource"> + <driverClass>com.mysql.jdbc.Driver</driverClass> + <url>jdbc:mysql://localhost:3306/logbackdb</url> + <user>logback</user> + <password>logback</password> + </connectionSource> + <insertHeaders>true</insertHeaders> + </appender> + + <appender-ref ref="DB" /> +</configuration> \ No newline at end of file

1 0

svn commit: r1022 - in logback/trunk/logback-core/src/main/java/ch/qos/logback/core/joran: action spi
by noreply.ceki＠qos.ch 28 Nov '06

28 Nov '06

Author: ceki Date: Tue Nov 28 20:30:16 2006 New Revision: 1022 Modified: logback/trunk/logback-core/src/main/java/ch/qos/logback/core/joran/action/NestedComponentIA.java logback/trunk/logback-core/src/main/java/ch/qos/logback/core/joran/action/NestedSimplePropertyIA.java logback/trunk/logback-core/src/main/java/ch/qos/logback/core/joran/spi/Interpreter.java Log: more precise log messages Modified: logback/trunk/logback-core/src/main/java/ch/qos/logback/core/joran/action/NestedComponentIA.java ============================================================================== --- logback/trunk/logback-core/src/main/java/ch/qos/logback/core/joran/action/NestedComponentIA.java (original) +++ logback/trunk/logback-core/src/main/java/ch/qos/logback/core/joran/action/NestedComponentIA.java Tue Nov 28 20:30:16 2006 @@ -66,7 +66,7 @@ // we only push action data if NestComponentIA is applicable case AS_COMPONENT_COLLECTION: case AS_SINGLE_COMPONENT: - addInfo("was deemed applicable for " + pattern); + //addInfo("was deemed applicable for " + pattern); ImplicitActionData ad = new ImplicitActionData(parentBean, containmentType); actionDataStack.push(ad); @@ -91,7 +91,7 @@ if (OptionHelper.isEmpty(className)) { actionData.inError = true; - String errMsg = "No class name attribute in <" + localName + ">"; + String errMsg = "No class name attribute in [" + localName + "]"; addError(errMsg); return; @@ -110,12 +110,12 @@ ((ContextAware) actionData.nestedComponent).setContext(this.context); } // getLogger().debug( - addInfo("Pushing component <" + localName - + "> on top of the object stack."); + addInfo("Pushing component [" + localName + + "] on top of the object stack."); ec.pushObject(actionData.nestedComponent); } catch (Exception oops) { actionData.inError = true; - String msg = "Could not create component <" + localName + "> of type [" + String msg = "Could not create component [" + localName + "] of type [" + className + "]"; addError(msg, oops); } Modified: logback/trunk/logback-core/src/main/java/ch/qos/logback/core/joran/action/NestedSimplePropertyIA.java ============================================================================== --- logback/trunk/logback-core/src/main/java/ch/qos/logback/core/joran/action/NestedSimplePropertyIA.java (original) +++ logback/trunk/logback-core/src/main/java/ch/qos/logback/core/joran/action/NestedSimplePropertyIA.java Tue Nov 28 20:30:16 2006 @@ -68,7 +68,7 @@ ImplicitActionData ad = new ImplicitActionData(parentBean, containmentType); ad.propertyName = nestedElementTagName; actionDataStack.push(ad); - //addInfo("NestedSimplePropertyIA deemed applicable <" + pattern + ">"); + //addInfo("NestedSimplePropertyIA deemed applicable [" + pattern + "]"); return true; default: addError("PropertySetter.canContainComponent returned " + containmentType); Modified: logback/trunk/logback-core/src/main/java/ch/qos/logback/core/joran/spi/Interpreter.java ============================================================================== --- logback/trunk/logback-core/src/main/java/ch/qos/logback/core/joran/spi/Interpreter.java (original) +++ logback/trunk/logback-core/src/main/java/ch/qos/logback/core/joran/spi/Interpreter.java Tue Nov 28 20:30:16 2006 @@ -117,16 +117,16 @@ pattern.push(tagName); List applicableActionList = getApplicableActionList(pattern, atts); - + if (applicableActionList != null) { actionListStack.add(applicableActionList); callBeginAction(applicableActionList, tagName, atts); } else { actionListStack.add(EMPTY_LIST); - String errMsg = "no applicable action for <" + tagName - + ">, current pattern is [" + pattern + "]"; - ec.addError(errMsg); + String errMsg = "no applicable action for [" + tagName + + "], current pattern is [" + pattern + "]"; + cai.addError(errMsg); } }

1 0

svn commit: r1021 - logback/trunk/logback-core/src/test/java/ch/qos/logback/core/util
by noreply.seb＠qos.ch 28 Nov '06

28 Nov '06

Author: seb Date: Tue Nov 28 20:29:30 2006 New Revision: 1021 Modified: logback/trunk/logback-core/src/test/java/ch/qos/logback/core/util/StatusPrinterTest.java Log: silent tests are beautiful Modified: logback/trunk/logback-core/src/test/java/ch/qos/logback/core/util/StatusPrinterTest.java ============================================================================== --- logback/trunk/logback-core/src/test/java/ch/qos/logback/core/util/StatusPrinterTest.java (original) +++ logback/trunk/logback-core/src/test/java/ch/qos/logback/core/util/StatusPrinterTest.java Tue Nov 28 20:29:30 2006 @@ -95,7 +95,6 @@ context.getStatusManager().add(s2); StatusPrinter.print(context); String result = outputStream.toString(); - System.out.println(result); assertTrue(result.contains("|-ERROR in testWithException")); assertTrue(result.contains("+ INFO in testWithException")); assertTrue(result.contains("ch.qos.logback.core.util.StatusPrinterTest.testWithException"));

1 0

[continuum] BUILD FAILURE: Logback Access Module
by John Noreplai 28 Nov '06

28 Nov '06

Online report : http://localhost:8090/continuum/servlet/continuum/target/ProjectBuild.vm/vi… Build statistics: State: Failed Previous State: Failed Started at: Tue, 28 Nov 2006 20:21:52 +0100 Finished at: Tue, 28 Nov 2006 20:22:04 +0100 Total time: 12s Build Trigger: Forced Exit code: 1 Building machine hostname: pixie Operating system : Linux(unknown) Java version : 1.5.0_08(Sun Microsystems Inc.) Changes No files changed **************************************************************************** Output: **************************************************************************** [INFO] Scanning for projects... [INFO] ---------------------------------------------------------------------------- [INFO] Building Logback Access Module [INFO] task-segment: [clean, install] [INFO] ---------------------------------------------------------------------------- [INFO] [clean:clean] [INFO] Deleting directory /opt/continuum-1.0.3/apps/continuum/working-directory/47/target [INFO] Deleting directory /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/classes [INFO] Deleting directory /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/test-classes [INFO] [resources:resources] [INFO] Using default encoding to copy filtered resources. [INFO] [compiler:compile] Compiling 56 source files to /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/classes [INFO] [resources:testResources] [INFO] Using default encoding to copy filtered resources. [INFO] [compiler:testCompile] Compiling 22 source files to /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/test-classes [INFO] [surefire:test] [INFO] Surefire report directory: /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/surefire-reports ------------------------------------------------------- T E S T S ------------------------------------------------------- Running ch.qos.logback.access.db.DBAppenderTest [Server@3c6f579]: [Thread[main,5,main]]: checkRunning(false) entered [Server@3c6f579]: [Thread[main,5,main]]: checkRunning(false) exited [Server@3c6f579]: [Thread[main,5,main]]: setDatabaseName(0,test) [Server@3c6f579]: [Thread[main,5,main]]: checkRunning(false) entered [Server@3c6f579]: [Thread[main,5,main]]: checkRunning(false) exited [Server@3c6f579]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true) [Server@2ca6d51e]: [Thread[main,5,main]]: checkRunning(false) entered [Server@2ca6d51e]: [Thread[main,5,main]]: checkRunning(false) exited [Server@2ca6d51e]: [Thread[main,5,main]]: setDatabaseName(0,test) [Server@2ca6d51e]: [Thread[main,5,main]]: checkRunning(false) entered [Server@2ca6d51e]: [Thread[main,5,main]]: checkRunning(false) exited [Server@2ca6d51e]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true) [Server@12b7eea]: [Thread[main,5,main]]: checkRunning(false) entered [Server@12b7eea]: [Thread[main,5,main]]: checkRunning(false) exited [Server@12b7eea]: [Thread[main,5,main]]: setDatabaseName(0,test) [Server@12b7eea]: [Thread[main,5,main]]: checkRunning(false) entered [Server@12b7eea]: [Thread[main,5,main]]: checkRunning(false) exited [Server@12b7eea]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true) Tests run: 3, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.657 sec <<< FAILURE! Running ch.qos.logback.access.jetty.JettyBasicTest 2006-11-28 20:22:03.232::INFO: Logging to STDERR via org.mortbay.log.StdErrLog |-WARN in ch.qos.logback.access.jetty.RequestLogImpl@60f47bf5 - filename property not set. Assuming [null/etc/logback-access.xml] |-ERROR in ch.qos.logback.access.jetty.RequestLogImpl@60f47bf5 - [null/etc/logback-access.xml] does not exist |-INFO in ch.qos.logback.access.jetty.RequestLogImpl@60f47bf5 - RequestLog added to RequestLogRegistry with name: LogbackRequestLog 2006-11-28 20:22:03.279::INFO: jetty-6.0.x 2006-11-28 20:22:03.350::INFO: Started SelectChannelConnector @ 0.0.0.0:1234 28/11/2006:20:22:03 +0100 localhost 127.0.0.1 Tests run: 2, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 1.282 sec <<< FAILURE! Running ch.qos.logback.access.filter.AccessStatsTest Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.011 sec Running ch.qos.logback.access.pattern.ConverterTest Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.03 sec Running ch.qos.logback.access.filter.StatsByDayTest Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.012 sec Running ch.qos.logback.access.net.URLEvaluatorTest Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.015 sec Running ch.qos.logback.access.net.SocketAppenderTest Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.129 sec Results : Tests run: 28, Failures: 0, Errors: 2, Skipped: 0 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] There are test failures. [INFO] ------------------------------------------------------------------------ [INFO] For more information, run Maven with the -e switch [INFO] ------------------------------------------------------------------------ [INFO] Total time: 10 seconds [INFO] Finished at: Tue Nov 28 20:22:04 CET 2006 [INFO] Final Memory: 12M/142M [INFO] ------------------------------------------------------------------------ ****************************************************************************

1 0

[continuum] BUILD FAILURE: Logback Access Module
by John Noreplai 28 Nov '06

28 Nov '06

Online report : http://localhost:8090/continuum/servlet/continuum/target/ProjectBuild.vm/vi… Build statistics: State: Failed Previous State: Ok Started at: Tue, 28 Nov 2006 20:20:18 +0100 Finished at: Tue, 28 Nov 2006 20:20:28 +0100 Total time: 9s Build Trigger: Schedule Exit code: 1 Building machine hostname: pixie Operating system : Linux(unknown) Java version : 1.5.0_08(Sun Microsystems Inc.) Changes seb minor fix /logback/trunk/logback-access/src/test/java/ch/qos/logback/access/net/SerializationPerfTest.java **************************************************************************** Output: **************************************************************************** [INFO] Scanning for projects... [INFO] ---------------------------------------------------------------------------- [INFO] Building Logback Access Module [INFO] task-segment: [clean, install] [INFO] ---------------------------------------------------------------------------- [INFO] [clean:clean] [INFO] Deleting directory /opt/continuum-1.0.3/apps/continuum/working-directory/47/target [INFO] Deleting directory /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/classes [INFO] Deleting directory /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/test-classes [INFO] [resources:resources] [INFO] Using default encoding to copy filtered resources. [INFO] [compiler:compile] Compiling 56 source files to /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/classes [INFO] [resources:testResources] [INFO] Using default encoding to copy filtered resources. [INFO] [compiler:testCompile] Compiling 22 source files to /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/test-classes [INFO] [surefire:test] [INFO] Surefire report directory: /opt/continuum-1.0.3/apps/continuum/working-directory/47/target/surefire-reports ------------------------------------------------------- T E S T S ------------------------------------------------------- Running ch.qos.logback.access.db.DBAppenderTest [Server@658fb1f7]: [Thread[main,5,main]]: checkRunning(false) entered [Server@658fb1f7]: [Thread[main,5,main]]: checkRunning(false) exited [Server@658fb1f7]: [Thread[main,5,main]]: setDatabaseName(0,test) [Server@658fb1f7]: [Thread[main,5,main]]: checkRunning(false) entered [Server@658fb1f7]: [Thread[main,5,main]]: checkRunning(false) exited [Server@658fb1f7]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true) [Server@2aca0115]: [Thread[main,5,main]]: checkRunning(false) entered [Server@2aca0115]: [Thread[main,5,main]]: checkRunning(false) exited [Server@2aca0115]: [Thread[main,5,main]]: setDatabaseName(0,test) [Server@2aca0115]: [Thread[main,5,main]]: checkRunning(false) entered [Server@2aca0115]: [Thread[main,5,main]]: checkRunning(false) exited [Server@2aca0115]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true) [Server@4e99353f]: [Thread[main,5,main]]: checkRunning(false) entered [Server@4e99353f]: [Thread[main,5,main]]: checkRunning(false) exited [Server@4e99353f]: [Thread[main,5,main]]: setDatabaseName(0,test) [Server@4e99353f]: [Thread[main,5,main]]: checkRunning(false) entered [Server@4e99353f]: [Thread[main,5,main]]: checkRunning(false) exited [Server@4e99353f]: [Thread[main,5,main]]: setDatabasePath(0,mem:test;sql.enforce_strict_size=true) Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.826 sec Running ch.qos.logback.access.jetty.JettyBasicTest 2006-11-28 20:20:26.346::INFO: Logging to STDERR via org.mortbay.log.StdErrLog 2006-11-28 20:20:26.388::INFO: jetty-6.0.x |-WARN in ch.qos.logback.access.jetty.RequestLogImpl@1fd0fafc - filename property not set. Assuming [null/etc/logback-access.xml] |-ERROR in ch.qos.logback.access.jetty.RequestLogImpl@1fd0fafc - [null/etc/logback-access.xml] does not exist |-INFO in ch.qos.logback.access.jetty.RequestLogImpl@1fd0fafc - RequestLog added to RequestLogRegistry with name: LogbackRequestLog 2006-11-28 20:20:26.454::INFO: Started SelectChannelConnector @ 0.0.0.0:1234 28/11/2006:20:20:26 +0100 localhost 127.0.0.1 Tests run: 2, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 1.264 sec <<< FAILURE! Running ch.qos.logback.access.filter.AccessStatsTest Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.01 sec Running ch.qos.logback.access.pattern.ConverterTest Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.021 sec Running ch.qos.logback.access.filter.StatsByDayTest Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.011 sec Running ch.qos.logback.access.net.URLEvaluatorTest Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.013 sec Running ch.qos.logback.access.net.SocketAppenderTest Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.136 sec Results : Tests run: 28, Failures: 0, Errors: 1, Skipped: 0 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] There are test failures. [INFO] ------------------------------------------------------------------------ [INFO] For more information, run Maven with the -e switch [INFO] ------------------------------------------------------------------------ [INFO] Total time: 8 seconds [INFO] Finished at: Tue Nov 28 20:20:27 CET 2006 [INFO] Final Memory: 12M/142M [INFO] ------------------------------------------------------------------------ ****************************************************************************

1 0

svn commit: r1020 - logback/trunk/logback-access/src/test/java/ch/qos/logback/access/net
by noreply.seb＠qos.ch 28 Nov '06

28 Nov '06

Author: seb Date: Tue Nov 28 20:05:25 2006 New Revision: 1020 Modified: logback/trunk/logback-access/src/test/java/ch/qos/logback/access/net/SerializationPerfTest.java Log: minor fix Modified: logback/trunk/logback-access/src/test/java/ch/qos/logback/access/net/SerializationPerfTest.java ============================================================================== --- logback/trunk/logback-access/src/test/java/ch/qos/logback/access/net/SerializationPerfTest.java (original) +++ logback/trunk/logback-access/src/test/java/ch/qos/logback/access/net/SerializationPerfTest.java Tue Nov 28 20:05:25 2006 @@ -89,7 +89,7 @@ total /= (1000);//nanos -> micros System.out.println("Loop done : average time = " + total / loopNumber + " microsecs after " + loopNumber + " writes."); - //average time: 26-30 microsec = 0.034 milis + //average time: 26-30 microsec = 0.030 millis } private AccessEvent buildNewAccessEvent() {

1 0

svn commit: r1019 - logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect
by noreply.seb＠qos.ch 28 Nov '06

28 Nov '06

Author: seb Date: Tue Nov 28 17:41:06 2006 New Revision: 1019 Modified: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mysql.sql logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql Log: end of script moving around Modified: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mysql.sql ============================================================================== --- logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mysql.sql (original) +++ logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/mysql.sql Tue Nov 28 17:41:06 2006 @@ -1,38 +1,51 @@ -# This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender. +# This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender. # # It is intended for MySQL databases. It has been tested on MySQL 5.0.22 with # INNODB tables. BEGIN; -DROP TABLE IF EXISTS access_event_header; -DROP TABLE IF EXISTS access_event; +DROP TABLE IF EXISTS logging_event_property; +DROP TABLE IF EXISTS logging_event_exception; +DROP TABLE IF EXISTS logging_event; COMMIT; + BEGIN; -CREATE TABLE access_event +CREATE TABLE logging_event ( - timestmp BIGINT NOT NULL, - requestURI VARCHAR(254), - requestURL VARCHAR(254), - remoteHost VARCHAR(254), - remoteUser VARCHAR(254), - remoteAddr VARCHAR(254), - protocol VARCHAR(254), - method VARCHAR(254), - serverName VARCHAR(254), - postContent VARCHAR(254), + timestmp BIGINT NOT NULL, + formatted_message TEXT NOT NULL, + logger_name VARCHAR(254) NOT NULL, + level_string VARCHAR(254) NOT NULL, + thread_name VARCHAR(254), + reference_flag SMALLINT, + caller_filename VARCHAR(254) NOT NULL, + caller_class VARCHAR(254) NOT NULL, + caller_method VARCHAR(254) NOT NULL, + caller_line CHAR(4) NOT NULL, event_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ); COMMIT; BEGIN; -CREATE TABLE access_event_header +CREATE TABLE logging_event_property ( event_id INT NOT NULL, - header_key VARCHAR(254) NOT NULL, - header_value TEXT, - PRIMARY KEY(event_id, header_key), - FOREIGN KEY (event_id) REFERENCES access_event(event_id) + mapped_key VARCHAR(254) NOT NULL, + mapped_value TEXT, + PRIMARY KEY(event_id, mapped_key), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id) + ); +COMMIT; + +BEGIN; +CREATE TABLE logging_event_exception + ( + event_id INT NOT NULL, + i SMALLINT NOT NULL, + trace_line VARCHAR(254) NOT NULL, + PRIMARY KEY(event_id, i), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id) ); COMMIT; \ No newline at end of file Modified: logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql ============================================================================== --- logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql (original) +++ logback/trunk/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/postgresql.sql Tue Nov 28 17:41:06 2006 @@ -2,32 +2,44 @@ # # It is intended for PostgreSQL databases. -DROP TABLE access_event_exception; -DROP SEQUENCE access_event_id_seq; -DROP TABLE access_event; +DROP TABLE logging_event_property; +DROP TABLE logging_event_exception; +DROP SEQUENCE logging_event_id_seq; +DROP TABLE logging_event; -CREATE SEQUENCE access_event_id_seq MINVALUE 1 START 1; -CREATE TABLE access_event +CREATE SEQUENCE logging_event_id_seq MINVALUE 1 START 1; + + +CREATE TABLE logging_event ( - timestmp BIGINT NOT NULL, - requestURI VARCHAR(254), - requestURL VARCHAR(254), - remoteHost VARCHAR(254), - remoteUser VARCHAR(254), - remoteAddr VARCHAR(254), - protocol VARCHAR(254), - method VARCHAR(254), - serverName VARCHAR(254), - postContent VARCHAR(254), - event_id INT DEFAULT nextval('access_event_id_seq') PRIMARY KEY + timestmp BIGINT NOT NULL, + formatted_message TEXT NOT NULL, + logger_name VARCHAR(254) NOT NULL, + level_string VARCHAR(254) NOT NULL, + thread_name VARCHAR(254), + reference_flag SMALLINT, + caller_filename VARCHAR(254) NOT NULL, + caller_class VARCHAR(254) NOT NULL, + caller_method VARCHAR(254) NOT NULL, + caller_line CHAR(4) NOT NULL, + event_id INT DEFAULT nextval('logging_event_id_seq') PRIMARY KEY ); -CREATE TABLE access_event_header -( +CREATE TABLE logging_event_property + ( event_id INT NOT NULL, - header_key VARCHAR(254) NOT NULL, - header_value VARCHAR(1024), - PRIMARY KEY(event_id, header_key), - FOREIGN KEY (event_id) REFERENCES access_event(event_id) - ); \ No newline at end of file + mapped_key VARCHAR(254) NOT NULL, + mapped_value VARCHAR(1024), + PRIMARY KEY(event_id, mapped_key), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id) + ); + +CREATE TABLE logging_event_exception + ( + event_id INT NOT NULL, + i SMALLINT NOT NULL, + trace_line VARCHAR(254) NOT NULL, + PRIMARY KEY(event_id, i), + FOREIGN KEY (event_id) REFERENCES logging_event(event_id) + );

1 0

svn commit: r1018 - logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect
by noreply.seb＠qos.ch 28 Nov '06

28 Nov '06

Author: seb Date: Tue Nov 28 17:39:49 2006 New Revision: 1018 Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/postgresql.sql Log: Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/postgresql.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/postgresql.sql Tue Nov 28 17:39:49 2006 @@ -0,0 +1,33 @@ +# This SQL script creates the required tables by ch.qos.logback.classic.db.DBAppender +# +# It is intended for PostgreSQL databases. + +DROP TABLE access_event_exception; +DROP SEQUENCE access_event_id_seq; +DROP TABLE access_event; + +CREATE SEQUENCE access_event_id_seq MINVALUE 1 START 1; + +CREATE TABLE access_event + ( + timestmp BIGINT NOT NULL, + requestURI VARCHAR(254), + requestURL VARCHAR(254), + remoteHost VARCHAR(254), + remoteUser VARCHAR(254), + remoteAddr VARCHAR(254), + protocol VARCHAR(254), + method VARCHAR(254), + serverName VARCHAR(254), + postContent VARCHAR(254), + event_id INT DEFAULT nextval('access_event_id_seq') PRIMARY KEY + ); + +CREATE TABLE access_event_header +( + event_id INT NOT NULL, + header_key VARCHAR(254) NOT NULL, + header_value VARCHAR(1024), + PRIMARY KEY(event_id, header_key), + FOREIGN KEY (event_id) REFERENCES access_event(event_id) + ); \ No newline at end of file

1 0

svn commit: r1017 - logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect
by noreply.seb＠qos.ch 28 Nov '06

28 Nov '06

Author: seb Date: Tue Nov 28 17:37:16 2006 New Revision: 1017 Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/db2.sql logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/db2l.sql logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/deleteTables.sql logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/mssql.sql logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/mysql.sql logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/oracle.sql Log: Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/db2.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/db2.sql Tue Nov 28 17:37:16 2006 @@ -0,0 +1,36 @@ +# This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender +# +# It is intended for IBM DB2 databases. +# +# WARNING WARNING WARNING WARNING +# ================================= +# This SQL script has not been tested on an actual DB2 +# instance. It may contain errors or even invalid SQL +# statements. + +DROP TABLE access_event_header; +DROP TABLE access_event; + +CREATE TABLE access_event + ( + timestmp BIGINT NOT NULL, + requestURI VARCHAR(254), + requestURL VARCHAR(254), + remoteHost VARCHAR(254), + remoteUser VARCHAR(254), + remoteAddr VARCHAR(254), + protocol VARCHAR(254), + method VARCHAR(254), + serverName VARCHAR(254), + postContent VARCHAR(254), + event_id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1) + ); + +CREATE TABLE access_event_header + ( + event_id INTEGER NOT NULL, + header_key VARCHAR(254) NOT NULL, + header_value VARCHAR(1024), + PRIMARY KEY(event_id, header_key), + FOREIGN KEY (event_id) REFERENCES access_event(event_id) + ); Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/db2l.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/db2l.sql Tue Nov 28 17:37:16 2006 @@ -0,0 +1,32 @@ +# This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender +# +# It is intended for PostgreSQL databases. + +DROP TABLE access_event_header; +DROP TABLE access_event; + +CREATE SEQUENCE access_event_id_seq MINVALUE 1 START 1; + +CREATE TABLE access_event + ( + timestmp BIGINT NOT NULL, + requestURI VARCHAR(254), + requestURL VARCHAR(254), + remoteHost VARCHAR(254), + remoteUser VARCHAR(254), + remoteAddr VARCHAR(254), + protocol VARCHAR(254), + method VARCHAR(254), + serverName VARCHAR(254), + postContent VARCHAR(254), + event_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY + ); + +CREATE TABLE access_event_header + ( + event_id INT NOT NULL, + header_key VARCHAR(254) NOT NULL, + header_value VARCHAR(1024), + PRIMARY KEY(event_id, header_key), + FOREIGN KEY (event_id) REFERENCES access_event(event_id) + ); \ No newline at end of file Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/deleteTables.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/deleteTables.sql Tue Nov 28 17:37:16 2006 @@ -0,0 +1,3 @@ + +delete from access_event_property; +delete from access_event; Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/mssql.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/mssql.sql Tue Nov 28 17:37:16 2006 @@ -0,0 +1,31 @@ +-- This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender +-- + +DROP TABLE access_event_header +DROP TABLE access_event + +CREATE TABLE logging_event + ( + timestmp BIGINT NOT NULL, + requestURI VARCHAR(254), + requestURL VARCHAR(254), + remoteHost VARCHAR(254), + remoteUser VARCHAR(254), + remoteAddr VARCHAR(254), + protocol VARCHAR(254), + method VARCHAR(254), + serverName VARCHAR(254), + postContent VARCHAR(254), + event_id INT NOT NULL identity, + PRIMARY KEY(event_id) + ) + +CREATE TABLE access_event_header + ( + event_id INT NOT NULL, + header_key VARCHAR(254) NOT NULL, + header_value VARCHAR(1024), + PRIMARY KEY(event_id, header_key), + FOREIGN KEY (event_id) REFERENCES access_event(event_id) + ) + Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/mysql.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/mysql.sql Tue Nov 28 17:37:16 2006 @@ -0,0 +1,38 @@ +# This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender. +# +# It is intended for MySQL databases. It has been tested on MySQL 5.0.22 with +# INNODB tables. + + +BEGIN; +DROP TABLE IF EXISTS access_event_header; +DROP TABLE IF EXISTS access_event; +COMMIT; + +BEGIN; +CREATE TABLE access_event + ( + timestmp BIGINT NOT NULL, + requestURI VARCHAR(254), + requestURL VARCHAR(254), + remoteHost VARCHAR(254), + remoteUser VARCHAR(254), + remoteAddr VARCHAR(254), + protocol VARCHAR(254), + method VARCHAR(254), + serverName VARCHAR(254), + postContent VARCHAR(254), + event_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY + ); +COMMIT; + +BEGIN; +CREATE TABLE access_event_header + ( + event_id INT NOT NULL, + header_key VARCHAR(254) NOT NULL, + header_value TEXT, + PRIMARY KEY(event_id, header_key), + FOREIGN KEY (event_id) REFERENCES access_event(event_id) + ); +COMMIT; \ No newline at end of file Added: logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/oracle.sql ============================================================================== --- (empty file) +++ logback/trunk/logback-access/src/main/java/ch/qos/logback/access/db/dialect/oracle.sql Tue Nov 28 17:37:16 2006 @@ -0,0 +1,45 @@ +-- This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender +-- +-- It is intended for Oracle databases. + + +CREATE SEQUENCE access_event_id_seq MINVALUE 1 START WITH 1; + +CREATE TABLE access_event + ( + timestmp BIGINT NOT NULL, + requestURI VARCHAR(254), + requestURL VARCHAR(254), + remoteHost VARCHAR(254), + remoteUser VARCHAR(254), + remoteAddr VARCHAR(254), + protocol VARCHAR(254), + method VARCHAR(254), + serverName VARCHAR(254), + postContent VARCHAR(254), + event_id NUMBER(10) PRIMARY KEY + ); + + +CREATE TRIGGER access_event_id_seq_trig + BEFORE INSERT ON access_event + FOR EACH ROW + BEGIN + SELECT access_event_id_seq.NEXTVAL + INTO :NEW.event_id + FROM DUAL; + END access_event_id_seq_trig; + + +CREATE TABLE access_event_header + ( + event_id NUMBER(10) NOT NULL, + header_key VARCHAR2(254) NOT NULL, + header_value VARCHAR2(1024), + PRIMARY KEY(event_id, header_key), + FOREIGN KEY (event_id) REFERENCES access_event(event_id) + ); + + + +

1 0