You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "nswdn (via GitHub)" <gi...@apache.org> on 2023/06/29 13:58:03 UTC

[GitHub] [shardingsphere] nswdn opened a new issue, #26700: Using Mybatis Cursor API with sharding-jdbc:3.0 got problem

nswdn opened a new issue, #26700:
URL: https://github.com/apache/shardingsphere/issues/26700

   ## ENV
   JDK version: 8
   Mybatis version: 3.5.6
   Sharding-JDBC version: 3.0
   
   ## Code
   ```java
   @Mapper
   public interface Mapper {
     Cursor<User> findHugeUsers();
   }
   ```
   
   ## Quesion
   When I call findHugeUsers(), it throws a exception.
   ``` java
   org.apache.ibatis.exceptions.PersistenceException: 
   ### Error querying database.  Cause: java.sql.SQLFeatureNotSupportedException: closeOnCompletion
   ```
   
   I traced code and find that
   ```java
   io.shardingsphere.shardingjdbc.jdbc.unsupported.AbstractUnsupportedOperationStatement#closeOnCompletion() {
     throws new SQLFeatureNotSupportedException("closeOnCompletion");
   }
   ```
   Then I read many versions of Sharding-JDBC's doc find that they seem to all not support closeOnCompletion method.
   
   Is there's some same ways like Mybatis's Cursor to query huge data by Sharding-JDBC?
   


-- 
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.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] github-actions[bot] commented on issue #26700: Why not support closeOnCompletion API on java.sql.Statement

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #26700:
URL: https://github.com/apache/shardingsphere/issues/26700#issuecomment-1666195339

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


-- 
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

Re: [I] Why not support closeOnCompletion API on java.sql.Statement [shardingsphere]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #26700:
URL: https://github.com/apache/shardingsphere/issues/26700#issuecomment-1775937139

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


-- 
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] rencoco commented on issue #26700: Why not support closeOnCompletion API on java.sql.Statement

Posted by "rencoco (via GitHub)" <gi...@apache.org>.
rencoco commented on issue #26700:
URL: https://github.com/apache/shardingsphere/issues/26700#issuecomment-1730958048

   I want to know if this question has been resolved, ths.


-- 
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] nswdn commented on issue #26700: Why not support closeOnCompletion API on java.sql.Statement

Posted by "nswdn (via GitHub)" <gi...@apache.org>.
nswdn commented on issue #26700:
URL: https://github.com/apache/shardingsphere/issues/26700#issuecomment-1730969046

   > **version** : v5.3.0 I want to know if this question has been resolved, ths.
   
   I do not sure about this, sorry. I use native connection pool (In my project is hikari.) to avoidance 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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org