Using MySQL with Java
summary
JDBC is the standard Java-to-SQL interface and Connector/J exposes roughly 200 tunable parameters (he counts exactly 200) to tweak caching, debugging and performance. Use prepared statements to prevent SQL injection and to reduce client-server chatter; reuse them and use batch inserts for near‑C++ throughput. A single-file disk free checker on GitHub is shown and runs as a service and reporter. MariaDB’s JDBC is newer and does client‑side prepared statements, and use JDBC connection pools and BigDecimal for money.
AI-written summary · about
chapters (16)
- 0:00Introduction
- 3:11What is JDBC
- 5:05Java JDBC demo
- 12:32JDBC connection URL
- 14:01Parameters via properties file
- 16:28Prepared statements benefits
- 19:18Result set handling
- 21:53Reusing prepared statements
- 22:13Batch inserts
- 24:40Batch deletes
- 25:44JDBC performance tuning
- 26:50Debugging slow queries
- 29:37MariaDB JDBC driver
- 31:00Connection pooling tools
- 32:27JPA and Hibernate
- 32:48Q&A
related talks
31mJDBC, What Is It Good For?
01h 05mHigh-Performance JDBC
52mPostgreSQL and Java: Best Practices
41mMariaDB The New MySQL
17mFast database interfacing with MySQL.jl
46mThe State of Java Relational Persistence
37mBuilding Database Applications with Database/SQL
01h 00mMySQL: a checklist for the high-load newcomer