sormula : Features

sormula	simple (easy) object relational mapping
Features Requirements How To Zero Configuration Single Row DAO Collection Pagination Custom SQL (Parameter) Custom SQL (Class) Variable IN Parameters Active Record Identity Column One To Many Download Support License Contact About	Basic Features: Use stand-alone or in web container Single row operations Multiple row operations through java.util.Collection and java.util.Map Java primitives, date/time, Enum, as well as BigDecimal, and Blob Can be mixed with JDBC Identity column fields are set by Sormula (see Identity Example) Simplified IN operator support using java.util.Collection (see Example 4) Implements java.lang.AutoCloseable for try-with-resources statement Active record pattern supported but not required (see Active Record Example) Use java.sql.Connection, javax.sql.DataSource, or JNDI for-each loops with SelectOperation (implements java.lang.Iterable) Advanced Features: Read/write any Java class as a column One-to-many and one-to-one relationships with cascading (unlimited levels) Read-only and read-write caching by table Lazy loading with SelectCascade annotation Custom cascades by overriding cascade method or by specifying your cascade class Performance recording and logging for profiling database performance Batch insert/update/delete Custom behavior by overriding org.sormula.operation methods Conditional cascading with named cascades Cascades can set foreign key values and foreign key references Select filters as lambda expressions Automated Test Suite of More Than 200 Tests: Tested with H2 (included) Tested with HSQLDB (included) Tested with Derby (included) Tested with SQLiteJDBC (included) Tested with MySQL (test configuration and driver included) Tested with MariaDB (test configuration and driver included) Tested with PostgreSQL (test configuration and driver 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)

© 2018 Sormula, LLC