Hi,
I am using below configurations. I am getting stack trace for my console
appender, where as staketrace is null in my jdbc appender. 
I am not sure what the issue with jdbc appender is.  All my other fields
are getting logged properly in the oracle database except the stack
trace. I tried both clob and varchar2 fields in oracle to store stack
trace.

Please help.

Log4j.xml 

   <appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
      <errorHandler
class="org.jboss.logging.util.OnlyOnceErrorHandler"/>
      <param name="Target" value="System.out"/>
      <layout class="org.apache.log4j.PatternLayout">
         <param name="ConversionPattern" value="%d{ABSOLUTE} %-5p %C -
[%c{1}] - %F %m; %n"/>
      </layout>
   </appender>

    <appender name="jdbcAppender"
class="org.apache.log4j.jdbc.JDBCAppender">
        <param name="Threshold" value="ERROR"/>
        <param name="URL" value="jdbc:oracle:thin:@polaris:1521:dptrx"/>
        <param name="Driver" value="oracle.jdbc.driver.OracleDriver" />
        <param name="User" value="weblogicuser20"/>
        <param name="Password" value="hmi"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="INSERT INTO ERROR_LOG
(TRACKING_ID, LOG_LEVEL, PROCESS_NAME,METHOD_NAME,
USER_ERROR_MSG,SYSTEM_ERROR_MSG,ERROR_DATE) VALUES
(hmi20.TRACKING_ID_SEQ.nextval, '%p', '%C','%M() at line#: %L',
'%m','%m; %n', sysdate)" />
        </layout>
    </appender>

Reply via email to