Hello,
I am trying to use the log4j
JDBC appender with mySQL. I am getting below error message:
log4j:ERROR Could not create an Appender. Reported error follows.
java.lang.ClassNotFoundException: org.apache.log4j.jdbcplus.JDBCAppender
at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClass
Loader.java:199)
at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClass
Loader.java:224)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
I have put the log4j jar file in the classpath. My log4j configuration is as below:
<appender name="JDBC" class="org.apache.log4j.jdbcplus.JDBCAppender">
<param name="url" value="jdbc:mysql://localhost:3306/mysql" />
<param name="username" value="root" />
<param name="password" value="root" />
<param name="sql" value="INSERT INTO LOGTEST (id, prio, cat,
thread, msg) VALUES (@INC@, '@PRIO@', '@CAT@', '@THREAD@', '@MSG@')" />
<param name="buffer" value="1" />
<param name="commit" value="true" />
<param name="dbclass" value="com.mysql.jdbc.Driver" />
<param name="quoteReplace" value="true" />
<param name="throwableMaxChars" value="3000" />
<param name="layoutPartsDelimiter" value="#-#" />
<layout class="org.apache.log4j.PatternLayout">
<!-- conversion
pattern with 4 parts separated by #-#, second part is empty -->
<param name="ConversionPattern" value="[%t] %m#-##-#%d{dd.MM.yyyy}#-#%d{HH:mm:ss}" />
</layout>
</appender>
<root>
<!--<appender-ref ref="def"/>-->
<!--<appender-ref ref="RollingFile" />-->
<appender-ref ref="JDBC" />
</root>
Can someone please help me out what am I doing wrong?
Thanks,
Trupti