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 -- [email protected] 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)
