sormula : Home

sormula

simple (easy) object relational mapping

Simple to program:

CRUD-ready: select, insert, update, and delete (more complex operations are available)
Annotate only what differs from the defaults (convention over configuration)
Accomplish almost everything with two classes (Database and Table) and a few annotations
No JPQL, HQL, OQL, etc.
No SQL required (custom SQL allowed)
No inheritance/interfaces required (active record uses inheritance; lazy loading uses interface)
No DAO's to implement
Zero configuration is possible (no configuration files, no SQL, no annotations, no inheritance/interfaces)
Use Active record pattern for the simplest approach (see Active Record Example)

Simple to configure:

Simple to understand:

Works with any relational database:

Features:

Single row operations
Multiple row operations through java.util.Collection and java.util.Map
Java primatives, date/time, as well as BigDecimal, and Blob
Read/write any Java class as a column (see Joda Time example and TypeTranslator)
Identity column fields are set by Sormula (see Identity Example)
One-to-many and one-to-one relationships with cascading (unlimited levels at pre or post operation)
Simplified IN operator support using java.util.Collection (see Example 4)
Lazy loading with SelectCascade annotation (in standard and active record packages)
Custom behavior for sql operations by overriding org.sormula.operation methods
Custom behavior for cascades by overriding cascade method
Custom cascade(s) by naming your class in cascade annotation
Performance recording and logging for profiling database performance
try-with-resources Statement with Sormula 2.x
Active record pattern supported but not required (see Active Record Example)
Batch insert/update/delete (in standard and active record packages)
Uses java.sql.connection, javax.sql.DataSource, or looks up DataSource from JNDI by name

Automated test suite of 132 tests:

Tested with H2 (included)
Tested with HSQLDB (included)
Tested with Derby (included)
Tested with SQLiteJDBC (included)
Tested with Firebird (test configuration and driver included)
Tested with DB2 (test configuration and driver included)
Tested with Oracle 11g (test configuration and driver included)
Easily run the suite of tests against your database (see add-database.txt in project)

Requirements:

Java SE 1.5 or later for Sormula 1.x
Java SE 1.7 or later for Sormula 2.x
A relational database supporting standard SQL (SQL-92 or later, SQL-99 if using identity columns)
SLF4J for logging (optional)
Apache Ant 1.8 or later (running tests and building from source)
Mercuial 2.0 or later (if making source code changes)

As simple as...