You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/01/22 14:45:56 UTC
[GitHub] [shardingsphere] xsong123 opened a new issue #15000: how to use stream query
xsong123 opened a new issue #15000:
URL: https://github.com/apache/shardingsphere/issues/15000
shardingsphere version 5.0.0
mysql version 5.7
how to set settings for stream query ?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #15000: how to use stream query
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #15000:
URL: https://github.com/apache/shardingsphere/issues/15000#issuecomment-1019607870
@xsong123 Yes, we can't use stream query when connection mode is `connection_strictly`.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] xsong123 commented on issue #15000: how to use stream query
Posted by GitBox <gi...@apache.org>.
xsong123 commented on issue #15000:
URL: https://github.com/apache/shardingsphere/issues/15000#issuecomment-1019397382
> If you use mysql database, you can try `preparedStatement.setFetchSize(Integer.MIN_VALUE);` to open stream query.
i have used `preparedStatement.setFetchSize(Integer.MIN_VALUE);` , but don't work.
trace source, then found:
ConnectionMode connectionMode = maxConnectionsSizePerQuery < sqlUnits.size() ? ConnectionMode.CONNECTION_STRICTLY : ConnectionMode.MEMORY_STRICTLY;
`maxConnectionsSizePerQuery` and `sqlUnits.size()` affect connectionMode .
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] yx9o commented on issue #15000: how to use stream query
Posted by GitBox <gi...@apache.org>.
yx9o commented on issue #15000:
URL: https://github.com/apache/shardingsphere/issues/15000#issuecomment-1019299108
Hi, can you provide more error information? Maybe you can try the master version, please refer to: https://github.com/apache/shardingsphere/issues/14827
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #15000: how to use stream query
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #15000:
URL: https://github.com/apache/shardingsphere/issues/15000#issuecomment-1019385926
@xsong123 Can you provide your configuration? Or give an example?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu closed issue #15000: how to use stream query
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #15000:
URL: https://github.com/apache/shardingsphere/issues/15000
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #15000: how to use stream query
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #15000:
URL: https://github.com/apache/shardingsphere/issues/15000#issuecomment-1042901492
Closed because of no response for long time.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #15000: how to use stream query
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #15000:
URL: https://github.com/apache/shardingsphere/issues/15000#issuecomment-1019386031
> Hi, can you provide more error information? Maybe you can try the master version, please refer to: #14827
Thank you for @yx9o, but the pr of this issue has been reverted because it caused an unexpected streaming query exception.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #15000: how to use stream query
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #15000:
URL: https://github.com/apache/shardingsphere/issues/15000#issuecomment-1019387249
If you use mysql database, you can try `preparedStatement.setFetchSize(Integer.MIN_VALUE);` to open stream query.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org