JaQu Comparison
This is an overview of the fundamental differences between the original JaQu project and the current feature set of iciql.
Iciql | JaQu | |
---|---|---|
core | ||
deployment | small, discrete library | depends on H2 database jar file |
databases | H2, HSQL, Derby, MySQL, PostreSQL, and SQLite | H2 only |
logging | console, SLF4J, or custom logging | console logging |
exceptions | always includes generated statement in exception, when available | -- |
column mappings | wildcard queries index result sets by column name | all result sets built by field index this can fail for wildcard queries |
savepoints | bulk operations (insert, update, delete) use savepoints with rollback in the event of failure | -- |
syntax and api | ||
VIEWs | create readonly views either from a class definition or from a fluent statement | -- |
Foreign Key Constraints | model classes may be annotated with foreign key constraints | -- |
dynamic queries | methods and where clauses for dynamic queries that build iciql objects | -- |
DROP | syntax to drop a table or view | |
BETWEEN | syntax for specifying a BETWEEN x AND y clause | -- |
(NOT) IN | syntax (oneOf, noneOf) for specifying a (NOT) IN clause | -- |
compound nested conditions | WHERE (x = y OR x = z) AND (y = a OR y = b) | -- |
dynamic DAOs | DAO interfaces with annotated statements may be declared and dynamically generated | -- |
types | ||
primitives | fully supported | -- |
enums | fully supported | -- |
DECIMAL(length,scale) | can specify length/precision and scale | -- |
BOOLEAN | flexible mapping of boolean as bool, varchar, or int | -- |
BLOB | partially supported (can not be used in a WHERE clause) | -- |
Custom | partially supported uses custom-defined data type adapter (can not be used in a WHERE clause) | -- |
UUID | fully supported (H2 only) | -- |
configuration | ||
DEFAULT values | set from annotation, default object values, or Define.defaultValue() | set from annotations |
Interface Configuration Mapped Fields | all fields are mapped regardless of scope fields are ignored by annotating with @IQIgnore | all public fields are mapped fields are ignored by reducing their scope |
Index names | can be set | -- |