JDBCAppender

[Simonebernardi <s....@4it.it>]

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: log4j-user-unsubscribe@logging.apache.org
For additional commands, e-mail: log4j-user-help@logging.apache.org