connect to ShardingSphere‐Proxy, if ShardingSphere‐Proxy does not create a database or does not add a resource, the client connection will fail? . . . . . . . . . . . . . . . . . . . . . . . . . . . 457 8 adding a data source using DistSQL? . . . . . . . . . . . . . . . . . 459 8.5.2 DistSQL How to solve Resource [xxx] is still used by [Sin- gleTableRule]. exception when dropping a data source using DistSQL transaction adopts the concepts including AP(application program), YM(transaction manager) and RM(resource manager) to ensure the strong consistency of distributed transactions. Those concepts are abstracted

connect to ShardingSphere‐Proxy, if ShardingSphere‐Proxy does not create a database or does not add a resource, the client connection will fail? . . . . . . . . . . . . . . . . . . . . . . . . . . . 496 8 adding a data source using DistSQL? . . . . . . . . . . . . . . . . . 498 8.5.2 DistSQL How to solve Resource [xxx] is still used by [Sin- gleTableRule]. exception when dropping a data source using DistSQL transaction adopts the concepts including AP(application program), TM(transaction manager) and RM(resource manager) to ensure the strong consistency of distributed transactions. Those concepts are abstracted

connect to ShardingSphere‐Proxy, if ShardingSphere‐Proxy does not create a Schema or does not add a Resource, the client connection will fail? . . . . . . . . . . . . . . . . . . . . . . . . . . . 359 7 adding a data source using DistSQL? . . . . . . . . . . . . . . . 362 7.8.19 [DistSQL] How to solve Resource [xxx] is still used by [Sin- gleTableRule]. exception when dropping a data source using DistSQL DistSQL is divided into RDL, RQL and RAL. • RDL (Resource & Rule Definition Language) responsible for the definition of resources and rules; • RQL (Resource & Rule Query Language) responsible for the query

Proxy 使用 Navicat 等第三方数据库工具连接 ShardingSphere‐Proxy 时，如果 ShardingSphere‐Proxy 没有创建 Database 或者没有添加 Resource，连接失败？ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 423 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 426 8.5.2 DistSQL 使用 DistSQL 删除资源时，出现 Resource [xxx] is still used by [SingleTableRule]。 . . . . . . . . . . . . . . . . . . . . . . . . . . ShardingSphereDataSource；或者将 ShardingSphereDataSource 配置在 JPA、Hibernate、MyBatis 等 ORM 框架中配合使用。 @Resource private DataSource dataSource; 4.1. ShardingSphere-JDBC 103 Apache ShardingSphere document, v5

connect to ShardingSphere‐Proxy, if ShardingSphere‐Proxy does not create a Schema or does not add a Resource, the client connection will fail? . . . . . . . . . . . . . . . . . . . . . . . . . . . 347 7 adding a data source using DistSQL? . . . . . . . . . . . . . . . 350 7.8.19 [DistSQL] How to solve Resource [xxx] is still used by [Sin- gleTableRule]. exception when dropping a data source using DistSQL DistSQL is divided into RDL, RQL and RAL. • RDL (Resource & Rule Definition Language) responsible for the definition of resources and rules; • RQL (Resource & Rule Query Language) responsible for the query

DistSQL is divided into RDL, RQL and RAL. • RDL (Resource & Rule Definition Language) responsible for the definition of resources and rules; • RQL (Resource & Rule Query Language) responsible for the query query of resources and rules; • RAL (Resource & Rule Administration Language) responsible for the added‐on administrator fea‐ ture of hint, transaction type switch, sharding execute planning and so on TABLE t_order CHECK TABLE t_order SET RESOURCE GROUP group_name DROP RESOURCE GROUP group_name CREATE RESOURCE GROUP group_name TYPE = SYSTEM ALTER RESOURCE GROUP rg1 VCPU = 0‐63 4.1. DB Compatibility

