[ http://issues.apache.org/jira/browse/IBATIS-368?page=comments#action_12451010 ] Kai Grabfelder commented on IBATIS-368: ---------------------------------------
Of course you are right - a second interface should be used... I'm wondering why this feature is not implemented yet - I can't believe I'm the only one who needed this thing... > RowHandler implementation needs to be able to end current resultSet > processing > ------------------------------------------------------------------------------- > > Key: IBATIS-368 > URL: http://issues.apache.org/jira/browse/IBATIS-368 > Project: iBatis for Java > Issue Type: Improvement > Affects Versions: 2.1.7 > Reporter: Kai Grabfelder > > The current RowHandler interface lacks the possibility to end current > resultSet processing. Example: > If a join query which joins categories and products Per category multiple > products are allowed. The query is sorted by category ID. The query returns > 100 000 rows but I only want to return the first 100 categories. I can not > use the current limit functionalities of ibatis as I don't know how many > products are present per category. So the number of rows to get the first 200 > categories could be anything between 200 and infinity. > I've written my own RowHandler implementation that throws and exception after > the first 200 categoires - but that is not very nice. So why not change the > interface of RowHandler#handleRow() to return boolean instead of void - > this way the result set processing could be interupted if desired. > cheers > Kai -- 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
