From ddlutils-dev-return-25-apmail-db-ddlutils-dev-archive=db.apache.org@db.apache.org Thu Aug 04 21:52:58 2005 Return-Path: Delivered-To: apmail-db-ddlutils-dev-archive@www.apache.org Received: (qmail 3533 invoked from network); 4 Aug 2005 21:52:58 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 4 Aug 2005 21:52:58 -0000 Received: (qmail 97502 invoked by uid 500); 4 Aug 2005 21:52:58 -0000 Delivered-To: apmail-db-ddlutils-dev-archive@db.apache.org Received: (qmail 97487 invoked by uid 500); 4 Aug 2005 21:52:58 -0000 Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-dev@db.apache.org Delivered-To: mailing list ddlutils-dev@db.apache.org Delivered-To: moderator for ddlutils-dev@db.apache.org Received: (qmail 73246 invoked by uid 99); 31 Jul 2005 19:08:08 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Message-ID: <502511804.1122836873738.JavaMail.jira@ajax.apache.org> Date: Sun, 31 Jul 2005 21:07:53 +0200 (CEST) From: "Thomas Dudziak (JIRA)" To: ddlutils-dev@db.apache.org Subject: [jira] Resolved: (DDLUTILS-2) DynaSql.query methods don't (can't?) free up JDBC resources In-Reply-To: <139539806.1121434750673.JavaMail.jira@ajax.apache.org> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 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 [ http://issues.apache.org/jira/browse/DDLUTILS-2?page=all ] Thomas Dudziak resolved DDLUTILS-2: ----------------------------------- Resolution: Fixed I've added a iterator implementation that closes the resources (statement, connection) upon error or finish of the iteration. > DynaSql.query methods don't (can't?) free up JDBC resources > ----------------------------------------------------------- > > Key: DDLUTILS-2 > URL: http://issues.apache.org/jira/browse/DDLUTILS-2 > Project: DdlUtils > Type: New Feature > Reporter: Dave Sunerton-Burl > Assignee: Thomas Dudziak > Priority: Minor > Attachments: patch-add-getCollection.txt > > See attached patch for a way round this. > The new getCollection methods return a collection of populated DynaBeans based on an SQL query (including the ability to set the start and end row number to return a subset of the query). These methods clean up the connection, statement, and resultSet used before returning. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira