db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From peter.ondru...@yahoo.com
Subject Re: How to log queries in Apache Derby?
Date Mon, 03 Feb 2014 14:39:58 GMT
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 <linehanp@tcd.ie> 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
> 
> -- 
> 
> 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