Midao is a framework that was created to simplify development with JDBC. It shields developers from the nuances of vendor JDBC implementations and provides standard JDBC boilerplate code. It is flexible, customizable, and simple and intuitive to use, and provides a lot of functionality: transactions, metadata, type handling, profiling, input/output processing/converting, pooled datasource library support, named parameters, multiple vendor support out of the box, custom exception handling, and overrides. With a single Jar, it supports both JDBC 3.0 (Java 5) and JDBC 4.0 (Java 6). It is well tested, with over 500 unit and functional tests, and is also tested with the latest drivers for Derby, MySQL (MariaDB), PostgreSQL, Oracle, and Microsoft SQL.

This release added a Spring Exception handler (JDBC4, SQL state prefix, and vendor specific), lazy query support, new integration and unit tests (taking the total to over 600), statement/metadata/output handler improvements, and some other changes

Midao – Freecode