silentsword2020/ormlite-core

Core ORMLite functionality that provides a lite Java ORM in conjunction with ormlite-jdbc or ormlite-android

ORMLite Core

This package provides the core functionality for the JDBC and Android packages. Users that are connecting to SQL databases via JDBC will need to download the ormlite-jdbc package as well. Android users should download the ormlite-android package as well as this core package.

• For more information, visit the ORMLite home page.
• Online documentation can be found off the home page. Here's the getting started information. Here are the Javadocs for the code.
• Browse the code on the git repository.
• Maven packages are published via
• I've published a number of example programs.

ORMLite is easy to use and provides the following features:

• Setup your classes by simply adding Java annotations.
• Powerful abstract Database Access Object (DAO) classes.
• Flexible query builder to easily construct simple and complex queries.
• Supports MySQL, Postgres, Microsoft SQL Server, H2, Derby, HSQLDB, and Sqlite and can be extended to additional databases relatively easily.
• Provisional support for DB2, Oracle, ODBC, and Netezza. Contact the author if your database type is not supported.
• Handles "compiled" SQL statements for repetitive query tasks.
• Supports "foreign" objects with the class field being the object but an id stored in the database table.
• Basic support for database transactions.
• Auto generates SQL to create and drop database tables.
• Spring configuration support for DOAs and class configurations.
• Support for configuring of tables and fields without annotations.
• Supports native calls to Android SQLite database APIs.

Enjoy, Gray Watson

Code Example

The following is a quick code example to give you a taste on how to use the library.

// this uses h2 but you can change it to match your database
String databaseUrl = "jdbc:h2:mem:account";
// create a connection source to our database
ConnectionSource connectionSource = new JdbcConnectionSource(databaseUrl);

// instantiate the DAO to handle Account with String id
Dao<Account,String> accountDao = DaoManager.createDao(connectionSource, Account.class);

// if you need to create the 'accounts' table make this call
TableUtils.createTable(connectionSource, Account.class);

// create an instance of Account
String name = "Jim Smith";
Account account = new Account(name, "_secret");

// persist the account object to the database
accountDao.create(account);

// retrieve the account
Account account2 = accountDao.queryForId(name);
// show its password
System.out.println("Account: " + account2.getPassword());

// close the connection source
connectionSource.close();

ChangeLog Release Notes

See the ChangeLog.txt file.