ArticlesProjectsWeeklyCredentialsAbout

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 reconnection
  • TransactionHelper.java — wraps a lambda in a commit/rollback transaction
  • BatchInserter.java — type-safe batch insert with configurable flush size
  • RowMapper.java — interface + implementations for mapping ResultSet rows to objects
  • NmsSchema.sql — the NMS database schema (devices, poll_results, alerts, status_changes)
Source code
# JDBC Patterns Library (1997)

```sh
mkdir -p build
find src -name '*.java' | xargs javac -d build -cp lib/mysql-connector.jar:.
```

See `NmsSchema.sql` to create the database, then use `ConnectionPool` and
`BatchInserter` from your application code.
← All projects