You are viewing a plain text version of this content. The canonical link for it is here.
Posted to log4j-user@logging.apache.org by Amandeep Midha <Am...@itsprojects.com> on 2003/01/24 21:03:49 UTC
Please
Can you send me sample xml to configure JDBC appender?
thanks in advance
regards,
Amandeep
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Please
Posted by Rich Bagley <rb...@hbs.edu>.
This works in log4j.1.2.7
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
<appender name="jdbcAppender"
class="org.apache.log4j.jdbc.JDBCAppender">
<param name="URL" value="jdbc:oracle:thin:@sd1.hbs.edu:1521:sc1" />
<param name="Driver" value="oracle.jdbc.driver.OracleDriver" />
<param name="User" value="user" />
<param name="Password" value="password" />
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern"
value="INSERT INTO LOGGING_SAMPLES_TEST (log_date,
log_level, location, message) VALUES ( '%d{ISO8601}','%p', '%C;%L', '%m' )"
/>
</layout>
</appender>
<appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern"
value="%d{ISO8601} %p (%C;%L) %m%n"/>
</layout>
</appender>
<logger name="logging.simple.jdbcLogger">
<level value="debug"/>
<appender-ref ref="jdbcAppender"/>
</logger>
<root>
<priority value="error"/>
<appender-ref ref="STDOUT"/>
</root>
</log4j:configuration>
>> -----Original Message-----
>> From: Amandeep Midha [mailto:Amandeep.Midha@itsprojects.com]
>> Sent: Friday, January 24, 2003 3:04 PM
>> To: log4j-user@jakarta.apache.org
>> Subject: Please
>>
>>
>>
>> Can you send me sample xml to configure JDBC appender?
>>
>> thanks in advance
>>
>> regards,
>> Amandeep
>>
>>
>> --
>> To unsubscribe, e-mail:
>> <ma...@jakarta.apache.org>
>> For additional commands, e-mail:
>> <ma...@jakarta.apache.org>
>>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>