Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 38357 invoked from network); 2 Feb 2009 15:45:27 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 2 Feb 2009 15:45:27 -0000 Received: (qmail 32918 invoked by uid 500); 2 Feb 2009 15:45:27 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 32458 invoked by uid 500); 2 Feb 2009 15:45:26 -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 32449 invoked by uid 99); 2 Feb 2009 15:45:26 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2009 07:45:26 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [66.207.132.3] (HELO web2.nidhog.com) (66.207.132.3) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2009 15:45:18 +0000 Received: from win2000 (filardo.vdsl.nidhog.net [66.207.132.80]) (authenticated bits=0) by web2.nidhog.com (8.14.3/8.13.8) with ESMTP id n12FvjXY027619 for ; Mon, 2 Feb 2009 10:57:45 -0500 (EST) (envelope-from john@johntdow.com) Message-Id: <200902021557.n12FvjXY027619@web2.nidhog.com> From: "John T. Dow" To: "derby-user@db.apache.org" Date: Mon, 02 Feb 2009 10:44:52 -0500 Priority: Normal X-Mailer: PMMail 2000 Professional (2.20.2717) For Windows 2000 (5.0.2195;4) MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Subject: Can an embedded Derby connection support multiple simultaneous result sets? X-Nidhog-MailScanner-Information: Please contact the ISP for more information X-Nidhog-MailScanner: Found to be clean X-Nidhog-MailScanner-From: john@johntdow.com X-Virus-Checked: Checked by ClamAV on apache.org X-Old-Spam-Status: No I think the answer is no, but I couldn't find anything in the documentation on the subject. The best I found was this in one of the user group discussions... The result set is closed as soon as one of the following occurs: > ... > another Statement object is executed on the same connection Is it necessary to open a new connection for each statement/resultset? John