Abgeschickt von Eric am 01 Maerz, 2006 um 23:32:28
Antwort auf: Errors with JDBCColumnHandler von Eric am 01 Maerz, 2006 um 23:10:33:
I forgot to add the log4j configuration
<appender name="JDBCAppender" class="org.apache.log4j.jdbcplus.JDBCAppender">
<param name="url" value="jdbc:oracle:thin:@ken-soradev04:1521:WEBD1" />
<param name="username" value="egravel_liu" />
<param name="password" value="egravel_liu" />
<param name="table" value="APP_LOG" />
<param name="column" value="ID~ORACLE_SEQUENCE~APP_LOG_SEQ" />
<param name="column" value="LOGGER_NAME~CAT" />
<param name="column" value="MESSAGE_LEVEL~IPRIO" />
<param name="column" value="MESSAGE_LEVEL_NAME~PRIO" />
<param name="column" value="TIMESTAMP~TIMESTAMP" />
<param name="column" value="MESSAGE~MSG" />
<param name="column" value="SERVER_ADDRESS~DYNAMIC~com.interval.common.log4j.jdbcplus.ServerAddressColumnHandler" />
<param name="column" value="SERVER_IP~DYNAMIC~com.interval.common.log4j.jdbcplus.ServerIPColumnHandler" />
<param name="column" value="USER_IP~MDC~userIP" />
<param name="column" value="USER_MEMBERSHIP_ID~MDC~memberNo" />
<param name="column" value="USER_SESSION_ID~MDC~sessionID" />
<param name="column" value="THREAD_NAME~THREAD" />
<param name="column" value="EXCEPTION_CLASSNAME~DYNAMIC~com.interval.common.log4j.jdbcplus.ExceptionClassNameColumnHandler" />
<param name="column" value="EXCEPTION_MESSAGE~DYNAMIC~com.interval.common.log4j.jdbcplus.ExceptionMessageColumnHandler" />
<param name="column" value="EXCEPTION_STACKTRACE~THROWABLE" />
<param name="usePreparedStatements" value="true" />
<param name="buffer" value="1" />
<param name="commit" value="true" />
<param name="quoteReplace" value="true" />
<param name="throwableMaxChars" value="-1" />
</appender>
<logger name="com.interval.travelclub.web.controller" additivity="true">
<level value="DEBUG"/>
<appender-ref ref="JDBCAppender" />
</logger>