Return-Path: 
 <log4j-user-return-12704-apmail-logging-log4j-user-archive=logging.apache.org@logging.apache.org>
Delivered-To: apmail-logging-log4j-user-archive@www.apache.org
Received: (qmail 48280 invoked from network); 11 May 2004 18:13:07 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 11 May 2004 18:13:07 -0000
Received: (qmail 69399 invoked by uid 500); 11 May 2004 18:07:38 -0000
Delivered-To: apmail-logging-log4j-user-archive@logging.apache.org
Received: (qmail 69275 invoked by uid 500); 11 May 2004 18:07:37 -0000
Mailing-List: contact log4j-user-help@logging.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:log4j-user-unsubscribe@logging.apache.org>
List-Subscribe: <mailto:log4j-user-subscribe@logging.apache.org>
List-Help: <mailto:log4j-user-help@logging.apache.org>
List-Post: <mailto:log4j-user@logging.apache.org>
List-Id: "Log4J Users List" <log4j-user.logging.apache.org>
Reply-To: "Log4J Users List" <log4j-user@logging.apache.org>
Delivered-To: mailing list log4j-user@logging.apache.org
Received: (qmail 69251 invoked by uid 500); 11 May 2004 18:07:37 -0000
Received: (qmail 69224 invoked by uid 98); 11 May 2004 18:07:37 -0000
Received: from jstauffe@spscommerce.com by hermes.apache.org by uid 82 with
 qmail-scanner-1.20
 (clamuko: 0.70.  Clear:RC:0(12.47.34.254):.
 Processed in 0.118764 secs); 11 May 2004 18:07:37 -0000
X-Qmail-Scanner-Mail-From: jstauffe@spscommerce.com via hermes.apache.org
X-Qmail-Scanner: 1.20 (Clear:RC:0(12.47.34.254):. Processed in 0.118764 secs)
Received: from unknown (HELO int1.stp.spscommerce.net) (12.47.34.254)
  by hermes.apache.org with SMTP; 11 May 2004 18:07:36 -0000
Received: from spsc-exchange.spscommerce.com
 (spsc-exchange.stp.spscommerce.net [172.16.0.7])
	by int1.stp.spscommerce.net (Postfix) with ESMTP id 8091FCBFF2
	for <log4j-user@jakarta.apache.org>; Tue, 11 May 2004 13:04:48 -0500 (CDT)
Received: by spsc-exchange.spscommerce.com with Internet Mail Service
 (5.5.2657.72)
	id <J3AWQFHR>; Tue, 11 May 2004 13:04:48 -0500
Message-ID: 
 <E1D90F95144AC94C9B810A0D5B3CF57107D42D@spsc-exchange.spscommerce.com>
From: James Stauffer <jstauffe@spscommerce.com>
To: "'log4j-user@jakarta.apache.org'" <log4j-user@jakarta.apache.org>
Subject: DBAppender cannot function without a connection source
Date: Tue, 11 May 2004 13:04:47 -0500
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2657.72)
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C43782.7225DB3A"
X-Spam-Rating: hermes.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

------_=_NextPart_001_01C43782.7225DB3A
Content-Type: text/plain

I am trying out the new DBAppender but I apparently don't know how to
configure it.  Can someone provide an example?  I searched the code for
DBAppender and ConnectionSource to try to find examples but I couldn't find
any.  My config and error are below.

	<appender name="JDBC3" class="org.apache.log4j.db.DBAppender">
		<param name="url"
value="jdbc:oracle:thin:@goofy:1521:dwebec" />
		<param name="username" value="jamess" /> 
		<param name="password" value="123" />
	</appender>

log4j:WARN No such property [url] in org.apache.log4j.db.DBAppender.
log4j:WARN No such property [username] in org.apache.log4j.db.DBAppender.
log4j:WARN No such property [password] in org.apache.log4j.db.DBAppender.
log4j:ERROR Could not create an Appender. Reported error follows.
java.lang.IllegalStateException: DBAppender cannot function without a
connection source
	at
org.apache.log4j.db.DBAppender.activateOptions(DBAppender.java:49)
	at
org.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:228)
	at
org.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.java
:154)
	at
org.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurator
.java:169)
	at
org.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfigu
rator.java:514)
	at
org.apache.log4j.xml.DOMConfigurator.parseCategory(DOMConfigurator.java:475)
	at
org.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:876)
	at
org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:768)
	at
org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:717)
	at
org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:685)
	at
org.apache.log4j.xml.XMLWatchdog.doOnChange(DOMConfigurator.java:915)
	at
org.apache.log4j.helpers.FileWatchdog.checkAndConfigure(FileWatchdog.java:80
)
	at
org.apache.log4j.helpers.FileWatchdog.<init>(FileWatchdog.java:49)
	at org.apache.log4j.xml.XMLWatchdog.<init>(DOMConfigurator.java:908)
	at
org.apache.log4j.xml.DOMConfigurator.configureAndWatch(DOMConfigurator.java:
675)
	at
org.apache.log4j.xml.DOMConfigurator.configureAndWatch(DOMConfigurator.java:
660)
...(my code)


James Stauffer

------_=_NextPart_001_01C43782.7225DB3A--