Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of clfleck@bellsouth.net
 designates 207.115.11.52 as permitted sender)
From: "Christopher L. Fleck" <clfleck@bellsouth.net>
To: "'Derby Discussion'" <derby-user@db.apache.org>
References: <C5165FE92AAE455EBCEE28833F991184@home.local>
 <474DCA53.6070704@amberpoint.com>
 <A5731B3594AC4A8685977576D6EF276E@home.local>
In-Reply-To: <A5731B3594AC4A8685977576D6EF276E@home.local>
Subject: RE: Query Plans
Date: Sat, 12 Apr 2008 12:28:04 -0400
Message-ID: <4DF801B4582B4D21AB1B0DAB970C18E7@home.local>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: Acgx+knPqwSOjKZURLap7hS2FilMzgAAIyMwGq/TZSA=

I figured out what my problem is.  The query plan isn't displayed until you
close the statement.

-----Original Message-----
From: Christopher L. Fleck [mailto:clfleck@bellsouth.net] 
Sent: Wednesday, November 28, 2007 3:14 PM
To: 'Derby Discussion'
Subject: RE: Query Plans

Is this not sufficient:

private static void printResultSet(ResultSet results) {
	try { 
		while(results.next()) {
			for(int i = 1; 
			i <= results.getMetaData().getColumnCount(); 
			i++) {
				System.out.print(results.getString(i) +
"\t");
			}
			System.out.println();
		}
	} catch(SQLException e) { e.printStackTrace(); }
}

Also, I'm not sure if that would explain why I sometimes get the query plan
but not always.  With the same query, the query plan may show up or it may
not.  

Thank you for responding,
CLF

-----Original Message-----
From: Bryan Pendleton [mailto:bpendleton@amberpoint.com] 
Sent: Wednesday, November 28, 2007 3:07 PM
To: Derby Discussion
Subject: Re: Query Plans

> I've got query plan logging enabled in Derby, but, for some reason, I 
> only see query plans for my selects seemingly at random. 

Make sure you're fully retrieving all the rows from the result set.
I think I remember that query plan logging only occurs at the completion
of execution, after all the rows have been fully fetched.

thanks,

bryan