data not inserting logging_event_exception.....Log4j..

[ysuneelreddy]

 

Hi

Iam working on log4j.

My log messages data not inserting in database, Logging_event_exception
table.

We r using jdbc3.0.

I wrote my log4j.xml in this way..

 

<log4j:configuration  xmlns:log4j="http://jakarta.apache.org/log4j/";>

<appender name="A1"  class="org.apache.log4j.db.DBAppender">

<connectionSource class="org.apache.log4j.db.DriverManagerConnectionSource">

              <param name="driverClass" value="com.mysql.jdbc.Driver" />

              <param name="url"
value="jdbc:mysql://192.168.1.225:3306/smartedb?autoReconnect=true" />

</connectionSource>

<param name="LocationInfo" value ="true" />

</appender>

<root>

    <level value="info"/>

    <appender-ref ref="A1"/>

</root>

</log4j:configuration>

 

For that what can I do...

 

This is my class.

 

package Smarte;

import java.io.*;

import java.util.*;

import javax.servlet.*;

import javax.servlet.http.*;

import org.apache.log4j.*;

import org.apache.log4j.spi.LoggingEvent;

import org.apache.log4j.MDC;

import org.apache.log4j.AppenderSkeleton;

 

public class SmarteLog extends HttpServlet {    

    

   static Logger log = Logger.getLogger("Smarte.SmarteLog"); 

static

{

org.apache.log4j.BasicConfigurator.configure(); 

}

public void doGet(HttpServletRequest req, HttpServletResponse res) throws
ServletException, IOException {

             MDC.put("smarte",req.getRemoteAddr());

              log.debug("This is my debug message.");

            log.info("This is my info message.");

            log.warn("This is my warn message.");

            log.error("This is my error message.");

            log.fatal("This is my fatal message.");

                                    

                                    res.setContentType("text/plain");

                                    PrintWriter out = res.getWriter();

 

                                    out.println(" TEST = " + new
Date().toString());

  }

 

    

}

 

Plz stuffer I want to insert the data in to logging_event_exception.

Iam waiting for ur reply.

 

Thanks & Rgds,

 

Suneel