This article analyzes MySQL Connector/J's timezone handling changes from 5.1 to 8.x, details the official bug #30962953 affecting versions 8.0.0-8.0.22, explains key parameters like serverTimezone and preserveInstants, and provides best practices for correct timestamp storage and retrieval.
This article details MySQL Connector/J's timezone handling bug in versions 8.0.0-8.0.22, explains key JDBC parameters like serverTimezone and preserveInstants, and provides best-practice configurations to avoid timestamp shifts and zero-date errors when upgrading from MySQL 5.1.
An in‑depth investigation reveals that Spring’s @Transactional rollback can silently fail due to a bug in mysql‑connector‑java 8.0.28 when useLocalSessionState=true, causing auto‑commit to stay enabled; the article explains the root cause, debugging steps, and how upgrading to 8.0.29 resolves the issue.
This article examines how MySQL Connector/J determines the character set during connection initialization, explains the transition from UTF8MB3 to UTF8MB4, analyzes source code of versions 5.1.46 and 5.1.47, and provides practical methods to enable UTF8MB4 without upgrading the driver.
After upgrading MySQL Connector/J from 8.0.18 to 8.0.20 on IBM JDK 1.8, SSL handshake failures occur due to mismatched cipher suite naming, and the article details analysis of MySQL and IBM JSSE2 TLS settings, packet captures, and multiple remediation strategies including JVM parameters and JDK upgrades.
