[GitHub] [shardingsphere] heysJava commented on issue #10353: this(connection, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT);

[GitBox <gi...@apache.org>]

heysJava commented on issue #10353:
URL: https://github.com/apache/shardingsphere/issues/10353#issuecomment-841760981


   
   
   
   
   > @heysJava , the default behavior value of above three parameters are `ResultSet.TYPE_FORWARD_ONLY`, `ResultSet.CONCUR_READ_ONLY`, `ResultSet.HOLD_CURSORS_OVER_COMMIT`. Users could specific the value of the parameters.
   
   @SteNicholas ,How do users specify these parameter values? When using the qurey method of jdbcTemplate, connection.createStatement() will be used. This method calls the createStatement() method in the ShardingSphereConnection class, and it will be new ShardingSphereStatement(this); that is this way
   public ShardingSphereStatement(final ShardingSphereConnection connection) {
           this(connection, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT);
       }
   These parameter values ​​are fixed. When users want to use this method, they cannot pass custom parameter values. If you want to change this parameter value, you need to change the source code of jdbcTemplate or the source code of Shardingsphere. I feel that this method is very unfriendly. There is no other way to avoid


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