oracle - JDBCAppended not working -
i trying use jdbcappender
logging log4j
messages. log not getting published in db though there aren't exceptions. how trace down problem? here example log4j
entry:
`<appender name="db" class="org.apache.log4j.jdbc.jdbcappender"> <param name="url" value="jdbc:oracle:thin:@rsasitdb.corp.unifirst.com:1522:rsasit"/> <param name="driver" value="oracle.jdbc.oracledriver"/> <param name="user" value="rsa"/> <param name="password" value="rsa"/> <param name="sql" value="insert logs values('%x','%d','%c','%p','%m')"/> <!-- <layout class="org.apache.log4j.patternlayout"> <param name="conversionpattern" value="insert logging_samples_test (log_date, log_level, location, message) values ( '%d{iso8601}','%p', '%c;%l', '%m' )" /> </layout> --> <layout class="org.apache.log4j.patternlayout"></layout> </appender> ------------------ <logger name="log4j.rootlogger" additivity="false"> <level value="debug"/> <appender-ref ref="db"/> </logger>`
Comments
Post a Comment