db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From donaldp <dona...@bluestreaktech.com>
Subject Re: Cannot get derby.language.logQueryPlan to work
Date Fri, 09 May 2008 16:49:51 GMT

I do run my statements to completion (at least I think I do). I can see the
rows output to the console. But no plan in the log.

I thought there was something stupid I missed but I guess not ...

Below is what my log file looks like after a couple of connections and
select statements run through IJ and a shutdown:

Apache Derby Network Server - 10.4.1.3 - (648739) started and ready to
accept connections on port 1527 at 2008-05-09 16:41:43.097 GMT 
Connection number: 1.
----------------------------------------------------------------
2008-05-09 16:41:50.504 GMT:
 Booting Derby version The Apache Software Foundation - Apache Derby -
10.4.1.3 - (648739): instance c013800d-0119-ce8f-399a-00006d6b7021
on database directory C:\data\master  

Database Class Loader started - derby.database.classpath=''
2008-05-09 16:41:51.097 GMT Thread[DRDAConnThread_2,5,main] (DATABASE =
c:/data/master), (DRDAID = {1}), Apache Derby Network Server connected to
database c:/data/master
Connection number: 2.
2008-05-09 16:42:36.848 GMT Thread[DRDAConnThread_2,5,main] (DATABASE =
c:/data/master), (DRDAID = {2}), Apache Derby Network Server connected to
database c:/data/master
Connection number: 3.

2008-05-09 16:43:42.161 GMT:
Shutting down instance c013800d-0119-ce8f-399a-00006d6b7021
----------------------------------------------------------------


Bryan Pendleton wrote:
> 
>> The log file gets appended to, I can see the connection numbers in the
>> server's console and in the log file and the logs are sent to my custom
>> file
>> but I can't for the love of god get any statements or plans logged. I
>> can't
> 
> Make sure that your statement runs all the way through to completion,
> because query plan logging only occurs at the very end of query execution,
> and if the query is interrupted partway through, the query plan results
> do not get logged.
> 
> For example, I repeated your experiment by starting the server, then
> connecting with ij and doing:
> 
>    create table t (a int);
>    select * from t;
> 
> and I saw the query plan for the SELECT.
> 
> Does that work for you?
> 
> thanks,
> 
> bryan
> 
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Cannot-get-derby.language.logQueryPlan-to-work-tp17135317p17152010.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message