configuration of DBAppender with Log4j....

[ysuneelreddy]

Hi 

This is suneel

Iam new to Log4j, we r using Log4j-1.3alpha-8 // Net Beans (Tomcat) // MySQL

My target is inserting log messages in the database.

For this I want to use DbAppender'.

For this I download the Log1.3alpha-8.jar, log4j-db-1.3alpha-8.jar.

 

I wrote log4j.xml in this way.

 

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE configuration >

 

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

   <plugin name="Appender" class="org.apache.log4j.db.DBAppender"> 

      <connection Source
class="org.apache.log4j.db.DriverManagerConnectionSource"> 

        <param name="password" value="smarte911"/>

        <param name="user" value="smarte2"/>

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

        <param name="url" value="jdbc:mysql://192.168.1.225:3306/reddy"/> 

      </connectionSource>

    </plugin>

 

   <root>

      <level value="debug"/>

   </root>

</log4j:configuration>

 

Just I did 

After I put .jar in lib && tomcat/commons/class..

It is not working

Plz tell me ..

For this what I do.

Iam waiting for ur reply.

 

Thanks & Rgds,

 

Yaramaka SuneelReddy.

Software Engineer,

Smarte Solutions,

ph : + 91 9833022044