[James Wiki] Update of "FrequentlyAskedQuestions" by RobertBurrellDonkin

[Apache Wiki <wi...@apache.org>]

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "James Wiki" for change notification.

The following page has been changed by RobertBurrellDonkin:
http://wiki.apache.org/james/FrequentlyAskedQuestions

The comment on the change is:
Added information about logging SQL using Derby database

New page:
= Frequently Asked Questions =

[[TableOfContents([4])]]

== Questions About The Default Configuration ==

=== Where Is The Derby Log? ===

derby logs to ''derby.log'' in the ''bin'' subdirectory.

=== How Can I Log SQL Statements Using Derby? ===

Modify the Derby configuration file (''derby.properties'' file in the ''bin'' subdirectory). Change ''derby.language.logStatementText'' to ''true''. For example

{{{
derby.language.logStatementText=true
}}}

The results will appear in ''derby.log'' in the ''bin'' subdirectory.

=== How Can I Log Query Plans Using Derby? ===

Modify the Derby configuration file (''derby.properties'' file in the ''bin'' subdirectory). Change ''derby.language.logQueryPlan'' to ''true''. For example

{{{
derby.language.logQueryPlan=true
}}}

The results will appear in ''derby.log'' in the ''bin'' subdirectory.

Note that the output is verbose.

== Configuration ==

=== How Can I Configure Derby? ===

Derby can be configured using the ''derby.properties'' file in the ''bin'' subdirectory. Note that a server restart may be required before the new properties are picked up.