db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Linehan <lineh...@tcd.ie>
Subject Re: How to log queries in Apache Derby?
Date Mon, 03 Feb 2014 10:45:27 GMT
Hi Bryan, and thanks for your input.


>> I launch derby by issuing the command (from $DERBY_HOME)

> Does it work if you do:
>   java -jar $DERBY_HOME/lib/derbyrun.jar -Dderby.language.logStatementText=true server
start

No, but this does (at least the server starts - fails on the above command)

java -jar -Dderby.language.logStatementText=true
$DERBY_HOME/lib/derbyrun.jar server start

But again, no joy for the log file(s).


> http://db.apache.org/derby/docs/10.10/adminguide/tadminconfigsysteminformation.html

See the output below (end of post) from
linehanp@lg12l9:~/derby/db-derby-10.10.1.1-bin/bin$ NetworkServerControl sysinfo

The output from this caused me to look in my own home directory - but
the only thing
it contains is (just like the others)

------------------------------------------------
linehanp@lg12l9:~$ more derby.log
----------------------------------------------------------------
Sat Jan 25 17:21:38 GMT 2014: Shutting down Derby engine
----------------------------------------------------------------
linehanp@lg12l9:~$
-----------------------------------------------


I'm still at a loss to understand where my logfile with my query is?
As mentioned, I have a
file called derby.properties in $DERBY_HOME/bin and $DERBY_HOME with the line
derby.language.logStatementText=true
in it.


Paul...


> bryan

-- 

linehanp@tcd.ie

Mob: 00 353 86 864 5772


linehanp@lg12l9:~/derby/db-derby-10.10.1.1-bin/bin$ NetworkServerControl sysinfo
--------- Derby Network Server Information --------
Version: CSS10100/10.10.1.1 - (1458268)  Build: 1458268  DRDA Product
Id: CSS10100
-- listing properties --
derby.drda.maxThreads=0
derby.drda.sslMode=off
derby.drda.keepAlive=true
derby.drda.minThreads=0
derby.drda.portNumber=1527
derby.drda.logConnections=false
derby.drda.timeSlice=0
derby.drda.startNetworkServer=false
derby.drda.host=localhost
derby.drda.traceAll=false
------------------ Java Information ------------------
Java Version:    1.7.0_45
Java Vendor:     Oracle Corporation
Java home:       /users/ugrad/linehanp/Downloads/software/jdk/jdk1.7.0_45/jre
Java classpath:
/users/ugrad/linehanp/derby/db-derby-10.10.1.1-bin/lib/derbyrun.jar
OS name:         Linux
OS architecture: amd64
OS version:      3.2.0-58-generic
Java user name:  linehanp
Java user home:  /users/ugrad/linehanp
Java user dir:   /users/ugrad/linehanp/derby/db-derby-10.10.1.1-bin
java.specification.name: Java Platform API Specification
java.specification.version: 1.7
java.runtime.version: 1.7.0_45-b18
--------- Derby Information --------
[/users/ugrad/linehanp/derby/db-derby-10.10.1.1-bin/lib/derby.jar]
10.10.1.1 - (1458268)
[/users/ugrad/linehanp/derby/db-derby-10.10.1.1-bin/lib/derbytools.jar]
10.10.1.1 - (1458268)
[/users/ugrad/linehanp/derby/db-derby-10.10.1.1-bin/lib/derbynet.jar]
10.10.1.1 - (1458268)
[/users/ugrad/linehanp/derby/db-derby-10.10.1.1-bin/lib/derbyclient.jar]
10.10.1.1 - (1458268)

Mime
View raw message