[Proxy] 使用 Navicat 等第三方数据库工具连接 ShardingSphere‐Proxy 时，如果 ShardingSphere‐Proxy 没有创建 Schema 或者没有添加 Resource，连接失败？ . 317 7.8.8 [分片] Cloud not resolve placeholder ⋯in string value ⋯异常的解决方法? . . . . 318 7 . . . . . . . . . . . . . . . . . . . . . . . . . . . 320 7.8.19 [DistSQL] 使用 DistSQL 删除资源时，出现 Resource [xxx] is still used by [SingleTableRule]。 . . . . . . . . . . . . . . . . . . . . . . . . . . DistSQL 细分为 RDL、RQL 和 RAL 三种类型。 • RDL（Resource & Rule Definition Language）负责资源和规则的创建、修改和删除； • RQL（Resource & Rule Query Language）负责资源和规则的查询和展现； • RAL（Resource & Rule Administration Language）负责 Hint、事务类型切换、分片执行计划查询

[Proxy] 使用 Navicat 等第三方数据库工具连接 ShardingSphere‐Proxy 时，如果 ShardingSphere‐Proxy 没有创建 Schema 或者没有添加 Resource，连接失败？ . 306 7.8.8 [分片] Cloud not resolve placeholder ⋯in string value ⋯异常的解决方法? . . . . 306 7 . . . . . . . . . . . . . . . . . . . . . . . . . . . 309 7.8.19 [DistSQL] 使用 DistSQL 删除资源时，出现 Resource [xxx] is still used by [SingleTableRule]。 . . . . . . . . . . . . . . . . . . . . . . . . . . DistSQL 细分为 RDL、RQL 和 RAL 三种类型。 • RDL（Resource & Rule Definition Language）负责资源和规则的创建、修改和删除； • RQL（Resource & Rule Query Language）负责资源和规则的查询和展现； • RAL（Resource & Rule Administration Language）负责 Hint、事务类型切换、分片执行计划查询

[Proxy] 使用 Navicat 等第三方数据库工具连接 ShardingSphere‐Proxy 时，如果 ShardingSphere‐Proxy 没有创建 Schema 或者没有添加 Resource，连接失败？ . 302 7.8.8 [分片] Cloud not resolve placeholder ⋯in string value ⋯异常的解决方法? . . . . 302 7 . . . . . . . . . . . . . . . . . . . . . . . . . 305 x 7.8.19 [DistSQL] 使用 DistSQL 删除资源时，出现 Resource [xxx] is still used by [SingleTableRule]。 . . . . . . . . . . . . . . . . . . . . . . . . . . DistSQL 细分为 RDL、RQL 和 RAL 三种类型。 • RDL（Resource & Rule Definition Language）负责资源和规则的创建、修改和删除； • RQL（Resource & Rule Query Language）负责资源和规则的查询和展现； • RAL（Resource & Rule Administration Language）负责 Hint、事务类型切换、分片执行计划查询

[Proxy] 使用 Navicat 等第三方数据库工具连接 ShardingSphere‐Proxy 时，如 果 ShardingSphere‐Proxy 没有创建 Schema 或者没有添加 Resource，连接失败？ 290 7.7.8 8. [分片] Cloud not resolve placeholder ⋯in string value ⋯异常的解决方法? . . 290 7.7.9 DistSQL 细分为 RDL、RQL 和 RAL 三种类型。 • RDL（Resource & Rule Definition Language）负责资源和规则的创建、修改和删除； • RQL（Resource & Rule Query Language）负责资源和规则的查询和展现； • RAL（Resource & Rule Administration Language）负责 Hint、事务类型切换、分片执行计划查询 TABLE t_order CHECK TABLE t_order SET RESOURCE GROUP group_name DROP RESOURCE GROUP group_name CREATE RESOURCE GROUP group_name TYPE = SYSTEM ALTER RESOURCE GROUP rg1 VCPU = 0‐63 PostgreSQL PostgreSQL