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.
External links
