how to use ResultsetRowsCursor?

16 views

Skip to first unread message

xiaoming song

unread,

Nov 15, 2021, 11:54:42 AM11/15/21

to mybatis-user

How to use ResultsetRowsCursor in mybatis? 截屏2021-11-16 上午12.54.07.png

Guy Rouillier

unread,

Nov 16, 2021, 4:52:30 AM11/16/21

to mybati...@googlegroups.com

I haven't done it, but I found this article:

https://segmentfault-com.translate.goog/a/1190000022167975?_x_tr_sl=zh-CN&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=nui,sc

Looks like getResultObject() will give you back the ResultsetRowsCursor, and you just use the typical hasNext() and next() methods to cycle through it. If you are thinking that negates the purpose of MyBatis, this scenario doesn't work with the typical MyBatis solution, since the result set is potentially too large to fit in memory.

I also found this StackOverflow discussion:

https://stackoverflow.com/questions/6546136/handling-very-large-amount-of-data-in-mybatis

And this issue in the MyBatis repo on GitHub:

https://github.com/mybatis/mybatis-3/pull/437

Sorry I can't provide a working code example, but hopefully these references can help.

On Mon, 2021-11-15 at 08:54 -0800, xiaoming song wrote:

How to use ResultsetRowsCursor in mybatis?

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mybatis-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/533c8995-c937-4c65-9867-f901569f4b28n%40googlegroups.com.

--