log4j写入日志到oracle数据库老找不到数据库驱动。。。

Question

可能是 driver 的问题 换成oracle.jdbc.OracleDriver

Answer 1

用属性文件的我没试过.我是通过配置logj4.xml文件就试过.我把我做过的例子给你看看是否能帮助你.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
<appender name="_Console"
class="org.apache.log4j.ConsoleAppender">
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern"
value="elapsed[%r]ms [%t] %-5p %l - %m\n" />
</layout>
</appender>

<!-- <appender name="db" class="org.apache.log4j.jdbc.JDBCAppender">
<param name="URL"
value="jdbc:oracle:thin:@192.168.24.75:1521:gwzf2" />
<param name="BufferSize" value="1" />
<param name="driver" value="oracle.jdbc.driver.OracleDriver" />
<param name="user" value="company" />
<param name="password" value="333" />
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern"
value="insert into SYS_LOG_OPER (USERLOG_KEY, RFU_KEY_ID, USER_GH, OPER_TYPE_DESC, OPER_OBJECT, REQUESTTIME, OPER_REUSELT, LOG_ANALYSE, SESSIONID, USERIP, DETAIL_WEB_PATH) values (SEQ_SYS_LOG_OPER.nextval,%m)" />
</layout>
</appender>

-->

<appender name="db" class="com.cursaero.core.utils.JDBCExtAppender">
<param name="URL"
value="jdbc:mysql://192.168.24.81:3306/cursaero" />
<param name="BufferSize" value="1" />
<param name="driver" value="com.mysql.jdbc.Driver" />
<param name="user" value="root" />
<param name="password" value="123456" />
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern"
value="insert into SYS_LOG_OPER (USERLOG_KEY, RFU_KEY_ID, USER_GH, OPER_TYPE_DESC, OPER_OBJECT, REQUESTTIME, OPER_REUSELT, LOG_ANALYSE, SESSIONID, USERIP, DETAIL_WEB_PATH) values (uuid(),%m)" />
</layout>
</appender>

<logger name="org.springframework" additivity="false">
<level value="error" />
<appender-ref ref="_Console" />
</logger> <logger name="org.apache.catalina" additivity="false">
<level value="error" />
<appender-ref ref="_Console" />
</logger>
<logger name="org.hibernate" additivity="false">
<level value="info" />
<appender-ref ref="_Console" />
</logger> <logger name="org.apache.struts2" additivity="false">
<level value="error" />
<appender-ref ref="_Console" />
</logger> <logger name="com.opensymphony.xwork2" additivity="false">
<level value="error" />
<appender-ref ref="_Console" />
</logger> <logger name="org.quartz" additivity="false">
<level value="error" />
<appender-ref ref="_Console" />
</logger>
<logger name="javax.mail" additivity="false">
<level value="debug" />
<appender-ref ref="_Console" />
</logger>
<logger name="java.net" additivity="false">
<level value="debug" />
<appender-ref ref="_Console" />
</logger> <logger name="com.cursaero" additivity="false">
<level value="debug" />
<appender-ref ref="_Console" />
</logger>

<logger name="business" additivity="true">
<level value="debug" />
<appender-ref ref="db" />
</logger>


<root>
<level value="info" />
<appender-ref ref="_Console" />
</root>
</log4j:configuration>