ORMLite

ORMLite

Stable release	4.30 / November 10, 2011; 1 day ago (2011-11-10)
Written in	Java
Operating system	Cross-platform
Type	Object-relational mapping
License	ISC license
Website	http://ormlite.com/

ORMLite is an open source software framework that provides lightweight object relational mapping (ORM) between Java classes and SQL databases. It supports JDBC databases as well as Android mobile platform. The software project was started with the goal of providing a simple yet powerful wrapper around the JDBC functions without the complexity of other frameworks such as Hibernate and iBATIS.

ORMLite supports JDBC connections to MySQL, PostgreSQL, Microsoft SQL Server, H2, Derby, HSQLDB, and SQLite and can be extended to additional databases relatively easily. There are also initial implementations for DB2 and Oracle. It has a separate database backend which also supports native database calls on Android OS. You can contact the author of ORMLite if your database is not supported.

Features

ORMLite provides the following features:

• You configure your database classes by simply adding Java annotations. Configuration using code or Spring also works.
• Tables are accessed with powerful abstract Data Access Object classes.
• A flexible database query builder is provided with which you can easily construct simple and complex queries.
• You can compile SQL statements for repetitive query tasks.
• Basic support for database transactions.
• Create and drop database tables with the help of statements generated by the framework.
• Spring framework configurations are supported for your DOAs and classes.

External links

• ORMLite home page with online documentation and examples
• SourceForge project page for ORMLite with downloads and bug tracking
• ORMLite users mailing list for asking questions of the user community
• Android OS support information