I haven't used UrlConnectionSource, but I use DriverManagerConnectionSource
with CustomSQLDBReceiver.
Here's my receiver config. You may want to try copying this example's
connectionsource section into your config & changing the appropriate info.
<plugin name="MyDBReceiver" class="org.apache.log4j.db.CustomSQLDBReceiver">
<param name="sql" value="SELECT logger AS 'LOGGER', event_time AS
'TIMESTAMP', log_level AS 'LEVEL', thread AS 'THREAD', message AS 'MESSAGE', ''
AS 'NDC', '' AS 'MDC', 'class_name' AS 'CLASS', method AS 'METHOD', file_name
AS 'FILE', line AS 'LINE', '{{application,' + app_name + ',hostname,' +
machine_name + ',log4jid,' + CAST(counter AS varchar(255)) + '}}' AS
'PROPERTIES', '' AS 'EXCEPTION' FROM log_event"/>
<connectionSource
class="org.apache.log4j.db.DriverManagerConnectionSource">
<param name="password" value="XXXXX"/>
<param name="user" value="YYYYY"/>
<param name="driverClass"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<param name="url"
value="jdbc:microsoft:sqlserver://ZZZZZ:1433;DatabaseName=AAAAAA"/>
</connectionSource>
<param name="IDField" value="counter"/>
<param name="refreshMillis" value="3000"/>
</plugin>
-----Original Message-----
From: Darren Hartford [mailto:[EMAIL PROTECTED]
Sent: Wed 4/20/2005 9:04 AM
To: Log4J Users List
Cc:
Subject: Chainsaw V2 config file for DBAppender
Hey all,
Trying to use Chainsaw via configuration file as recommended for use
with the DBAppender. My configuration file loaded with Chainsaw looks
like this:
==========================
<?xml version="1.0" encoding="UTF-8" ?>
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/";
debug="false">
<plugin name="DBReceiver1" class="org.apache.log4j.db.DBReceiver">
<connectionSource
class="org.apache.log4j.db.UrlConnectionSource">
<param name="driverClass" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://<server>/<db>"/>
<param name="user" value="<snip>"/>
</connectionSource>
</plugin>
<root>
<level value="debug"/>
</root>
</log4j:configuration>
===========================
I have Log4j1.3alpha-6 currently logging to a database, and I see the
data. However, when I load up Chainsaw V2 and use this configuration
file nothing happens. The console reports the following errors when
attempting to load the above configuration file:
===================
log4j:INFO Creating new logger
[org.apache.log4j.joran.action.ConfigurationAction] in repository
[default].
3203 [Thread-7] ERROR org.apache.log4j.varia.ListAppender - Attempted to
log with inactive appender named [TEMP_LIST_APP
ENDER].
log4j:INFO Creating new logger
[org.apache.log4j.joran.action.PluginAction] in repository [default].
3219 [Thread-7] ERROR org.apache.log4j.varia.ListAppender - Attempted to
log with inactive appender named [TEMP_LIST_APP
ENDER].
log4j:INFO Creating new logger
[org.apache.log4j.helpers.OptionConverter] in repository [default].
3219 [Thread-7] ERROR org.apache.log4j.varia.ListAppender - Attempted to
log with inactive appender named [TEMP_LIST_APP
ENDER].
log4j:INFO Creating new logger [org.apache.log4j.joran.spi.Interpreter]
in repository [default].
log4j:INFO Creating new logger
[org.apache.log4j.joran.action.ParamAction] in repository [default].
3234 [Thread-7] WARN org.apache.log4j.config.PropertySetter - No such
property [driverClass] in org.apache.log4j.Hierarc
hy.
3234 [Thread-7] WARN org.apache.log4j.config.PropertySetter - No such
property [url] in org.apache.log4j.Hierarchy.
3234 [Thread-7] WARN org.apache.log4j.config.PropertySetter - No such
property [user] in org.apache.log4j.Hierarchy.
log4j:INFO Creating new logger
[org.apache.log4j.joran.action.AppenderAction] in repository [default].
log4j:INFO Returning existing logger
[org.apache.log4j.helpers.OptionConverter] in repository [default].
log4j:INFO Returning existing logger
[org.apache.log4j.joran.spi.Interpreter] in repository [default].
==================
Any ideas please? I really would like to prove that DB logging and
Chainsaw as a viewing tool is a real solution. Thanks,
-D
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
