approbatis

Approbatis is a hypothetical software framework designed to provide a lightweight, SQL-centric approach to data access in object-oriented applications. The name combines “approach” with a reference to SQL-mapping concepts associated with similar frameworks. In theoretical discussions, approbatis is presented as an alternative to full-featured ORMs, prioritizing explicit SQL control while offering object-relational mapping for domain models.

Core ideas include separating SQL statements from business logic, either via annotation-based mappings or external configuration files. A developer writes SQL statements that are mapped to domain objects and methods, and the framework binds result sets to objects. It emphasizes clarity and testability, with support for parameter binding, result mapping, and straightforward transaction integration.

Architecturally, approbatis is imagined to comprise a mapping engine, a session facade, and an executor component. The mapping engine parses statements and maps columns to properties; the session provides a context for executing statements; the executor performs JDBC operations and handles batching, caching, and lazy loading according to configuration. Caching layers may be optional, and transactions can be coordinated with existing transaction managers.

In practice, approbatis is used in hypothetical code bases to illustrate how SQL-driven data access can coexist with object-oriented design. While it has not been implemented as a mainstream framework, the concept helps compare approaches to data persistence, especially the trade-offs between control over SQL and automation of object mapping.

See also: MyBatis, Hibernate, SQL mapping, JDBC.