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 2020/03/14 14:56:56 UTC

[GitHub] [incubator-shardingsphere] ma1562013338 opened a new issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used

ma1562013338 opened a new issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used
URL: https://github.com/apache/incubator-shardingsphere/issues/4760
 
 
   ## Bug Report
   
   Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used
   
   Please answer these questions before submitting your issue. Thanks!
   
   ### Which version of ShardingSphere did you use?
   sharding- JDBC 4.0.0-RC2
   ### Which project did you use? Sharding-JDBC or Sharding-Proxy?
   Sharding-JDBC
   ### Expected behavior
   The SQL setup timeout should take effect
   ### Actual behavior
   The SQL timeout does not take effect after sharding- JDBC is used
   ### Reason analyze (If you can)
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   
   ### Example codes for reproduce this issue (such as a github link).
   ` <select id="testTimeout" resultType="int" timeout="3">
           select sleep(10);
       </select>`

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] terrymanu edited a comment on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used

Posted by GitBox <gi...@apache.org>.
terrymanu edited a comment on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used
URL: https://github.com/apache/incubator-shardingsphere/issues/4760#issuecomment-599563333
 
 
   @ma1562013338 Do you interesting this issue? Maybe we can talk about how to do the pull request.

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used
URL: https://github.com/apache/incubator-shardingsphere/issues/4760#issuecomment-599077221
 
 
   We have no plan to support this. Does anybody interest about this issue?

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] terrymanu closed issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used
URL: https://github.com/apache/incubator-shardingsphere/issues/4760
 
 
   

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used
URL: https://github.com/apache/incubator-shardingsphere/issues/4760#issuecomment-604337021
 
 
   @ma1562013338  Hi, maybe we misunderstand each other.
   What I mean is we have no plan to implement this feature (because it is not a major issue). So we need to find a  volunteer to do this feature. 
   
   Do you interest to develop this feature?

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used
URL: https://github.com/apache/incubator-shardingsphere/issues/4760#issuecomment-603716903
 
 
   @ma1562013338 Can you provide a design? Then we can discuss further.

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] ma1562013338 commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used

Posted by GitBox <gi...@apache.org>.
ma1562013338 commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used
URL: https://github.com/apache/incubator-shardingsphere/issues/4760#issuecomment-604177958
 
 
   @terrymanu I hope the timeout time set by mybatis is valid. Such as:
   `<configuration>
       <settings>
           <setting name="defaultStatementTimeout" value="20"/>
       </settings>
   </configuration>
   
   <select id="test" timeout="10" resultType="xxx">
           select * from tableName
       </select>
   `

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] ma1562013338 edited a comment on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used

Posted by GitBox <gi...@apache.org>.
ma1562013338 edited a comment on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used
URL: https://github.com/apache/incubator-shardingsphere/issues/4760#issuecomment-604177958
 
 
   @terrymanu I hope the timeout time set by mybatis is valid. Such as:
   
   1. 
   `<configuration>
       <settings>
           <setting name="defaultStatementTimeout" value="20"/>
       </settings>
   </configuration>
   `
   
   2. 
   `<select id="test" timeout="10" resultType="xxx">
           select * from tableName
       </select>`

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] ma1562013338 commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used

Posted by GitBox <gi...@apache.org>.
ma1562013338 commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used
URL: https://github.com/apache/incubator-shardingsphere/issues/4760#issuecomment-599188563
 
 
   @terrymanu To prevent individual slow SQL from dragging down the entire database, it is necessary to set the SQL timeout time. I hope to be able to support mybatis to set the SQL timeout 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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] ma1562013338 commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used

Posted by GitBox <gi...@apache.org>.
ma1562013338 commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used
URL: https://github.com/apache/incubator-shardingsphere/issues/4760#issuecomment-599591001
 
 
   Yes, I hope to add this feature, and I think it's useful.

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used
URL: https://github.com/apache/incubator-shardingsphere/issues/4760#issuecomment-608371133
 
 
   Closed until somebody interesting about this issue

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4760: Setting SQL timeout time in mybatis does not take effect after sharding- JDBC 4.0.0-RC2 is used
URL: https://github.com/apache/incubator-shardingsphere/issues/4760#issuecomment-599563333
 
 
   @ma1562013338 Do you interesting this issue?

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services