javaxsql

javaxsql is a Java library that provides a high-level API for interacting with relational databases using SQL. Built on top of the JDBC API, it aims to reduce boilerplate, improve type safety, and streamline common database tasks without requiring a full ORM.

The library offers a fluent, SQL-centric programming model. It emphasizes concise database access patterns such as parameterized queries, batch updates, and transparent transaction management. Developers write SQL statements using a fluent interface and bind parameters without manual boilerplate, while result sets are mapped to user-defined Java types either through simple mappers or lightweight annotations.

Design goals include portability across databases via a dialect layer, and seamless integration with existing JDBC drivers and DataSource configurations. The core API handles connection lifecycle, statement preparation, and error translation, allowing applications to focus on business logic rather than low-level JDBC details.

Typical usage involves obtaining a DataSource, constructing a Database or SqlClient instance, and executing queries to fetch or modify data. The API supports single-row queries, multi-row maps to POJOs, and batch operations, with built-in support for transactions that can be composed or nested.

javaxsql is designed to complement Java's database tools by providing an approachable alternative to raw JDBC for developers who need direct SQL control without the overhead of a full ORM. It aims to be lightweight, fast, and easy to adopt in projects ranging from small utilities to enterprise services.

See also: JDBC, javax.sql, SQL, DataSource, Java persistence technologies.