Hi
Iam working on log4j…
My log messages data not inserting in database, Logging_event_exception table…
We r using jdbc3.0.
Iam struggling witht his problem…
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…
Plz help me…
Thanks & Rgds,
Suneel
