such as Hibernate typically uses a custom query language i.e. the Hibernate Query Language HQL or Enterprise JavaBeans Query Language EJBQL. MYBATIS Design Features MyBatis comes with the following design version of MyBatis from Download MYBATIS. Download the latest version of mysqlconnector from Download MySQL Connector. Unzip the downloaded files to extract .jar files and keep them in appropriate folders/directory .jar files appropriately. Database Setup Create an EMPLOYEE table in any MySQL database using the following syntax − mysql> DROP TABLE IF EXISTS details.student; CREATE TABLE details.student( ID

Usage 28 Apache ShardingSphere ElasticJob document // create registry center. ... } } Wechat Enterprise Notification Strategy Please refer to here for more details. Maven POM: org createScheduleJobConfiguration() { // Create scheduling job configuration, and the use of wechat enterprise notification strategy. JobConfiguration jobConfig = JobConfiguration.newBuilder("myScheduleJob" JobConfiguration createOneOffJobConfiguration() { // Create one-time job configuration, and the use of wechat enterprise notification strategy. JobConfiguration jobConfig = JobConfiguration.newBuilder("myOneOffJob"

integrity and security and is also one of the databases’core technologies. ShardingSphere provides distributed transaction ca‐ pability on top of a single database, which can achieve data security across underlying the data usage experience. Data En‐ cryp‐ tion Data Encryption is a basic way to ensure data security. ShardingSphere provides a set of data encryption solutions that are complete, secure, transparent ultimate 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

Dis‐ tributed Trans‐ action Transactional capability is key to ensuring database integrity and security and is also one of the databases’core technologies. With a hybrid engine based on XA and BASE trans‐ ShardingSphere provides distributed transaction capabilities on top of standalone databases, enabling data security across underlying data sources. Read/write Split‐ ting Read/write splitting can be used to cope different data locations. Data En‐ cryp‐ tion Data Encryption is a basic way to ensure data security. ShardingSphere provides a com‐ plete, transparent, secure, and low‐cost data encryption solution

4.1.4 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 PostgreSQL (sharding, readwrite‐splitting and shadow), transform (data encrypt and mask), authen‐ tication (security, audit and authority), governance (circuit breaker and access limitation and an‐ alyze, QoS and pool, such as DBCP, C3P0, BoneCP, Druid, HikariCP. • Supports any kind of JDBC standard database: MySQL, Oracle, SQLServer, PostgreSQL and any SQL92 followed databases. 1.1. Introduction 2 Apache ShardingSphere

4.1.4 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 openGauss . 4.1.6 Feature Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 PostgreSQL (sharding, readwrite‐splitting and shadow), transform (data encrypt and mask), authen‐ tication (security, audit and authority), governance (circuit breaker and access limitation and an‐ alyze, QoS and

. . . 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 . . . . . . . . . . . . . . . . . ib ut ed T ra ns ac ti on Transactional capability is key to ensuring database integrity and security and is also one of the databases’core technologies. With a hybrid engine based on XA and BASE transac‐ ShardingSphere provides distributed transaction capabilities on top of standalone databases, enabling data security across underlying data sources. Re ad /w ri te S pl it ti ng Read/write splitting can be used

4.1.4 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 openGauss . 4.1.6 Feature Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 PostgreSQL (sharding, readwrite‐splitting and shadow), transform (data encrypt and mask), authen‐ tication (security, audit and authority), governance (circuit breaker and access limitation and an‐ alyze, QoS and

. . . 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 . . . . . . . . . . . . . . . . . ib ut ed T ra ns ac ti on Transactional capability is key to ensuring database integrity and security and is also one of the databases’core technologies. With a hybrid engine based on XA and BASE transac‐ ShardingSphere provides distributed transaction capabilities on top of standalone databases, enabling data security across underlying data sources. Re ad /w ri te S pl it ti ng Read/write splitting can be used

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 languages. Friendlier to DBA, the MySQL version provided now can use any kind of terminal (such as MySQL Command Client, MySQL Workbench, etc.) that is compatible of MySQL protocol to operate data. • Totally