When I am retrieving it as list, it is taking 'n' minutes and it hangs.
So, I tried implementing IBatis `"RowHandler"` interface and I overrided the and I am able to get the result (One row at a time).
But I need to get 'n' rows at a time where n >= 1000. So I added fetchSize="1000" and resultSetType="FORWARD_ONLY" attribute to my select statement.
E.g:
But still I am getting only one row at a time in the "handleRow(Object obj)" method.
When the method is called during query execution, `"List Size ->"` is always incrementing by one. But I am expecting increment rate of 1000 (As I have given fetchSize = "1000")...
When I googled out, there is a property available (Driver.useCursorFetch) which can be used along with "fetchSize" and "resultSetType" attribute.
But I think it is only for MySQL Database.
Reference :
http://www.yaldex.com/mysql_manual/ch23s04.html or
http://stackoverflow.com/questions/3870500/ibatis-querywithrowhandler-still-seems-to-fetch-all-rows.
What is the equivalent property(`Driver.useCursorFetch`) for Oracle 11g database.
I need some configuration like below.
Thanks in advance.