In theory, it permits programmers to create more SQL-centric applications, as an alternative to traditional object-relational mapping frameworks (ORM).
It provides an unique type-safe object orientated command API.
Empire-db allows building highly efficient SQL-statements that take full advantage of all database features while eliminating the need for error-prone string operations and literals.
Coupled with DBMS independent record and metadata managment, this leads to an unprecedented level of ease-of-use and compile-time-safety.
Here are some key features of "Apache Empire-db":
Dynamic query definition:
· Intuitive API
Data and metadata access:
· Dynamic beans
· Metadata available through comprehensible and concise object hierarchy
Database schema definition:
· Java object model
What's New in This Release: [ read full changelog ]
· Allow specification of delete action for each DBRelation (ON DELETE CASCADE).
· Extend Record and Column interfaces by Record.isReadOnly() and Column.validate() methods.
· Simplify use of DBCommand:DBCommandParam class.
· Allow expression based indexes.
· Allow to specify the character column length in bytes (Non-Unicode) or chars (Unicode) for DDL generation.