Log4j data not inserting database....Log4j & Mysql

[ysuneelreddy]

Hi .

 

I wrote log4j.xml as like..

 

<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="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/smartedb"/>

      </connectionSource>

</appender>

<root>

    <priority value="info"/>

    <appender-ref ref="A1"/>

</root>

</log4j:configuration>

 

In database line number, file name, class name. Method fields r not
inserting.

And also in those fields "?" symbol is inserting.

"Logging_evevnt_property" in this table nothing inserted.

 

We r using JDBC3.0..

Plz give me some solution.

 

 

Thanks & Rgds,

 

Yaramaka SuneelReddy.

Software Engineer,

Smarte Solutions,

ph : + 91 9833022044