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

. . . 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 . . . . . . . . . . . . . . . . . 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 standard database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 7 Apache ShardingSphere document ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections

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

4.1.4 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 PostgreSQL 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 Currently, MySQL and PostgreSQL (compatible with PostgreSQL‐based databases, such as openGauss) versions are provided. It can use any kind of terminal (such as MySQL Command Client, MySQL Workbench,

4.1.4 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 openGauss . 4.1.6 Feature Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 PostgreSQL connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy

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 database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 1.3. Deployment 7 Apache ShardingSphere document, v5.2.0 ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL to support heterogeneous languages. Currently, MySQL and PostgreSQL pro‐ tocols are provided. It can use any kind of terminal that is compatible with MySQL or PostgreSQL pro‐ tocol to operate data, which

4.1.4 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 openGauss . 4.1.6 Feature Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 PostgreSQL connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy

. . . 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 . . . . . . . . . . . . . . . . . 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 standard database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 7 Apache ShardingSphere document ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections

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 database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 1.3. Deployment 5 Apache ShardingSphere document, v5.2.1 ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL to support heterogeneous languages. Currently, MySQL and PostgreSQL pro‐ tocols are provided. It can use any kind of terminal that is compatible with MySQL or PostgreSQL pro‐ tocol to operate data, which

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"