problem in using log4j JDBCAppender

[Raghavendra Rao]

Hi all!
i have placed the classes111 and classes12.jar files in web-inf/lib folder and used a servlet which reads this properties file and log the statement to database.i am not able to log the statements in to the database ....i have use the following properties file:
log4j.appender.R=org.apache.log4j.jdbc.JDBCAppender
log4j.rootLogger=debug, R
log4j.appender.R.Driver=oracle.jdbc.driver.OracleDriver
log4j.appender.R.URL = jdbc racle:[email protected]:1521:itsr
log4j.appender.R.user=hpabopa1
log4j.appender.R.password=hpa
log4j.appender.R.sql=INSERT INTO jdbctest(message) VALUES ('%d - %c - %p - %m')
#
# These defines the layout to be used.
#
log4j.appender.R.layout=org.apache.log4j.PatternLayout
can anyonle please help me....

thanks in advance..

[Paul Stevens]

Moving to Other Open Source Projects forum.

[Karthik Guru]

what is the error / you dont see anything at all?.
log4j.properties is located in the web-inf/classes folder?

[Karthik Guru]

Why dont u write a simple test.jsp that retreives the logger and just
prints something to the table.
Yes log4j.jar and classes12.zip s'd be in web-inf/lib folder
Put log4j.properties in web-inf/classes folder.
Just invoke the test jsp.
If you are using tomcat and if something is wrong you s'd see an error displayed on tomcat console.
We might be able to help after taking a look at the error.

<%@page import="org.apache.log4j.Logger"%>
<%
Logger logger = Logger.getLogger(this.getClass().getName());%>
if (logger.isDebugEnabled()){
    out.println("yes");
}else{
    out.println("no");
}
logger.debug(" Testing jdbc appender!! ");
out.println("Done");
%>

[David Yutzy]

I'm trying the same thing, here is what I have thus far, the code, exceptions, etc.
Using: Tomcat: v4.1.29; log4j v1.2.7
log4j.properties

log4j.rootLogger=debug, R
log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
log4j.appender.R.URL=jdbc:microsoft:sqlserver://test:1433;SelectMethod=cursor;DatabaseName=Log4J
log4j.appender.R.user=web
log4j.appender.R.password=web
log4j.appender.R.sql=INSERT INTO Log4J ([Date], Logger, Priority, Message) VALUES ('%d', '%c', '%p', '%m')

I get the collowing exception when Tomcat starts up:

log4j:ERROR Failed to excute sql
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.apache.log4j.jdbc.JDBCAppender.getConnection(JDBCAppender.java:197)
at org.apache.log4j.jdbc.JDBCAppender.execute(JDBCAppender.java:160)
at org.apache.log4j.jdbc.JDBCAppender.flushBuffer(JDBCAppender.java:235)
at org.apache.log4j.jdbc.JDBCAppender.append(JDBCAppender.java:131)
at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:221)
at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:57)
at org.apache.log4j.Category.callAppenders(Category.java:187)
at org.apache.log4j.Category.forcedLog(Category.java:372)
at org.apache.log4j.Category.log(Category.java:864)
at org.apache.commons.logging.impl.Log4JLogger.info(Log4JLogger.java:152)
at org.apache.struts.util.PropertyMessageResources.<init>(PropertyMessageResources.java:127)
at org.apache.struts.util.PropertyMessageResourcesFactory.createResources(PropertyMessageResourcesFactory.java:90)
at org.apache.struts.util.MessageResources.getMessageResources(MessageResources.java:577)
at org.apache.struts.util.RequestUtils.<clinit>(RequestUtils.java:134)
at org.apache.struts.util.MessageResourcesFactory.createFactory(MessageResourcesFactory.java:192)
at org.apache.struts.util.MessageResources.getMessageResources(MessageResources.java:576)
at org.apache.struts.action.ActionServlet.initInternal(ActionServlet.java:1329)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:464)
at javax.servlet.GenericServlet.init(GenericServlet.java:256)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:935)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3422)
at org.apache.catalina.core.StandardContext.reload(StandardContext.java:2569)
at org.apache.catalina.loader.WebappLoader$WebappContextNotifier.run(WebappLoader.java:1369)
at java.lang.Thread.run(Thread.java:534)

[Karthik Guru]

Originally posted by David Yutzy:
I'm trying the same thing, here is what I have thus far, the code, exceptions, etc.

And you have the jar file that contains the driver class in web-inf/lib folder?
I guess you must be having log4j.jar there alogn with other required libraries. (I dont know the SQL Server database driver name)

[David Yutzy]

Yes, I can use SQL Server in the web application just fine.
One thing I notice is that it appears to be loading the log4j settings during the Tomcat start-up rather than the WebApp start-up process.
When I set Log4J to debug to the console, I usually get the Tomcat stuff scroll by, then it loads the webapp stuff, showing it in debug mode.
When I change it to the DB version of log4j.properties, I see about 3 lines of Tomcat, then the exception I previously posted, then it loads the webapp.
I wonder if I placed the DB .jar driver files in the Tomcat/lib if that would make a difference?

[Rahul N Bhardwaj]

hi all,
i m tryng to use log4j to insert the data into database. i want to insert the SQLs into the database so that we can check them in case of any error. can anyone pl. tell me how to go about it. i m new to log4j, so need help.
pl. mail me at [email protected]
thnx
Rahul N B