- 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 Dedicated
A fully-managed cloud DBaaS for predictable workloads
TiDB Serverless
A fully-managed cloud DBaaS for auto-scaling workloads