Author: seb
Date: Tue Nov 7 11:16:08 2006
New Revision: 879
Added:
logback/trunk/logback-classic/src/test/input/db/append-toMySQL-with-driverManager.xml
- copied, changed from r870,
/logback/trunk/logback-classic/src/test/input/db/dbAppenderUsingConnectionSource.xml
logback/trunk/logback-classic/src/test/input/db/append-with-c3p0.xml
logback/trunk/logback-classic/src/test/input/db/append-with-datasource.xml
logback/trunk/logback-classic/src/test/input/db/append-with-drivermanager.xml
logback/trunk/logback-classic/src/test/input/db/append-with-jndi.xml
logback/trunk/logback-classic/src/test/input/db/append-with-pooled-datasource.xml
logback/trunk/logback-classic/src/test/input/db/deleteTables.sql
Removed:
logback/trunk/logback-classic/src/test/input/db/dbAppenderUsingConnectionSource.xml
Log:
added some db example configs
Copied:
logback/trunk/logback-classic/src/test/input/db/append-toMySQL-with-driverManager.xml
(from r870,
/logback/trunk/logback-classic/src/test/input/db/dbAppenderUsingConnectionSource.xml)
==============================================================================
---
/logback/trunk/logback-classic/src/test/input/db/dbAppenderUsingConnectionSource.xml
(original)
+++
logback/trunk/logback-classic/src/test/input/db/append-toMySQL-with-driverManager.xml
Tue Nov 7 11:16:08 2006
@@ -2,17 +2,17 @@
<appender name="DB" class="ch.qos.logback.classic.db.DBAppender">
<connectionSource
class="ch.qos.logback.classic.db.DriverManagerConnectionSource">
- <param name="driverClass" value="com.mysql.jdbc.Driver"/>
- <param name="url" value="jdbc:mysql://host_name:3306/datebase_name"/>
- <param name="user" value="logback"/>
- <param name="password" value="logback"/>
+ <driverClass>"com.mysql.jdbc.Driver</driverClass>
+ <url>jdbc:mysql://host_name:3306/datebase_name</url>
+ <user>logback</user>
+ <password>logback</password>
</connectionSource>
</appender>
<appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
<layout class="ch.qos.logback.classic.PatternLayout">
- <param name="pattern" value="%p %t %c - %m%n"/>
+ <pattern>%level %thread %logger - %msg%n</pattern>
</layout>
</appender>
<root>
Added: logback/trunk/logback-classic/src/test/input/db/append-with-c3p0.xml
==============================================================================
--- (empty file)
+++ logback/trunk/logback-classic/src/test/input/db/append-with-c3p0.xml
Tue Nov 7 11:16:08 2006
@@ -0,0 +1,41 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+
+<configuration>
+
+ <appender name="DB" class="ch.qos.logback.classic.db.DBAppender">
+ <connectionSource
class="ch.qos.logback.core.db.DataSourceConnectionSource">
+ <dataSource class="com.mchange.v2.c3p0.ComboPooledDataSource">
+ <driverClass>${driverClass}</driverClass>
+ <jdbcUrl>${url}</jdbcUrl>
+ <serverName>${serverName}</serverName>
+ <databaseName>${databaseName}</databaseName>
+ <user>${user}</user>
+ <password>${password}</password>
+ <!--
+ <param name="initialConnections" value="10"/>
+ <param name="maxConnections" value="10"/>
+
+ <param name="max-connections" value="100"/>
+ <param name="min-connections" value="5" />
+ <param name="inactivity-timeout" value="200"/>
+ -->
+ </dataSource>
+
+ <user>${user}</user>
+ <password>${password}</password>
+ </connectionSource>
+ </appender>
+
+
+ <!-- Prevent internal logback DEBUG messages from polluting the output. -->
+ <logger name="ch.qos.logback.core.joran"><level value="INFO" /></logger>
+ <logger name="ch.qos.logback.classic.joran"><level value="INFO" /></logger>
+
+
+ <root>
+ <level value ="debug"/>
+ <appender-ref ref="DB" />
+ </root>
+</configuration>
+
+
Added:
logback/trunk/logback-classic/src/test/input/db/append-with-datasource.xml
==============================================================================
--- (empty file)
+++ logback/trunk/logback-classic/src/test/input/db/append-with-datasource.xml
Tue Nov 7 11:16:08 2006
@@ -0,0 +1,30 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+
+<configuration>
+
+ <appender name="DB" class="ch.qos.logback.classic.db.DBAppender">
+ <connectionSource
class="ch.qos.logback.core.db.DataSourceConnectionSource">
+
+ <dataSource class="${dataSourceClass}">
+ <param name="${url-key:-url}" value="${url}"/>
+ <serverName>${serverName}</serverName>
+ <databaseName>${databaseName}</databaseName>
+ </dataSource>
+
+ <user>${user}</user>
+ <password>${password}</password>
+ </connectionSource>
+ </appender>
+
+ <!-- Prevent internal logback DEBUG messages from polluting the output. -->
+ <logger name="ch.qos.logback.core.joran"><level value="INFO" /></logger>
+ <logger name="ch.qos.logback.classic.joran"><level value="INFO" /></logger>
+
+ <root>
+ <level value ="debug"/>
+ <appender-ref ref="DB" />
+ </root>
+</configuration>
+
+
+
Added:
logback/trunk/logback-classic/src/test/input/db/append-with-drivermanager.xml
==============================================================================
--- (empty file)
+++
logback/trunk/logback-classic/src/test/input/db/append-with-drivermanager.xml
Tue Nov 7 11:16:08 2006
@@ -0,0 +1,24 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+
+<configuration>
+
+ <appender name="DB" class="ch.qos.logback.classic.db.DBAppender">
+ <connectionSource
class="ch.qos.logback.core.db.DriverManagerConnectionSource">
+ <driverClass>${driverClass}</driverClass>
+ <url>${url}</url>
+ <user>${user}</user>
+ <password>${password}</password>
+ </connectionSource>
+ </appender>
+
+ <!-- Prevent internal logback DEBUG messages from polluting the output.
-->
+ <logger name="ch.qos.logback.core.joran"><level value="INFO" /></logger>
+ <logger name="ch.qos.logback.classic.joran"><level value="INFO"
/></logger>
+
+ <root>
+ <level value="debug" />
+ <appender-ref ref="DB" />
+ </root>
+</configuration>
+
+
Added: logback/trunk/logback-classic/src/test/input/db/append-with-jndi.xml
==============================================================================
--- (empty file)
+++ logback/trunk/logback-classic/src/test/input/db/append-with-jndi.xml
Tue Nov 7 11:16:08 2006
@@ -0,0 +1,36 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+
+<configuration>
+ <!-- We create a joran rule that will instance and bind the appropriate
+ data source instance to JNDI. -->
+ <newRule pattern="configuration/bindDataSourceToJNDI"
+ actionClass="org.apache.log4j.db.BindDataSourceToJNDIAction"/>
+
+ <bindDataSourceToJNDI />
+
+ <appender name="DB" class="ch.qos.logback.classic.db.DBAppender">
+ <connectionSource
class="ch.qos.logback.core.db.DataSourceConnectionSource">
+
+ <dataSource class="${dataSourceClass}">
+ <param name="${url-key:-url}" value="${url}"/>
+ <serverName>${serverName}</serverName>
+ <databaseName>${databaseName}</databaseName>
+ </dataSource>
+
+ <user>${user}</user>
+ <password>${password}</password>>
+ </connectionSource>
+ </appender>
+
+ <!-- Prevent internal logback DEBUG messages from polluting the output.
-->
+ <logger name="ch.qos.logback.core.joran"><level value="INFO" /></logger>
+ <logger name="ch.qos.logback.classic.joran"><level value="INFO"
/></logger>
+
+ <root>
+ <level value ="debug"/>
+ <appender-ref ref="DB" />
+ </root>
+
+</configuration>
+
+
Added:
logback/trunk/logback-classic/src/test/input/db/append-with-pooled-datasource.xml
==============================================================================
--- (empty file)
+++
logback/trunk/logback-classic/src/test/input/db/append-with-pooled-datasource.xml
Tue Nov 7 11:16:08 2006
@@ -0,0 +1,34 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+
+<configuration>
+
+ <appender name="DB" class="ch.qos.logback.classic.db.DBAppender">
+ <connectionSource
class="ch.qos.logback.core.db.DataSourceConnectionSource">
+
+ <dataSource class="${pooledDataSourceClass}">
+ <param name="${url-key:-url}" value="${url}"/>
+ <serverName>${serverName}</serverName>
+ <databaseName>${databaseName}</databaseName>
+ <user>${user}</user>
+ <password>${password}</password>
+
+ <initialConnections>10</initialConnections>
+ <maxConnections>10</maxConnections>
+ </dataSource>
+
+ <user>${user}</user>
+ <password>${password}</password>
+ </connectionSource>
+ </appender>
+
+ <!-- Prevent internal logback DEBUG messages from polluting the output.
-->
+ <logger name="ch.qos.logback.core.joran"><level value="INFO" /></logger>
+ <logger name="ch.qos.logback.classic.joran"><level value="INFO"
/></logger>
+
+ <root>
+ <level value ="debug"/>
+ <appender-ref ref="DB" />
+ </root>
+</configuration>
+
+
Added: logback/trunk/logback-classic/src/test/input/db/deleteTables.sql
==============================================================================
--- (empty file)
+++ logback/trunk/logback-classic/src/test/input/db/deleteTables.sql Tue Nov
7 11:16:08 2006
@@ -0,0 +1,4 @@
+
+delete from logging_event_exception;
+delete from logging_event_property;
+delete from logging_event;
_______________________________________________
logback-dev mailing list
[email protected]
http://qos.ch/mailman/listinfo/logback-dev
