> 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... > You may also consider adding the following: > derby.stream.error.logSeverityLevel=0 > derby.infolog.append=true Hi Myrna, Apache Derby query logging problem solved! Create file derby.properties in $DERBY_HOME derby.language.logStatementText=true derby.stream.error.logSeverityLevel=0 derby.infolog.append=true >From the $DERBY_HOME run (i.e. start server) java -jar -Dderby.system.home=$DERBY_HOME $DERBY_HOME/lib/derbyrun.jar server start >From the $DERBY_HOME run ij. Connect to your database i.e. CONNECT 'jdbc:derby://localhost:1527/pdata/firstdb'; Run your query (I then committed - possibly unnecessary) Exit ij. cat/more/less derby.log and voilà - my query is there! Thank you very much - that's great. Now I can log my queries - I can always play around with the settings, but I know I can always get back to a working setup! Yaay! And thanks to everyone else who contributed. Paul... > Myrna -- [email protected] Mob: 00 353 86 864 5772
