. . . . . . . . . 294 7.7 In addition to internal distributed primary key, does ShardingSphere support other na‐ tive auto‐increment keys? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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, Oracle transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages. Friendlier to DBA, the MySQL version provided now can use any kind of terminal

. . . . . . . . . . . . . . . . . . . . . . . . . . . 65 Column shadow algorithm DML statement support list . . . . . . . . . . . . . . 65 5 User Manual 67 5.1 ShardingSphere‐JDBC . . . . . . . . . 307 7.7.15 15. [Sharding] In addition to internal distributed primary key, does Sharding‐ Sphere support other native auto‐increment keys? . . . . . . . . . . . . . . . . 307 7.7.16 16. [Encryption] How transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages. Currently, MySQL and PostgreSQL (compatible with PostgreSQL‐based databases

Stable Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 Experimental Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Do not Support . . . property? . 459 8.3.9 Sharding In addition to internal distributed primary key, does ShardingSphere support other native auto‐increment keys? . . . . . . . . . . . . . . . . . . . . 459 8.4 Encryption . 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‐ ing Data

Stable Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 Experimental Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 Do not Support . . . property? . 498 8.3.9 Sharding In addition to internal distributed primary key, does ShardingSphere support other native auto‐increment keys? . . . . . . . . . . . . . . . . . . . . 498 8.4 Encryption . 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 Fea-

Protocol . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 4.1.6 Feature Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 MySQL . . . . . . . . property?349 7.8.16 [Sharding] In addition to internal distributed primary key, does ShardingSphere support other native auto‐increment keys? . . . . . . . . . . . . . . . . . . . . 350 7.8.17 [Encryption] JDBC; • Supports any third‐party database connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases

Stable Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 Experimental Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Do not Support . . . property? . 551 13.4.9 Sharding In addition to internal distributed primary key, does ShardingSphere support other native auto‐increment keys? . . . . . . . . . . . . . . . . . . . . 551 13.5 DistSQL . . 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 ea tu re Definition

Stable Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 Experimental Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Do not Support . . . property? . 580 13.3.9 Sharding In addition to internal distributed primary key, does ShardingSphere support other native auto‐increment keys? . . . . . . . . . . . . . . . . . . . . 580 13.4 Single table 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 ea tu re Definition

Protocol . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 4.1.6 Feature Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 MySQL . . . . . . . . property?361 7.8.16 [Sharding] In addition to internal distributed primary key, does ShardingSphere support other native auto‐increment keys? . . . . . . . . . . . . . . . . . . . . 362 7.8.17 [Encryption] JDBC; • Supports any third‐party database connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases

Job API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Job Development . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Use Java API . . . . Listener . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 Listener Development . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 Use Java API . . . . . . . Things . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88 9.2.12 Software Development Services . . . . . . . . . . . . . . . . . . . . . . . . . . . 88 9.2.13 Health Care . . . .

retrieving the results. It provides a simple API to interact with the database. It also provides support for custom SQL, stored procedures and advanced mappings. It was formerly known as IBATIS, which one of the simplest persistence frameworks available today. Fast Development − MyBatis does all it can to facilitate hyper-fast development. Portability − MyBatis can be implemented for nearly any language You would have to set up a proper environment for MyBatis before starting off with the actual development work. This chapter explains how to set up a working environment for MyBatis. MyBatis Installation