Re: How to log queries in Apache Derby - problem solved!

2014-02-03 Thread Paul Linehan
> First remove / rename all the previously created derby.log files. > Then start your server. > Look for a fresh derby.log file (if not the current dir when you start > networkserver, also check under your home directory) and put the > derby.properties file in *that* directory, then restart... > Y

Re: How to log queries in Apache Derby?

2014-02-03 Thread Myrna van Lunteren
On Mon, Feb 3, 2014 at 8:39 AM, Paul Linehan wrote: > Hi again, > > As a further clarification to my last post, the database itself is > called firstdb and > sits in a directory pdata, i.e. $DERBY_HOME/pdata/firstdb > > My connection string is 'jdbc:derby://localhost:1527/pdata/firstdb'; > > > H

Re: How to log queries in Apache Derby?

2014-02-03 Thread Paul Linehan
Hi again, As a further clarification to my last post, the database itself is called firstdb and sits in a directory pdata, i.e. $DERBY_HOME/pdata/firstdb My connection string is 'jdbc:derby://localhost:1527/pdata/firstdb'; HTH, Paul... -- lineh...@tcd.ie Mob: 00 353 86 864 5772

Re: How to log queries in Apache Derby?

2014-02-03 Thread Paul Linehan
Hi Rick (and thanks for your input), >> java -jar $DERBY_HOME/lib/derbyrun.jar server start >> or sometimes >> ./bin/startNetworkServer > That command line suggests that the current directory of the JVM is > $DERBY_HOME. No - I run ./bin/startNetworkServer from $DERBY_HOME. I can run it from

Re: How to log queries in Apache Derby?

2014-02-03 Thread peter . ondruska
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, a

Re: How to log queries in Apache Derby?

2014-02-03 Thread Rick Hillegas
Hi Paul, Some comments inline... On 2/1/14 12:14 PM, Paul Linehan wrote: Hi all, I am trying to log queries to my Apache Derby server. My $DERBY_HOME is as follows - Ubuntu Linux 64bit - Java jdk1.7.0_45. Can access my database through Squirrel and ij. ==

Re: How to log queries in Apache Derby?

2014-02-03 Thread Paul Linehan
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

Re: How to log queries in Apache Derby?

2014-02-02 Thread Bryan Pendleton
> I launch derby by issuing the command (from $DERBY_HOME) It's always been a bit of a trick to figure out which directory the Network Server is trying to read your properties from. Does it work if you do: java -jar $DERBY_HOME/lib/derbyrun.jar -Dderby.language.logStatementText=true server s

How to log queries in Apache Derby?

2014-02-01 Thread Paul Linehan
Hi all, I am trying to log queries to my Apache Derby server. My $DERBY_HOME is as follows - Ubuntu Linux 64bit - Java jdk1.7.0_45. Can access my database through Squirrel and ij. === linehanp@lg12l9:~/derby/db-derby-10.10.1.1-bin/bin$ echo $DERBY_HOME /users