Groovy Database

Groovy database programming with groovy.sql.Sql. CRUD operations, transactions, batch processing, stored procedures, connection pooling, and DataSet.

Groovy SQL Update and Delete – 13 Tested Examples with H2

Avatar for RahulGroovy
Groovy SQL update and delete operations with 13+ examples. Covers executeUpdate, parameterized queries, batch updates, and soft deletes. Tested on Groovy 5.x. “The ability to destroy data is just as important as the ability to create it. The trick is knowing which rows to touch.” C.J. Date, Database Relational Model Last Updated: March 2026 | Tested on: Groovy 5.x, Java 17+ | Difficulty: Intermediate | Reading Time: 25 minutes So you’ve connected to a database and you know how to ... Read More

Groovy SQL Transactions and Connection Pooling with 10+ Examples

Avatar for RahulGroovy
Groovy SQL transactions and connection pooling with 10+ examples. Learn withTransaction, savepoints, HikariCP integration, withBatch. “In databases, a transaction is a promise — all or nothing.” — Unknown Jim Gray, Transaction Processing Pioneer Last Updated: March 2026 | Tested on: Groovy 5.x, Java 17+ | Difficulty: Intermediate to Advanced | Reading Time: 19 minutes In the first tutorial we connected to databases and queried data. In the second tutorial we mastered CRUD operations. Now it is time to tackle the ... Read More

Groovy SQL CRUD – Insert, Update, Delete with 10+ Examples

Avatar for RahulGroovy
Groovy SQL insert, update, delete, and read (CRUD) operations with 10+ examples. Learn execute(), executeInsert(), executeUpdate(), batch inserts, transactions, and prepared statements. “Create, Read, Update, Delete — four operations that power every application.” — Unknown Martin Fowler, Patterns of Enterprise Architecture Last Updated: March 2026 | Tested on: Groovy 5.x, Java 17+ | Difficulty: Intermediate | Reading Time: 18 minutes Querying a database is only half the story – real applications need groovy sql insert, update, and delete operations too. ... Read More