ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Smiley (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Commented: (IBATIS-290) implement resultset methods in com.ibatis.sqlmap.client.SqlMapClient:
Date Tue, 15 Jul 2008 20:47:31 GMT

    [ https://issues.apache.org/jira/browse/IBATIS-290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12613726#action_12613726

David Smiley commented on IBATIS-290:

Yes, definitely.  I have code that operates on a ResultSet that I am not in a position to
change, and I'd like iBatis to perform the query but not do anything with the resultset. 
I was thinking, one way to do this with iBatiis might be to specify that the resultClass of
a query is java.lang.ResultSet.  When this occurs, iBatis could know to directly return it
when calling one of its existing methods.  And if a queryWithRowHandler is invoked, the ResultSet
could be the object passed to handleRow().

> implement resultset methods in com.ibatis.sqlmap.client.SqlMapClient:
> ---------------------------------------------------------------------
>                 Key: IBATIS-290
>                 URL: https://issues.apache.org/jira/browse/IBATIS-290
>             Project: iBatis for Java
>          Issue Type: New Feature
>          Components: SQL Maps
>    Affects Versions: 2.2.0
>            Reporter: Peter Köhler
> Hello to the ibatis community,
> her is my wish list for a new release:
> Implement new methods in com.ibatis.sqlmap.client.SqlMapClient:
>   public java.sql.ResultSet queryForResultSet(String mappedStatement, Object parameter);
>   public java.util.List getListForResultSet(String resultMap, java.sql.ResultSet resultSet);
>   public java.util.List getListForResultSet(String resultMap, java.sql.ResultSet resultSet,
int maxRows);
>   public java.util.List getListForResultSet(java.lang.Class, java.sql.ResultSet resultSet);
>   public java.util.List getListForResultSet(java.lang.Class, java.sql.ResultSet resultSet,
int maxRows);
> So that one could retrieve a ResultSet (first method) and then map it to Objects in a
List via
> ResultMaps or via automapping.
> My motivation behind this is that developers sometimes have to deal with resultsets which
> required by other API´s.
> It would be great to leverage Ibatis even in this low level environment.
> Another use case is to avoid OutOfMemoryErrors in huge and expensive resultsets by stepping
through one resultset, 
> instead of repeating the query multiple times with different step sizes.
> Thanks in advance and happy discussing ;)
> Greetings from Frankfurt, Germany
> Peter Köhler

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message