How to use log4j.jdbcplus.JDBCAppender in log4j.xml

[Marcelo Tataje]

Can somebody please help me with an example?
My log4j.xml works in netbeans, and it saves everything in the files, but I'm unable to store the log data in the table I created on MySQL Database.
<?xml version="1.0" encoding="UTF-8"?> <!-- Document : log4j.xml.xml Created on : 7 de marzo de 2011, 11:45 AM Author : marcelo Description: Enable Log4j Configuration. --> <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd"> <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"> <!-- For console Logging--> <appender name="CSL" class="org.apache.log4j.ConsoleAppender"> <layout class="org.apache.log4j.PatternLayout"> <param name="ConversionPattern" value="%p - %C{1}.%M(%L) | %m%n"/> </layout> </appender> <!-- For XML Logging--> <appender name="XML" class="org.apache.log4j.DailyRollingFileAppender"> <param name="File" value="/home/marcelo/logfile.xml"/> <param name="DatePattern" value="'.'yyyy-MM-dd"/> <param name="Append" value="true"/> <param name="Threshold" value="debug"/> <layout class="com.alfa1lab.logger.util.CustomizedXMLLayout" /> </appender> <!-- For Database Logging--> <appender name="DB" class="org.apache.log4j.jdbcplus.JDBCAppender"> <param name="url" value="jdbc:mysql://localhost:3306/peppol"/> <param name="dbclass" value="com.mysql.jdbc.Driver"/> <param name="username" value="root"/> <param name="password" value="mysql"/> <param name="buffer" value="1" /> <param name="commit" value="true" /> <param name="sql" value="insert into peppol.logs values('@INC@', cast ('@LAYOUT:3@' as date),'@CAT@','@PRIO@','@MSG@')"/> <layout class="org.apache.log4j.PatternLayout"> <param name="ConversionPattern" value="%d - %c -%-4r [%t] %-5p %c %x - %m%n "/> </layout> </appender> <!-- For single File Logging--> <appender name="FLE" class="org.apache.log4j.RollingFileAppender"> <param name="file" value="/home/marcelo/singlelogfile.log"/> <param name="DatePattern" value="'.'yyyy-MM-dd"/> <param name="MaxFileSize" value="80kb" /> <layout class="org.apache.log4j.PatternLayout"> <param name="ConversionPattern" value="%d{yyyy-MMM-dd HH:mm:ss,SSS} [%t] %c %x%n %-5p %m%n"/> </layout> </appender> <!-- Here we set the packages in which logs will be implemented --> <logger name="com.alfa1lab.logger"> <appender-ref ref = "CSL" /> <appender-ref ref = "DB" /> <appender-ref ref = "XML" /> <appender-ref ref = "FLE" /> </logger> <root> <appender-ref ref="CSL" /> </root> </log4j:configuration>