The traceFile=path attribute specifies a file to which the Derby Network Client will send JDBC trace information.
If you do not specify an absolute path name, the file is placed in the derby.system.home directory (see "Defining the system directory" in the Derby Developer's Guide for details).
If you specify both traceFile=path and traceFileAppend=true, the output is appended to the specified file, if it exists. If you specify traceFile=path but do not specify traceFileAppend=true, any previous version of the file of the file is overwritten.
For more information about tracing, see "Network client tracing" in the Derby Server and Administration Guide. See traceDirectory=path and traceLevel=value for other attributes related to tracing.
You can combine this attribute with other attributes.
-- enable tracing on a new database jdbc:derby://localhost:1527/mydb;create=true;traceFile=trace.out