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.
=======================================
linehanp@lg12l9:~/derby/db-derby-10.10.1.1-bin/bin$ echo $DERBY_HOME
/users/ugrad/linehanp/derby/db-derby-10.10.1.1-bin
linehanp@lg12l9:~/derby/db-derby-10.10.1.1-bin/bin$
=======================================
I launch derby by issuing the command (from $DERBY_HOME)
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. The derby.properties file should live in the current
directory, according to the instructions here:
http://db.apache.org/derby/docs/10.10/devguide/cdevsetprop13074.html
I created a file called derby.properties in $DERBY_HOME/bin
I would not expect Derby to look for derby.properties in that directory,
unless you boot the JVM with this property setting:
-Dderby.system.home=$DERBY_HOME/bin
I would expect to find derby.log in the JVM's current directory unless,
again, you set derby.system.home to some other value. In that case, I
would expect to find derby.log in the directory indicated by
derby.system.home.
Hope this helps,
-Rick
in which there is one line
======================
linehanp@lg12l9:~/derby/db-derby-10.10.1.1-bin/bin$ more derby.properties
derby.language.logStatementText=true
linehanp@lg12l9:~/derby/db-derby-10.10.1.1-bin/bin$
======================
Restart server.
I run ij from $DERBY_HOME and issue a query.
==========================================
ij> connect 'jdbc:derby://localhost:1527/pdata/firstdb';
ij> set schema linehanp;
0 rows inserted/updated/deleted
ij> select * from analysis;
ANALYSIS_ID|CREATED
.... Result set deleted.
ij> commit;
ij> exit;
=============================
I've looked everywhere and can't find my logged query
======================
linehanp@lg12l9:~/derby/db-derby-10.10.1.1-bin$ find . -name "*.log"
./pdata/derby.log<<====== same as ./derby.log below.
./derby.log<<<<==== a line about shutting down, nothing else
./bin/derby.log<<<=== empty file.
linehanp@lg12l9:~/derby/db-derby-10.10.1.1-bin$ cd bin/
============================
Could some kind soul tell me what I'm doing wrong - thanks.
If any other information is required, please don't hesitate to let me know.
Rgs,
Paul...
