Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 96115 invoked from network); 3 Feb 2006 22:31:39 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 3 Feb 2006 22:31:39 -0000 Received: (qmail 43677 invoked by uid 500); 3 Feb 2006 22:31:38 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 43635 invoked by uid 500); 3 Feb 2006 22:31:38 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 43625 invoked by uid 99); 3 Feb 2006 22:31:38 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Feb 2006 14:31:38 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [68.142.198.202] (HELO smtp103.sbc.mail.mud.yahoo.com) (68.142.198.202) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 03 Feb 2006 14:31:34 -0800 Received: (qmail 77863 invoked from network); 3 Feb 2006 22:31:13 -0000 Received: from unknown (HELO ?127.0.0.1?) (ddebrunner@sbcglobal.net@71.131.247.194 with plain) by smtp103.sbc.mail.mud.yahoo.com with SMTP; 3 Feb 2006 22:31:12 -0000 Message-ID: <43E3D9AA.4080301@apache.org> Date: Fri, 03 Feb 2006 14:31:06 -0800 From: Daniel John Debrunner User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: en-us, en, de MIME-Version: 1.0 To: derby-dev@db.apache.org Subject: Re: Paging Lance: format of empty result set References: <43E3D8F3.80203@sun.com> In-Reply-To: <43E3D8F3.80203@sun.com> X-Enigmail-Version: 0.90.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N David W. Van Couvering wrote: > If I want to send an empty result set, do the result columns still have > to match the expected set of result columns? I can't see why this would > matter. > > Anybody else want to weigh in on this? > > It would be a lot simpler for me if I could have a single "fake" query > that generates a "generic" empty result set with, say, a single integer > column, rather than compose one with the right columns for each > unsupported metadata call. You have to provide a result set of the shape defined by the call. It will be just to confusing to do anything else. With your approach the ResultSetMetaData would not match the defined columns of the DMD method. Dan.