[logback-user] About DBAppender

28 Feb 2010

      Hi,

I am new in Logback framework. I want to use mysql database to store my log.
So I have set my logback-test.xml file in the following way:

<?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>com.mysql.jdbc.Driver</driverClass>
        <url>jdbc:mysql://localhost:3306/testlogback</url>
        <user>root</user>
        <password>test</password>
    </connectionSource>
  </appender>

  <root level="debug">
    <appender-ref ref="DB" />
  </root>
</configuration>

After that I created a database which is called "testlogback".

I have two simple java classes. The code snippet is:
 public class TestLogger { public static void main(String[] args){

Logger logger = LoggerFactory.getLogger("com.lashpoint.TestLogger");
LoggerContext lc=(LoggerContext) LoggerFactory.getILoggerFactory();
StatusPrinter.print(lc);

logger.debug("Test start");
System.out.println("Hello World Logback");
SalaryTestLogger test=new SalaryTestLogger ();
test.setHour(0);
test.setSalary(100);
System.out.println("Division: "+test.getSalary());
logger.debug("Test end");
      }
}

public class SalaryTestLogger {

............................
        public SalaryTestLogger(){
logger=LoggerFactory.getLogger("com.lashpoint.SalaryTestLogger ");
}
................
..........................

}

After running the code, I got the following output (However, I put
StatusPrinter.print(lc) to see internal state).

Driver name=MySQL-AB JDBC Driver
Driver version=mysql-connector-java-5.0.7 ( $Date: 2007-03-09 22:13:57 +0100
(Fri, 09 Mar 2007) $, $Revision: 6341 $ )
supportsGetGeneratedKeys=true
true
12:08:37,312 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found
resource [logback-test.xml] at
[file:/E:/DevTools/projects/Test/LogbackTest/src/com/lashpoint/logger/logback-test.xml]
12:08:37,421 |-INFO in
ch.qos.logback.classic.joran.action.ConfigurationAction - debug attribute
not set
12:08:37,421 |-INFO in ch.qos.logback.core.joran.action.AppenderAction -
About to instantiate appender of type [ch.qos.logback.classic.db.DBAppender]
12:08:37,437 |-INFO in ch.qos.logback.core.joran.action.AppenderAction -
Naming appender as [DB]
12:08:37,468 |-INFO in
ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Pushing component
[connectionSource] on top of the object stack.
12:08:37,812 |-INFO in ch.qos.logback.core.joran.action.AppenderAction -
Popping appender named [DB] from the object stack
12:08:37,812 |-INFO in ch.qos.logback.classic.joran.action.RootLoggerAction
- Setting level of ROOT logger to DEBUG
12:08:37,812 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction -
Attaching appender named [DB] to Logger[ROOT]

Hello World Logback
Salry Per Hour: 0.0

The MOST INTERESTING THING is that, it did not log anything to
logging_event, logging_event_exception, logging_event_property tables.

So I think I am missing something. I would be glad if someone kindly help me
to solve this issue.

-- 
Thanks
 Mohammad Firoj Haider