JDBC Patterns Library (1997)
A set of reusable JDBC patterns: connection pool, transaction helper, batch insert, and a minimal query builder — all in plain Java with no external dependencies.
javajdbcdatabase
JDBC Patterns Library (1997)
Reusable JDBC patterns in plain Java — what you needed before Spring JdbcTemplate and Hibernate existed.
Contents
ConnectionPool.java— fixed-size pool with health check and reconnectionTransactionHelper.java— wraps a lambda in a commit/rollback transactionBatchInserter.java— type-safe batch insert with configurable flush sizeRowMapper.java— interface + implementations for mapping ResultSet rows to objectsNmsSchema.sql— the NMS database schema (devices, poll_results, alerts, status_changes)