This article explains why MySQL throws "Incorrect string value" when storing emojis, how utf8mb4 solves the problem, and provides step‑by‑step instructions—including table conversion, my.cnf changes, connector upgrades, and runtime workarounds—for reliable emoji storage.
This article examines three real‑world MySQL deadlock incidents—unique‑key null insertion, concurrent duplicate‑key insertion, and a JDBC parameter bug—detailing their detection, analysis, and the concrete fixes applied to prevent recurrence.
This article, the fifth in a static code scanning series, explains six special scenarios—custom close utilities, methods returning resources, streams that need not be closed, nested stream closures, JDBC statement/result set relationships, and socket streams—that complicate determining whether Java resources have been properly closed.
This article explains how to configure client‑side and server‑side Connect Time Load Balancing for Oracle RAC across versions, details the role of SCAN, local_listener and remote_listener settings, describes Runtime Connection Load Balancing with FAN and LBA events, and shows how to tune TCP timeout parameters.
This article explains the principles, architecture, and performance of Sharding-JDBC, covering sharding scenarios, rule configuration, JDBC rewriting, SQL parsing and routing, result merging, and future roadmap, while comparing it with other open‑source sharding solutions.
Phoenix adds a SQL layer to HBase, enabling easy table creation, data import, and complex queries via JDBC, with features like secondary indexes and integration with Spark, Hive, and more, illustrated through step‑by‑step examples and sample code.
MySQL normally loads an entire query result into memory, which can cause out‑of‑memory errors on large tables, but by adding the -q option in the console, enabling useCursorFetch in JDBC URLs, and setting stmt.setFetchSize(Integer.MIN_VALUE), you can switch to a streaming mode that returns rows one at a time.
Sharding-JDBC is a client‑side Java framework that provides transparent horizontal sharding for relational databases, offering flexible sharding strategies, SQL parsing and rewriting, multi‑threaded execution, result merging, and high performance while requiring no additional deployment or proxy layers.
