of TiDB, located between the client and TiDB server. It provides load balancing and connection persistence functions for TiDB, making the workload of the TiDB cluster more balanced and not affecting user Connect to TiDB with JDBC TiDB is a MySQL-compatible database, and JDBC (Java Database Connectivity) is the data access API for Java. MySQL Connector/J is MySQL’s implementation of JDBC. In this tutorial tutorial, you can learn how to use TiDB and JDBC to accomplish the following tasks: • Set up your environment. • Connect to your TiDB cluster using JDBC. • Build and run your application. Optionally, you can

Y Y Y Y Y Y Statements summary tables Y Y Y Y Y Y Y Y Y Statements summary tables - summary persistence E N N N N N N N N Slow query log Y Y Y Y Y Y Y Y Y TiUP deployment Y Y Y Y Y Y Y Y Y Kubernetes Connect to TiDB with JDBC TiDB is a MySQL-compatible database, and JDBC (Java Database Connectivity) is the data access API for Java. MySQL Connector/J is MySQL’s implementation of JDBC. In this tutorial tutorial, you can learn how to use TiDB and JDBC to accomplish the following tasks: • Set up your environment. 139 • Connect to your TiDB cluster using JDBC. • Build and run your application. Optionally, you

src/main/resources). spring: datasource: url: jdbc:mysql://localhost:4000/test username: root # password: xxx driver-class-name: com.mysql.cj.jdbc.Driver jpa: show-sql: true database-platform: org url: jdbc:mysql://xxx.tidbcloud.com:4000/test?sslMode=VERIFY_IDENTITY& �→ enabledTLSProtocols=TLSv1.2,TLSv1.3 username: 2aEp24QWEDLqRFs.root password: 123456 driver-class-name: com.mysql.cj.jdbc.Driver �→ deprecation : HHH90000021: Encountered deprecated setting [javax �→ .persistence.sharedCache.mode], use [jakarta.persistence.sharedCache. �→ mode] instead 2023-01-05T14:06:55.005+08:00 INFO 22005 ---

Connect to TiDB with JDBC TiDB is a MySQL-compatible database, and JDBC (Java Database Connectivity) is the data access API for Java. MySQL Connector/J is MySQL’s implementation of JDBC. In this tutorial tutorial, you can learn how to use TiDB and JDBC to accomplish the following tasks: • Set up your environment. 119 • Connect to your TiDB cluster using JDBC. • Build and run your application. Optionally, you the sample code reposi- tory: git clone https://github.com/tidb-samples/tidb-java-jdbc-quickstart.git cd tidb-java-jdbc-quickstart Step 2: Configure connection information Connect to your TiDB cluster

Connect to TiDB with JDBC TiDB is a MySQL-compatible database, and JDBC (Java Database Connectivity) is the data access API for Java. MySQL Connector/J is MySQL’s implementation of JDBC. In this tutorial tutorial, you can learn how to use TiDB and JDBC to accomplish the following tasks: • Set up your environment. • Connect to your TiDB cluster using JDBC. • Build and run your application. Optionally, you can the sample code reposi- tory: git clone https://github.com/tidb-samples/tidb-java-jdbc-quickstart.git cd tidb-java-jdbc-quickstart Step 2: Configure connection information Connect to your TiDB cluster

of TiDB, located between the client and TiDB server. It provides load balancing and connection persistence functions for TiDB. Before v8.2.0, TiProxy defaults to v1.0.0, which only supports status-based Connect to TiDB with JDBC TiDB is a MySQL-compatible database, and JDBC (Java Database Connectivity) is the data access API for Java. MySQL Connector/J is MySQL’s implementation of JDBC. In this tutorial tutorial, you can learn how to use TiDB and JDBC to accomplish the following tasks: • Set up your environment. • Connect to your TiDB cluster using JDBC. • Build and run your application. Optionally, you can

Connect to TiDB with JDBC TiDB is a MySQL-compatible database, and JDBC (Java Database Connectivity) is the data access API for Java. MySQL Connector/J is MySQL’s implementation of JDBC. In this tutorial tutorial, you can learn how to use TiDB and JDBC to accomplish the following tasks: • Set up your environment. • Connect to your TiDB cluster using JDBC. • Build and run your application. Optionally, you can the sample code reposi- tory: git clone https://github.com/tidb-samples/tidb-java-jdbc-quickstart.git cd tidb-java-jdbc-quickstart Step 2: Configure connection information Connect to your TiDB cluster

of TiDB, located between the client and TiDB server. It provides load balancing and connection persistence functions for TiDB, making the workload of the TiDB cluster more balanced and not affecting user Connect to TiDB with JDBC TiDB is a MySQL-compatible database, and JDBC (Java Database Connectivity) is the data access API for Java. MySQL Connector/J is MySQL’s implementation of JDBC. In this tutorial tutorial, you can learn how to use TiDB and JDBC to accomplish the following tasks: • Set up your environment. 147 • Connect to your TiDB cluster using JDBC. • Build and run your application. Optionally, you

Connect to TiDB with JDBC TiDB is a MySQL-compatible database, and JDBC (Java Database Connectivity) is the data access API for Java. MySQL Connector/J is MySQL’s implementation of JDBC. In this tutorial tutorial, you can learn how to use TiDB and JDBC to accomplish the following tasks: • Set up your environment. • Connect to your TiDB cluster using JDBC. • Build and run your application. Optionally, you can the sample code reposi- tory: git clone https://github.com/tidb-samples/tidb-java-jdbc-quickstart.git cd tidb-java-jdbc-quickstart Step 2: Configure connection information Connect to your TiDB cluster

Connect to TiDB with JDBC TiDB is a MySQL-compatible database, and JDBC (Java Database Connectivity) is the data access API for Java. MySQL Connector/J is MySQL’s implementation of JDBC. In this tutorial tutorial, you can learn how to use TiDB and JDBC to accomplish the following tasks: • Set up your environment. 118 • Connect to your TiDB cluster using JDBC. • Build and run your application. Optionally, you the sample code reposi- tory: git clone https://github.com/tidb-samples/tidb-java-jdbc-quickstart.git cd tidb-java-jdbc-quickstart Step 2: Configure connection information Connect to your TiDB cluster