db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (DDLUTILS-2) DynaSql.query methods don't (can't?) free up JDBC resources
Date Tue, 09 Aug 2005 21:31:36 GMT
     [ http://issues.apache.org/jira/browse/DDLUTILS-2?page=all ]
     
Thomas Dudziak resolved DDLUTILS-2:
-----------------------------------

    Resolution: Fixed

I reworked the iterator and it works now. Please note that it is necessary to advance the
result set in the hasNext method as the only way to now whether there is another row is to
advance the cursor.

> 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-DynaSqlIterator.txt, 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


Mime
View raw message