driver, which is fully compatible with JDBC and all kinds of ORM frameworks. • Applicable in any ORM framework based on JDBC, such as JPA, Hibernate, Mybatis, Spring JDBC Template or direct use of JDBC. implements DataSource interface of JDBC. It can be used for native JDBC or JPA, MyBatis and other ORM frameworks. DataSource dataSource = ShardingSphereDataSourceFactory. createDataSource(dataSourceMap driver, which is fully compatible with JDBC and all kinds of ORM frameworks. • Applicable in any ORM framework based on JDBC, such as JPA, Hibernate, Mybatis, Spring JDBC Template or direct use of JDBC.

driver, which is fully compatible with JDBC and all kinds of ORM frameworks. • Applicable in any ORM framework based on JDBC, such as JPA, Hibernate, Mybatis, Spring JDBC Template or direct use of JDBC; which implements DataSource interface of JDBC. It can be used for native JDBC or JPA, Hibernate, MyBatis and other ORM frameworks. DataSource dataSource = ShardingSphereDataSourceFactory. createDataSource(schemaName driver, which is fully compatible with JDBC and all kinds of ORM frameworks. • Applicable in any ORM framework based on JDBC, such as JPA, Hibernate, Mybatis, Spring JDBC Template or direct use of JDBC;

compatible with JDBC and all kinds of ORM frameworks. 1 Apache ShardingSphere document, v5.0.0-beta • Applicable in any ORM framework based on JDBC, such as JPA, Hibernate, Mybatis, Spring JDBC Template implements DataSource interface of JDBC. It can be used for native JDBC or JPA, MyBatis and other ORM frameworks. DataSource dataSource = ShardingSphereDataSourceFactory. createDataSource(dataSourceMap xxx AS (SELECT ...) pagination. Because SQLServer automatically gen‐ erated by Hibernate uses WITH statements, Hibernate SQLServer pagination or two TOP + sub‐query pagination is not available now. •

driver, which is fully compatible with JDBC and all kinds of ORM frameworks. • Applicable in any ORM framework based on JDBC, such as JPA, Hibernate, Mybatis, Spring JDBC Template or direct use of JDBC; driver, which is fully compatible with JDBC and all kinds of ORM frameworks. • Applicable in any ORM framework based on JDBC, such as JPA, Hibernate, Mybatis, Spring JDBC Template or direct use of JDBC; xxx AS (SELECT ...) pagination. Because SQLServer automatically gen‐ erated by Hibernate uses WITH statements, Hibernate SQLServer pagination or two TOP + sub‐query pagination is not available now. •

层提供的额外服务。它使用客户端直连数据库，以 jar 包形式 提供服务，无需额外部署和依赖，可理解为增强版的 JDBC 驱动，完全兼容 JDBC 和各种 ORM 框架。 • 适用于任何基于 JDBC 的 ORM 框架，如：JPA, Hibernate, Mybatis, Spring JDBC Template 或直接 使用 JDBC。 • 支持任何第三方的数据库连接池，如：DBCP, C3P0 对 象 获 取 ShardingSphereDataSource。该对象实现自 JDBC 的标准 DataSource 接口，可用于原生 JDBC 开发，或使用 JPA, MyBatis 等 ORM 类库。 DataSource dataSource = ShardingSphereDataSourceFactory. createDataSource(dataSourceMap, configurations ROW FETCH NEXT ? ROWS ONLY 目前不支持使用 WITH xxx AS (SELECT ⋯) 的方式进行分页。由于 Hibernate 自动生成的 SQLServer 分 页语句使用了 WITH 语句，因此目前并不支持基于 Hibernate 的 SQLServer 分页。目前也不支持使用两 个 TOP + 子查询的方式实现分页。 • MySQL, PostgreSQL

· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 257 4.4.1 Choose Driver or ORM · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 257 4.4.2 Connect blocking, waiting, and other lock management capabilities. User-level locks are also widely used in ORM frameworks, such as Rails, Elixir, and Ecto. Since v6.1.0, TiDB has supported MySQL- compatible user-level that support MySQL are also compatible with TiDB. 4.1.4 Read More • Quick Start • Choose Driver or ORM • Connect to TiDB • Database Schema Design • Write Data • Read Data • Transaction • Optimize • Example

层提供的额外服务。它使用客户端直连数据库，以 jar 包形式 提供服务，无需额外部署和依赖，可理解为增强版的 JDBC 驱动，完全兼容 JDBC 和各种 ORM 框架。 • 适用于任何基于 JDBC 的 ORM 框架，如：JPA, Hibernate, Mybatis, Spring JDBC Template 或直接 使用 JDBC。 • 支持任何第三方的数据库连接池，如：DBCP, C3P0 对 象 获 取 ShardingSphereDataSource。该对象实现自 JDBC 的标准 DataSource 接口，可用于原生 JDBC 开发，或使用 JPA, MyBatis 等 ORM 类库。 DataSource dataSource = ShardingSphereDataSourceFactory. createDataSource(dataSourceMap, configurations 层提供的额外服务。它使用客户端直连数据库，以 jar 包形式 提供服务，无需额外部署和依赖，可理解为增强版的 JDBC 驱动，完全兼容 JDBC 和各种 ORM 框架。 • 适用于任何基于 JDBC 的 ORM 框架，如：JPA, Hibernate, Mybatis, Spring JDBC Template 或直接 使用 JDBC。 • 支持任何第三方的数据库连接池，如：DBCP, C3P0

· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 269 4.4.2 Choose Driver or ORM · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 330 4.4.3 Connect that support MySQL are also compatible with TiDB. 4.1.4 Read more • Quick Start • Choose Driver or ORM • Connect to TiDB • Database Schema Design • Write Data • Read Data • Transaction • Optimize • Example execute(); } 143 } For more information, refer to Delete data. 4.3.1.1.4 Useful notes Using driver or ORM framework? The Java driver provides low-level access to the database, but it requires the developers

· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 285 4.4.2 Choose Driver or ORM · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 345 4.4.3 Connect that support MySQL are also compatible with TiDB. 4.1.4 Read more • Quick Start • Choose Driver or ORM • Connect to TiDB • Database Schema Design • Write Data • Read Data • Transaction • Optimize • Example execute(); } } For more information, refer to Delete data. 4.3.1.1.4 Useful notes Using driver or ORM framework? The Java driver provides low-level access to the database, but it requires the developers

· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 280 4.4.2 Choose Driver or ORM · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 340 4.4.3 Connect that support MySQL are also compatible with TiDB. 4.1.4 Read more • Quick Start • Choose Driver or ORM • Connect to TiDB • Database Schema Design • Write Data • Read Data • Transaction • Optimize • Example execute(); } } For more information, refer to Delete data. 4.3.1.1.4 Useful notes Using driver or ORM framework? The Java driver provides low-level access to the database, but it requires the developers