Tagged articles

AI-generated SQL

2 articles · Page 1 of 1

Oct 12, 2026 · Backend Development

AI-Generated SQL Locks Database, Exhausts Tomcat Connection Pool: Production Post-Mortem

A production post-mortem reveals how AI-generated SQL caused long-running queries that locked SQL Server, exhausted Tomcat's 300-connection pool, and repeatedly hung the service until restart; the article details root-cause analysis, missing SQL execution timeout, and fixes including connection pool abandonment recovery, query optimization, and monitoring alerts.

AI-generated SQLSQL ServerTomcat connection pool

0 likes · 8 min read

AI-Generated SQL Locks Database, Exhausts Tomcat Connection Pool: Production Post-Mortem

StarRocks

Sep 2, 2026 · Databases

Why AI-Generated SQL Isn't Enough: Semantic Views Bridge the Business Logic Gap

This article explains why syntactically correct AI-generated SQL often fails to reflect business logic, introduces StarRocks' Semantic View as an executable 'information contract' that defines metrics, relationships, and synonyms, and demonstrates with a fishing gear example how it enables deterministic SQL expansion for both AI agents and BI tools.

AI-generated SQLBusiness LogicInformation Contract

0 likes · 15 min read

Why AI-Generated SQL Isn't Enough: Semantic Views Bridge the Business Logic Gap