configure both shardingsphere‐jdbc‐ spring‐boot‐starter and a spring‐boot‐starter of certain datasource pool(such as druid)? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 357 work with JPA? . . . 362 7.8.18 [DistSQL] How to set custom JDBC connection properties or connection pool properties when adding a data source using DistSQL? . . . . . . . . . . . . . . . 362 7.8.19 [DistSQL] Mybatis, Spring JDBC Template or direct use of JDBC; • Supports any third‐party database connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL

configure both shardingsphere‐jdbc‐ spring‐boot‐starter and a spring‐boot‐starter of certain datasource pool(such as druid)? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 345 work with JPA? . . . 350 7.8.18 [DistSQL] How to set custom JDBC connection properties or connection pool properties when adding a data source using DistSQL? . . . . . . . . . . . . . . . 350 7.8.19 [DistSQL] Mybatis, Spring JDBC Template or direct use of JDBC; • Supports any third‐party database connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL

configure both shardingsphere‐jdbc‐ spring‐boot‐starter and a spring‐boot‐starter of certain datasource pool (such as druid)? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 459 8.5.1 DistSQL How to set custom JDBC connection properties or connection pool prop‐ erties when adding a data source using DistSQL? . . . . . . . . . . . . . . . . . 459 8.5 Mybatis, Spring JDBC Template, or direct use of JDBC; • Support any third‐party database connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL

configure both shardingsphere‐jdbc‐ spring‐boot‐starter and a spring‐boot‐starter of certain datasource pool (such as druid)? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 498 8.5.1 DistSQL How to set custom JDBC connection properties or connection pool prop‐ erties when adding a data source using DistSQL? . . . . . . . . . . . . . . . . . 498 8.5 Mybatis, Spring JDBC Template, or direct use of JDBC; • Support any third‐party database connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL

configure both shardingsphere‐jdbc‐ spring‐boot‐starter and a spring‐boot‐starter of certain datasource pool(such as druid)? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 303 work with JPA? . 308 7.7.17 17. [DistSQL] How to set custom JDBC connection properties or connection pool properties when adding a data source using DistSQL? . . . . . . . . . . . . . . . 308 7.7.18 18 Mybatis, Spring JDBC Template or direct use of JDBC. • Supports any third‐party database connection pool, such as DBCP, C3P0, BoneCP, Druid, HikariCP. • Supports any kind of JDBC standard database: MySQL

configure both shardingsphere‐jdbc‐spring‐boot‐ starter and a spring‐boot‐starter of certain datasource pool(such as druid)? . . . . . . . 300 7.21 How to add a new logic schema dynamically when use ShardingSphere‐Proxy Mybatis, Spring JDBC Template or direct use of JDBC. • Support any third‐party database connection pool, such as DBCP, C3P0, BoneCP, Druid, HikariCP. • Support any kind of JDBC standard database: MySQL directly execute in the underlying data source, or put execu‐ tion requests directly to the thread pool to concurrently execute, but focuses more on the creation of a balanced data source connection, the

. . . . . . . . . 552 13.5.1 DistSQL How to set custom JDBC connection properties or connection pool prop‐ erties when adding a data source using DistSQL? . . . . . . . . . . . . . . . . . 552 13.5 Mybatis, Spring JDBC Template, or direct use of JDBC; • Support any third‐party database connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL configuration, data source map, rule configurations and properties. Note: The example connection pool is HikariCP, which can be replaced with other connection pools according to business scenarios.

. . . . . . . . . 581 13.5.1 DistSQL How to set custom JDBC connection properties or connection pool prop‐ erties when adding a data source using DistSQL? . . . . . . . . . . . . . . . . . 581 13.5 Mybatis, Spring JDBC Template, or direct use of JDBC; • Support any third‐party database connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL configuration, data source map, rule configurations and properties. Note: The example connection pool is HikariCP, which can be replaced with other connection pools according to business scenarios.

Job Sharding Strategy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66 Thread Pool Strategy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 Error Handler Strategy Sharding Strategy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 7.2 Thread Pool Strategy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80 7.3 Error Handler Spring DI (Dependency Injection) Beans can be freely used in Job, such as data source connection pool and Dubbo remote service, etc., which is more convenient for business development. 5.2 Elastic Schedule

池的属性名取决于各自 JDBC 池自己的定义，并不由 Shard‐ ingSphere 硬定义，相关的处理可以参考类 org.apache.shardingsphere.infra.datasource. pool.creator.DataSourcePoolCreator。例如对于 Alibaba Druid 1.2.9 而言，使用 url 代替如下 示例中的 jdbcUrl 是预期行为。 参数解释 池的属性名取决于各自 JDBC 池自己的定义，并不由 Shard‐ ingSphere 硬定义，相关的处理可以参考类 org.apache.shardingsphere.infra.datasource. pool.creator.DataSourcePoolCreator。例如对于 Alibaba Druid 1.2.9 而言，使用 url 代替如 下示例中的 jdbc-url 是预期行为。 4.1. 池的属性名取决于各自 JDBC 池自己的定义，并不由 Shard‐ ingSphere 硬定义，相关的处理可以参考类 org.apache.shardingsphere.infra.datasource. pool.creator.DataSourcePoolCreator。例如对于 Alibaba Druid 1.2.9 而言，使用 url 代替如 下示例中的 jdbcUrl 是预期行为。 操作步骤