[ 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
