Fork me on GitHub

Release notes

Release History

Version Date Description
2.1.7 2017-04-21  
2.1.6 2016-12-18  
2.1.5 2016-09-20  
2.1.4 2016-07-01  
2.1.3 2016-05-30  
2.1.2 2016-01-30  
2.1.1 2015-07-01  
2.1.0 2015-04-16 Relicense to Apache License
2.0.13 2014-12-27  
2.0.12 2012-10-01  
2.0.11 2012-01-10  
2.0.10 2011-10-19  
2.0.9 2011-08-25  
2.0.8 2011-04-22  
2.0.7 2011-03-07  
2.0.6 2009-10-12  
2.0.5 2009-05-24  
2.0.4 2008-10-05  
2.0.3 2008-06-05  
2.0.2 2008-04-28  
2.0.1 2008-04-07  
2.0.0 2008-03-31  

Release 2.1.7 – 2017-04-21

Type Changes By
Add Add the EXTRACT expression (thanks to Andrey Karepin). Fixes 4. jahlborn
Add Add support for window functions (ideas from Andrey Karepin). Fixes 3. jahlborn

Release 2.1.6 – 2016-12-18

Type Changes By
Update Add the BETWEEN condition. Fixes 19. jahlborn

Release 2.1.5 – 2016-09-20

Type Changes By
Update Add a few convenience methods for RejoinTable and table aliases. jahlborn
Update Add support for some custom postgresql binary conditions (ilike, similar to, and posix regex matching). Fixes 18. jahlborn

Release 2.1.4 – 2016-07-01

Type Changes By
Update Add OSGi support to jar manifest. Fixes 20. jahlborn

Release 2.1.3 – 2016-05-30

Type Changes By
Update Add support for sqlserver TOP syntax as custom SQL. Fixes 18. jahlborn
Update Add support for SQL 2008 OFFSET and FETCH NEXT clauses in SELECT queries. jahlborn
Update Add support for cross schema foreign key column references. Fixes 17. jahlborn

Release 2.1.2 – 2016-01-30

Type Changes By
Update New site style! jahlborn
Update Initial foray into SQL99 syntax with Common Table Expression support. Fixes 15. jahlborn
Update Add system property for using SQL boolean literals for boolean values. Fixes 16. jahlborn

Release 2.1.1 – 2015-07-01

Type Changes By
Update Add a framework for enabling SqlBuilder queries to support custom SQL syntax. Add a few common database-specific customizations. Fixes 14. jahlborn
Update Add NamedParamObject which supports the "named" param syntax used by some SQL or SQL-like frameworks. Fixes 5. jahlborn
Add Add CheckConstraint for handling table/column CHECK constraints. jahlborn

Release 2.1.0 – 2015-04-16

Type Changes By
Add OpenHMS relicenses to Apache License, 2.0! jahlborn

Release 2.0.13 – 2014-12-27

Type Changes By
Add Add QueryPreparer.ListPlaceHolder to simplify working with lists of PlaceHolders (common in IN expressions). Fixes 13. jahlborn

Release 2.0.12 – 2012-10-01

Type Changes By
Update Add support for arbitrary column type qualifiers (e.g. scale and precision). Fixes 3536960. jahlborn

Release 2.0.11 – 2012-01-10

Type Changes By
Add Added the AddColumnAction to the AlterTableQuery, thanks to Eric Fennell. jahlborn
Update Add support for column default values. jahlborn

Release 2.0.10 – 2011-10-19

Type Changes By
Update Add more flexible table aliasing: handle Table with no alias and allow DbTable alias to be passed in constructor. Fixes 3421696. jahlborn
Update Add SelectQuery.addCustomJoin(Object) for fully customizable join clauses. Fixes 3421713. jahlborn
Update Allow ComboCondition,UnaryCondition,BinaryCondition,ComboExpression to have custom operators. Fixes 3422262. jahlborn
Update Add option to disable wrapping parentheses in Conditions and Expressions which utilize them. Fixes 3422262. jahlborn

Release 2.0.9 – 2011-08-25

Type Changes By
Update Make DbSpec the factory for all other DbObject classes. jahlborn
Update Add methods/constructors to enable more flexible usage of DbObject classes with custom subclasses (thanks to Douglas Russell for some code contributions) Fixes 3397693. jahlborn

Release 2.0.8 – 2011-04-22

Type Changes By
Fix Fix date tests so that they are TimeZone agnostic. Fixes 3237822. jahlborn
Update Add support for updatable ResultSets to QueryReader. jahlborn

Release 2.0.7 – 2011-03-07

Type Changes By
Update Make Constraints first class citizens of the dbspec model. Add ConstraintClause and enhance various constructs to use improved constraint implementations. Deprecated simplified constraint support in CreateTableQuery and AlterTableQuery. Fixes 3125765. jahlborn

Release 2.0.6 – 2009-10-12

Type Changes By
Fix Add hasParens() method to NestableClause so that InCondition can accurately determine if the values need to be wrapped in parens or not. Fixes 2817484. jahlborn

Release 2.0.5 – 2009-05-24

Type Changes By
Update Add support for additional query "set operators" (EXCEPT, INTERSECT), and add support for mixed usage of said operators. Fixes 2794171. jahlborn
Update Add UnaryCondition EXISTS and UNIQUE operators. jahlborn
Update Minor cleanups for some of the generic types. jahlborn
Fix Fix isEmpty implementation for Subquery. jahlborn
Update Don't put double parens around IN condition with subexpression. jahlborn

Release 2.0.4 – 2008-10-05

Type Changes By
Fix Handle BigDecimal/BigInteger instances better in NumberValueObject.isFloatingPoint. jahlborn
Fix Fixed handling of boolean values (handle them as numbers because Sql92 has no notion of a real boolean type), implemented BooleanValueObject. Fixes 2138885. jahlborn

Release 2.0.3 – 2008-06-05

Type Changes By
Add Added support for view creation (CreateViewQuery) and deletion (DropQuery.Type.VIEW). jahlborn

Release 2.0.2 – 2008-04-28

Type Changes By
Fix Change how state is maintained during query validation. Use the ValidationContext instead of a few collections in order to enable more complicated subquery handling. This change allows subqueries to be validated correctly and opens the door for sub-clause validation. Fixes 1943120. jahlborn
Update Extend the unit test coverage. jahlborn

Release 2.0.1 – 2008-04-07

Type Changes By
Update Fold numeric conversions into normal value conversions. jahlborn

Release 2.0.0 – 2008-03-31

Type Changes By
Add Initial open source release. jahlborn