Set defualtFetchSize=-2147483648 in jdbcUrl, and do not configure defualtFetchSize in the mapper or mybatis configuration file. Should streaming query take effect?At present, from the test, if you do this, the streaming query does not take effect, I want to confirm
--
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/e1f599ff-ed18-4a71-a438-dc9ce2df902dn%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/CA%2Buep2R91g9QogSoFE1aNjNiA%3DU9Mr0R8xjiyHSrBqvyNEzFoA%40mail.gmail.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/99A49D49-199D-4A0E-B89B-F2160BCE7371%40pingcap.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/CA%2Buep2RGyKQEOowLg666pntrKr1vFZKp2X-G-ZYFEL_Z-QL-qw%40mail.gmail.com.
2020年10月31日 上午11:35,Iwao AVE! <hara...@gmail.com> 写道:
OK...here is how I tested.I set a breakpoint on org.apache.ibatis.executor.statement.PreparedStatementHandler#query() and run the test case below in debug mode.defaultFetchSize=-2147483648 is set in the JDBC URL.And the actual fetchSize is -2147483648.
<image.png>I didn't check if the result set is actually being streamed or not, but if you see fetchSize=0, it may be set by something else.Regards,Iwao
On Sat, Oct 31, 2020 at 11:34 AM yang yu <yuy...@pingcap.com> wrote:Because the use of streaming query still causes the client server to oom, check the hprof file and find that fetchsize=0
--
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/CA%2Buep2RytH8YYLEKSxxTsjmOA7KPmOkmUP6SmUHdcywysqCXaQ%40mail.gmail.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/B666E850-8F9D-4DC1-B22F-E7791FAA0582%40pingcap.com.