Have you attached the appender to any logger? Heri > -----Original Message----- > From: Simonebernardi [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 08, 2008 12:12 PM > To: log4j-user@logging.apache.org > Subject: [SPAM (DNS Blacklist)] - JDBCAppender - Sending mail server > found on list.dsbl.org > > > Hi all, > > I have a problem with JDBCAppender. I wrote a configuration file, but > the table does not write anything and not give me any errors. why? > > <appender name="JDBC" class="org.apache.log4j.jdbc.JDBCAppender"> > <param name="url" > value="jdbc:mysql://localhost:3306/sicve_uel1"/> > <param name="dbclass" value="com.mysql.jdbc.Driver"/> > <param name="username" value="sicve"/> > <param name="password" value="sicve"/> > <param name="sql" value="INSERT INTO logtest (id, prio, > cat, thread, msg, layout_msg, throwable, ndc, mdc, mdc2, info, > addon, the_date, the_time, the_timestamp, created_by) > VALUES (@INC@, '@PRIO@', '@CAT@', '@THREAD@', '@MSG@', '@LAYOUT:1@', > '@THROWABLE@', '@NDC@', '@MDC:MyMDC@', '@MDC:MyMDC2@', > 'info timestamp: @TIMESTAMP@', 'addon', > cast ('@LAYOUT:3@' as date), cast ('@LAYOUT:4@' > as time), > cast ('@LAYOUT:3@ @LAYOUT:4@' as timestamp), 'me')"/> > <param name="buffer" value="1"/> > <param name="commit" value="true"/> > <param name="quoteReplace" value="true"/> > <param name="throwableMaxChars" value="3000"/> > <param name="layoutPartsDelimiter" value="#-#"/> > <layout class="org.apache.log4j.PatternLayout"> > <param name="ConversionPattern" value="[%t] > %m#-##-#%d{dd.MM.yyyy}#-#%d{HH:mm:ss}"/> > </layout> > > > </appender> > > > Thank you > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
