2.7 Core Concept . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 XA Protocol . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 8.2.8 Limitations . . . 575 13.1.3 JDBC SQLException: Unable to unwrap to interface com.mysql. jdbc.Connection exception thrown when using MySQL XA transaction . . . 576 13.2 Proxy . . . . . . . . . . . . . . . . . is a transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages. 1 Apache ShardingSphere document 1.2 Product Features F

2.7 Core Concept . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 XA Protocol . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 8.2.8 Limitations . . . 547 13.2.3 JDBC SQLException: Unable to unwrap to interface com.mysql. jdbc.Connection exception thrown when using MySQL XA transaction . . . 547 13.3 Proxy . . . . . . . . . . . . . . . . . is a transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages. 1 Apache ShardingSphere document 1.2 Product Features F

4.1.4 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 PostgreSQL SQL92 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 4.1.5 DB Protocol . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 4.2 Sharding . . the core of the project are Link, Enhance and Pluggable. • Link: Flexible adaptation of database protocol, SQL dialect and database storage. It can quickly link applications and multi‐mode heterogeneous

2.7 Core Concept . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 XA Protocol . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 3.2.8 Limitations is a transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages. 1 Apache ShardingSphere document, v5.2.1 1.1.2 Product Features performance. • Ecosystem Compatibility The proxy can be accessed by any application using MySQL/PostgreSQL protocol, and the driver can connect to any database that implements JDBC specifications. 1.1.

4.1.4 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 openGauss . 1.5 DB Protocol . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 4.1.6 Feature Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 MySQL . . . core of the project are Connect, Enhance and Pluggable. • Connect: Flexible adaptation of database protocol, SQL dialect and database storage. It can quickly connect applications and heterogeneous databases

4.1.4 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 openGauss . 1.5 DB Protocol . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 4.1.6 Feature Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 MySQL . . . core of the project are Connect, Enhance and Pluggable. • Connect: Flexible adaptation of database protocol, SQL dialect and database storage. It can quickly connect applications and heterogeneous databases

sharding, replica query, data en‐ crypt, shadow database, and SQL dialects / database protocols such as MySQL, PostgreSQL, SQLServer, Oracle supported are all weaved by plugins. Developers can customize their pool, such as DBCP, C3P0, BoneCP, Druid, HikariCP. • Support any kind of JDBC standard database: MySQL, Oracle, SQLServer, PostgreSQL and any SQL92 followed databases. 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy encapsulates database binary protocol to support heterogeneous languages. Friendlier to DBA, the MySQL version provided now can use any kind of terminal (such as MySQL Command Client, MySQL Workbench, etc.) that

2.7 Core Concept . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 XA Protocol . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 3.2.8 Limitations is a transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages. 1.1.2 Product Features Fea- ture Definition Data Shard‐ performance. • Ecosystem Compatibility The proxy can be accessed by any application using MySQL/PostgreSQL protocol, and the driver can connect to any database that implements JDBC specifications. • Zero

JDBC Oracle 表名、字段名配置大小写在加载 metadata 元数据时结果不正确？ 531 13.1.3 JDBC 使用 MySQL XA 事务时报 SQLException: Unable to unwrap to interface com.mysql.jdbc.Connection 异常 . . . . . . . . . . . . . . . 532 13.2 Proxy 二进制协议，对异构语言提供支 持。 1.2 产品功能 1.3 产品优势 • 极致性能 驱动程序端历经长年打磨，效率接近原生 JDBC，性能极致。 • 生态兼容 代理端支持任何通过 MySQL/PostgreSQL 协议的应用访问，驱动程序端可对接任意实现 JDBC 规范的数 据库。 1 Apache ShardingSphere document • 业务零侵入 面对数据库替换场景，ShardingSphere • 支持任意实现 JDBC 规范的数据库，目前支持 MySQL，PostgreSQL，Oracle，SQLServer 以及任何 可使用 JDBC 访问的数据库。 6 Apache ShardingSphere document ShardingSphere-JDBC ShardingSphere-Proxy 数据库 任意 MySQL/PostgreSQL 连接消耗数 高 低 异构语言

JtaTransactionManager？ . . . . . . . . . . . . . . . . . . 505 13.2.2 JDBC 使用 MySQL XA 事务时报 SQLException: Unable to unwrap to interface com.mysql.jdbc.Connection 异常 . . . . . . . . . . . . . . . 506 13.3 Proxy 二进制协议，对异构语言提供支 持。 1.2 产品功能 1.3 产品优势 • 极致性能 驱动程序端历经长年打磨，效率接近原生 JDBC，性能极致。 • 生态兼容 代理端支持任何通过 MySQL/PostgreSQL 协议的应用访问，驱动程序端可对接任意实现 JDBC 规范的数 据库。 1 Apache ShardingSphere document • 业务零侵入 面对数据库替换场景，ShardingSphere • 支持任意实现 JDBC 规范的数据库，目前支持 MySQL，PostgreSQL，Oracle，SQLServer 以及任何 可使用 JDBC 访问的数据库。 6 Apache ShardingSphere document ShardingSphere-JDBC ShardingSphere-Proxy 数据库 任意 MySQL/PostgreSQL 连接消耗数 高 低 异构语言