From derby-user-return-9203-apmail-db-derby-user-archive=db.apache.org@db.apache.org Thu May 08 20:03:01 2008 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 97128 invoked from network); 8 May 2008 20:03:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 8 May 2008 20:03:01 -0000 Received: (qmail 19474 invoked by uid 500); 8 May 2008 20:03:01 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 19456 invoked by uid 500); 8 May 2008 20:03:01 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 19445 invoked by uid 99); 8 May 2008 20:03:01 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 May 2008 13:03:01 -0700 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 May 2008 20:02:14 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1JuCJw-0004cw-PD for derby-user@db.apache.org; Thu, 08 May 2008 13:02:28 -0700 Message-ID: <17135317.post@talk.nabble.com> Date: Thu, 8 May 2008 13:02:28 -0700 (PDT) From: donaldp To: derby-user@db.apache.org Subject: Cannot get derby.language.logQueryPlan to work MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: donaldp@bluestreaktech.com X-Virus-Checked: Checked by ClamAV on apache.org Hello all, I'm trying to do some optimization work on my statements but I can't get logQueryPlan to work. I tried setting it on the command line (-Dderby.language.logQueryPlan=true) of ij.bat and the startnetworkserver.bat. Does not work. I tried to set it in the derby.properties file, does not work either. I tried it in my app too using the same techniques in addition to using jdbc connection properties. Does not work. I can set derby's log file name or make it append to the file instead of overwriting it but I can't get the statements to log properly. I'm sure it's something quite simple cause I've searched everywhere but noone seems to have this problem. This is driving me nuts. Please help. I'm using 10.4.1.3 on Windows. thanks for your help donald -- View this message in context: http://www.nabble.com/Cannot-get-derby.language.logQueryPlan-to-work-tp17135317p17135317.html Sent from the Apache Derby Users mailing list archive at Nabble.com.