Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 79440 invoked from network); 10 Sep 2006 21:40:33 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 10 Sep 2006 21:40:33 -0000 Received: (qmail 71620 invoked by uid 500); 10 Sep 2006 21:40:32 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 71294 invoked by uid 500); 10 Sep 2006 21:40:31 -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 71271 invoked by uid 99); 10 Sep 2006 21:40:31 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 10 Sep 2006 14:40:31 -0700 X-ASF-Spam-Status: No, hits=1.9 required=10.0 tests=DNS_FROM_RFC_ABUSE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: 216.54.161.53 is neither permitted nor denied by domain of Stan.Bradbury@gmail.com) Received: from [216.54.161.53] (HELO orlandotelco.net) (216.54.161.53) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 10 Sep 2006 14:40:30 -0700 Received: from [127.0.0.1] (unverified [65.117.182.226]) by orlandotelco.net (SurgeMail 3.7b6) with ESMTP id 1743631 for ; Sun, 10 Sep 2006 17:17:21 -0400 Message-ID: <45048632.7040004@gmail.com> Date: Sun, 10 Sep 2006 14:40:02 -0700 From: Stanley Bradbury User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: Derby Discussion Subject: Re: How to see SQL as it is executing? References: <712EF8F5-0279-4116-88D5-745CCB206E36@frontiernet.net> <5AAC7068-75CF-4287-9412-F75830AC5E42@frontiernet.net> <450464AD.9030906@amberpoint.com> In-Reply-To: <450464AD.9030906@amberpoint.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Server: High Performance Mail Server - http://surgemail.com r=100 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Bryan Pendleton wrote: > Michael McCutcheon wrote: >>> Can I turn on some property and see the SQL's the database is running? > > See if this helps: > http://db.apache.org/derby/docs/dev/tuning/rtunproper43517.html > > thanks, > > bryan The Hints and Tips section of the Derby Wiki has a writeup that introduces the format of the entries logged when logStatementText is enabled. It might be helpful: http://wiki.apache.org/db-derby/LogStamentTextMsgs