I do this: DERBY_OPTS="-Xms256m -Xmx256m -Dderby.storage.pageCacheSize=2048 -Dderby.system.home=/MQHA/db -Dderby.storage.tempDirectory=$TMPDIR -Dderby.infolog.append=true -Dderby.language.logQueryPlan=false -Dderby.language.logStatementText=false" startNetworkServer &
Peter > On 3 Feb 2014, at 11:45, Paul Linehan <[email protected]> wrote: > > 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)
