<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">Do not see records logging into Oracle 11.1 tables using logback. </font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">The three tables( logging_event, logging_event_exception, logging_event_exception) </font><span class="Apple-style-span" style="font-family: 'times new roman', 'new york', times, serif; ">exist in Oracle DB.</span></div><div><span class="Apple-style-span" style="font-family: 'times new roman', 'new york', times, serif; "><br></span></div><div><span class="Apple-style-span" style="font-family: 'times new roman', 'new york',
times, serif; ">Note: I've tried replacing ojdbc6.jar and ojdbc5.jar logback still the result is same. No records in DB</span></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">---------------------------------DBlogback.xml-----------------------------------</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><configuration debug="true" scan="true" scanPeriod="3 seconds"></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <property name="hostName" value="localhost"/></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <property name="port" value="1521"/></font></div><div><font class="Apple-style-span" face="'times
new roman', 'new york', times, serif"> <property name="sid" value="test"/></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <property name="user" value="admin"/></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <property name="password" value="admin"/></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <appender name="DB2"
class="ch.qos.logback.classic.db.DBAppender"></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource"></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <driverClass>oracle.jdbc.driver.OracleDriver</driverClass></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <url>jdbc:oracle:thin:@${hostName}:${port}:${sid}</url></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <user>${user}</user></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">
<password>${password}</password></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </connectionSource></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </appender></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <!-- </font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <appender name="DB3" class="ch.qos.logback.classic.db.DBAppender"></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <connectionSource class="ch.qos.logback.core.db.DataSourceConnectionSource"></font></div><div><font
class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <dataSource class="com.mchange.v2.c3p0.ComboPooledDataSource"></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <driverClass>oracle.jdbc.driver.OracleDriver</driverClass></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <jdbcUrl>jdbc:oracle:thin:@${hostName}:${port}:${sid}</jdbcUrl></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <user>${user}</user></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york',
times, serif"> <password>${password}</password></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </dataSource></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </connectionSource></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </appender></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> --></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times,
serif"> <root level="TRACE"></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> <appender-ref ref="DB2" /></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </root></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"></configuration></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">---------------------------------------------------------------------------------------</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">The following log output shows no errors tried both DB2 and DB3 appenders the result is same. Log records won't get inserted into
none of the tables. </font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">22:15:44,015 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.groovy]</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">22:15:44,015 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml]</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">22:15:44,015 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.xml]</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">22:15:44,015 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Setting up default
configuration.</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">22:15:44,218 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - Setting ReconfigureOnChangeFilter scanning period to 3 seconds</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">22:15:44,218 |-INFO in ch.qos.logback.classic.turbo.ReconfigureOnChangeFilter@2ab32ab3 - Will scan for changes in file [C:\workspace\LogTest\com\test\DBlogback.xml] every 3 seconds. </font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">22:15:44,218 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - Adding ReconfigureOnChangeFilter as a turbo filter</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">22:15:44,234 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to
instantiate appender of type [ch.qos.logback.classic.db.DBAppender]</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">22:15:44,234 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [DB2]</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">22:15:47,593 |-INFO in ch.qos.logback.core.db.DriverManagerConnectionSource@6b746b74 - Driver name=Oracle JDBC driver</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">22:15:47,593 |-INFO in ch.qos.logback.core.db.DriverManagerConnectionSource@6b746b74 - Driver version=11.1.0.7.0-Production</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">22:15:47,593 |-INFO in ch.qos.logback.core.db.DriverManagerConnectionSource@6b746b74 - supportsGetGeneratedKeys=true</font></div><div><font
class="Apple-style-span" face="'times new roman', 'new york', times, serif">22:15:47,609 |-INFO in ch.qos.logback.classic.joran.action.RootLoggerAction - Setting level of ROOT logger to TRACE</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">22:15:47,609 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB2] to Logger[ROOT]</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">22:15:47,609 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">----------------------------------------------------------------------------------------</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span"
face="'times new roman', 'new york', times, serif">-----------------------------------------------------------------------------</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">The following jars are in the classpath of the sample project</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">slf4j-api-1.6.1.jar</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">logback-core-0.9.27.jar</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">logback-classic-0.9.27.jar</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">logback-access-0.9.27.jar</font></div><div><font class="Apple-style-span" face="'times new roman',
'new york', times, serif">commons-compiler.jar</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">commons-compiler-jdk.jar</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">janino.jar</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">ojdbc6.jar</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">Oracle version 11.1</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">-----------------------------------------------------------------------------------------</font></div><div><font class="Apple-style-span" face="'times
new roman', 'new york', times, serif">package com.test</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">import java.net.URL;</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">import org.slf4j.Logger;</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">import org.slf4j.LoggerFactory;</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">import ch.qos.logback.classic.joran.JoranConfigurator;</font></div><div><font class="Apple-style-span" face="'times new
roman', 'new york', times, serif">import ch.qos.logback.classic.LoggerContext;</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">import ch.qos.logback.core.joran.spi.JoranException;</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">import ch.qos.logback.core.util.Loader;</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">import ch.qos.logback.core.util.StatusPrinter;</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">public class LogTest </font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times,
serif">{</font></div><div><span class="Apple-tab-span" style="white-space:pre"><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </font></span></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span>public static void main(String[] args) </font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span>{</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span> </font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span> Logger logger = LoggerFactory.getLogger("LogTest");</font></div><div><span class="Apple-tab-span"
style="white-space:pre"><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </font></span></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span>try</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span>{</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span>configureViaXML_File();</font></div><div><span class="Apple-tab-span" style="white-space:pre"><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </font></span></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre">
</span>logger.info("Testing Status Text {}, {}","123", "test");</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span>logger.debug("Test Parameterized {} {} {} {} {}",new Object[] {1, 2,3,4,5});</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span>}</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span>catch(Exception ex)</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span>{</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre">
</span>logger.error("Exception in this LogTest message.",ex);</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span>ex.printStackTrace();</font></div><div><span class="Apple-tab-span" style="white-space:pre"><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </font></span></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span>}</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span>}</font></div><div><span class="Apple-tab-span" style="white-space:pre"><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </font></span></div><div><font class="Apple-style-span" face="'times new roman',
'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span> static void configureViaXML_File() {</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span> LoggerContext lc = (LoggerContext) LoggerFactory.getILoggerFactory();</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span> try {</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span> JoranConfigurator configurator = new JoranConfigurator();</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span>
configurator.setContext(lc);</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span> lc.stop();</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span> URL url = Loader.getResourceBySelfClassLoader("com/test/DBlogback.xml");</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span> configurator.doConfigure(url);</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span> } catch (JoranException je) {</font></div><div><font class="Apple-style-span" face="'times new
roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span> StatusPrinter.print(lc);</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span> }</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><span class="Apple-tab-span" style="white-space:pre"> </span> }</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">}</font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">----------------------------------------------------------------------------------------------</font></div></div><div style="color: black; font-family: 'times new roman',
'new york', times, serif; font-size: 12pt; "><br></div><div style="position: fixed; color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "></div>
</div><br>
</body></html>