- 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? 영업 담당자에게 문의하세요.
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 전용
예측 가능한 워크로드를 위한 완전 관리형 클라우드 DBaaS
TiDB Cloud 스타터
워크로드 자동 확장을 위한 완전 관리형 클라우드 DBaaS