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;