How can I tell if Derby is using my derby.properties file or not?

[Bryan Pendleton <bp...@amberpoint.com>]

Sorry, rank beginner question here: I've placed a
derby.properties file into the directory that (I think)
is my derby.system.home directory, and I'm trying to tell
whether derby is in fact using my properties or not.

Does Derby write any special sort of messages to
derby.log upon reading my derby.properties file? Or is
there some other way that I can verify that the desired
properties have been read?

thanks,

bryan

Re: How can I tell if Derby is using my derby.properties file or not?

[Rajesh Kartha <ka...@Source-Zone.Org>]

Bryan Pendleton wrote:

> Sorry, rank beginner question here: I've placed a
> derby.properties file into the directory that (I think)
> is my derby.system.home directory, and I'm trying to tell
> whether derby is in fact using my properties or not.
>
> Does Derby write any special sort of messages to
> derby.log upon reading my derby.properties file? Or is
> there some other way that I can verify that the desired
> properties have been read?
>
> thanks,
>
> bryan
>
The derby.log does not show any special messages about the 
derby.properties being read .As long as the derby.system.home is 
pointing to the correct location
that has the derby.properties file, it will be read.

See:

http://db.apache.org/derby/docs/10.0/manuals/tuning/perf14.html
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0408bradbury/

One simple way to check is to add some debug properties to the 
derby.properties file and see if they are
reflected in the derby.log.

Example: To log all executed statements to the log file:

derby.language.logStatementText=true

-Rajesh