Mailing-List: contact log4j-user-help@logging.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Log4J Users List" <log4j-user@logging.apache.org>
Received-SPF: pass (athena.apache.org: domain of hoju@visi.com designates
 208.42.176.221 as permitted sender)
From: "Jacob Kjome" <hoju@visi.com>
Subject: Re: JDBCAppender and DB passwords
To: "Log4J Users List" <log4j-user@logging.apache.org>
Date: Wed, 02 Apr 2008 11:13:11 -0500
Message-ID: <web-8896643@mailback2.g2host.com>
In-Reply-To: <cabc69610804020537k416396bfpbe6091abd0233e12@mail.gmail.com>
References: <cabc69610804020537k416396bfpbe6091abd0233e12@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1;format="flowed"
Content-Transfer-Encoding: 8bit


There's a couple ways.  Both involve referencing variables set externally. 
 For instance...

${db.username}
${db.password)

You can make these variables available in one of two ways (only the first way 
below if you are using XML config)....

1.  Set it as a system property.  e.g...  java -Ddb.username=[username] 
-Ddb.password=[password]

2.  You can manually configure using the PropertyConfigurator and pass in 
variables prior to calling configure() (can't recall the exact API to do this 
at the moment, but you can look it up).


I have't worked with the JDBCAppender much.  I wonder if you couldn't just 
give it a JNDI name of the DataSource it is supposed to use?  In that case, 
the above would be unnecessary.

Jake


On Wed, 2 Apr 2008 23:37:27 +1100
  "Annie Lane" <annielaney@gmail.com> wrote:
> Hi list,
> 
> I'm using log4j-1.2.14 and want to play with JDBCAppender. My main concern
> is the fact that in my log4j.properties file I need to provide the username
> and password details for the database connection.
> 
> How can I use JDBCAppender without having to put this information in my
> .properties file?
> 
> Additionally, how might I inject a database connection from within my
> application? Say I'm developing a JEE app which contains its own connection
> pooling mechanisms etc.
> 
> Any help/advice would be very much appreciated.
> 
> Annie


---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-user-unsubscribe@logging.apache.org
For additional commands, e-mail: log4j-user-help@logging.apache.org