- Describe Database Connector
- Describe TiDB Connector
- Access TiDB via Java
- Describe the benefits of connection pooling
- Handle NULL values in the result set
Introduction
This course guides you through a series concepts and hands-on best practices to implement read and write operations via Java program. It focuses on the JDBC Connector/J driver perspective to get the audience ready to face any ORM frameworks built upon Connector/J.
Free online learning is coming soon!
Private Training is available now. To purchase Private Training, contact sales to build out a custom training plan.
Summary
- Audience: SQL and Java developers
- Level: Intermediate
- Duration: 3 hours
- Prerequisites: Experience with Java programming and SQL
- TiDB Version: v6.x
Course Outline
- Describe the reasons for using prepared statements and their limitations
- Use mysql command line client to prepare, execute, and deallocate prepared statements
- Use prepared statements in your code via the Connector API
- Use batch processing API
- Set SQL Mode to modify the behavior of error output
- Use SHOW WARNINGS and SHOW ERRORS
- Handle Exceptions in Java
Build out a custom training plan? Contact Sales
Module 1: Using Database Connector API
- Describe Database Connector
- Describe TiDB Connector
- Access TiDB via Java
- Describe the benefits of connection pooling
- Handle NULL values in the result set
Module 2: Using Prepared Statements
- Describe the reasons for using prepared statements and their limitations
- Use mysql command line client to prepare, execute, and deallocate prepared statements
- Use prepared statements in your code via the Connector API
- Use batch processing API
Module 3: Handling Exceptions
- Set SQL Mode to modify the behavior of error output
- Use SHOW WARNINGS and SHOW ERRORS
- Handle Exceptions in Java
TiDB Cloud Dedicated
TiDB Cloudのエンタープライズ版。
専用VPC上に構築された専有DBaaSでAWSとGoogle Cloudで利用可能。
TiDB Cloud Serverless
TiDB Cloudのライト版。
TiDBの機能をフルマネージド環境で使用でき無料かつお客様の裁量で利用開始。