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

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

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


   @heysJava Hi, I have checked the Connection implementation of MySQL JDBC driver. By default, similar parameter settings are also provided.
   
   ```java
   private static final int DEFAULT_RESULT_SET_TYPE = ResultSet.TYPE_FORWARD_ONLY;
   
   private static final int DEFAULT_RESULT_SET_CONCURRENCY = ResultSet.CONCUR_READ_ONLY;
   
   /**
    * SQL statements without parameters are normally executed using Statement
    * objects. If the same SQL statement is executed many times, it is more
    * efficient to use a PreparedStatement
    * 
    * @return a new Statement object
    * @throws SQLException
    *             passed through from the constructor
    */
   public java.sql.Statement createStatement() throws SQLException {
       return createStatement(DEFAULT_RESULT_SET_TYPE, DEFAULT_RESULT_SET_CONCURRENCY);
   }
   ```
   
   Besides, the `ShardingSphereConnection` class provides multiple createStatement overload methods to support user-specified parameters. I think you should check the Spring `JdbcTemplate` documentation to see whether it provides relevant methods to call other overloaded methods.


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