Menu
▾
▴
Posted by
2026-04-07
Posted by
2026-02-20
Posted by
2021-06-03
Posted by
2020-09-11
Posted by
2019-02-11
Posted by
2017-04-21
Posted by
2016-09-20
Posted by
2016-07-02
Posted by
2016-07-02
Posted by
2016-05-30
Posted by
2016-01-30
Posted by
2015-07-02
Posted by
2015-04-17
Posted by
2015-04-17
Posted by
2015-04-17
Posted by
2015-01-20
Posted by
2014-12-28
Posted by
2013-09-24
Posted by
2012-10-04
Posted by
2012-01-11
Posted by
2012-01-11
Posted by
2011-10-20
Posted by
2011-08-26
The OpenHMS Project / News: Recent posts
SqlBuilder 3.1.0 released
SqlBuilder 3.1.0 Release
- Ditch no longer useful backwards compatibility hack of an extra space at the end of IN conditions. Note, while this is a minor change from previous sql generation, it should not alter execution in any modern database.
- Add support for date/time sql literals.
SqlBuilder 3.0.3 released
SqlBuilder 3.0.3 Release
- Add a variety of useful helpers for schema setup
- Add CURRENT_TIMESTAMP expression
SqlBuilder 3.0.2 released
SqlBuilder 3.0.2 Release
- Add system property which allows setting the default list item separator to include a trailing space
- Add convenience methods for constructing OrderObject instances. Add documention about using OrderObject to control null ordering.
SqlBuilder 3.0.1 released
SqlBuilder 3.0.1 Release
- Added Conditions and Expressions classes with static methods for generating most condition and expression types. Useful for static imports for writing more succinct code
- Add support for setting the constraint check time and setting the delete/update referential action for foreign key constraints
- Add more useful info to some validation failures
SqlBuilder 3.0.0 released
SqlBuilder 3.0.0 Release
- SqlBuilder now requires a Java 8+ runtime. As part of this update, all dependencies have been updated to their latest versions
- The separate common-util dependency has been removed. The few classes which were utilized from that dependency are now included in this project directly
- Add convenience methods to convert Java 8 Temporal types into jdbc date/time escape syntax
SqlBuilder 2.1.7 released
SqlBuilder 2.1.7 Release
- Add the EXTRACT expression (thanks to Andrey Karepin)
- Add support for window functions (ideas from Andrey Karepin)
SqlBuilder 2.1.5 released
SqlBuilder 2.1.5 Release
- Add a few convenience methods for RejoinTable and table aliases.
- Add support for some custom postgresql binary conditions (ilike, similar to, and posix regex matching).
SqlBuilder 2.1.4 released
SqlBuilder 2.1.4 Release
- Add OSGi support to jar manifest
OpenHMS Common Util 1.1.1 released
OpenHMS Common Util 1.1.1 Release
- Add OSGi support to jar manifest
SqlBuilder 2.1.3 released
SqlBuilder 2.1.3 Release
- Add support for sqlserver TOP syntax as custom SQL.
- Add support for SQL 2008 OFFSET and FETCH NEXT clauses in SELECT queries.
- Add support for cross schema foreign key column references.
SqlBuilder 2.1.2 released
SqlBuilder 2.1.2 Release
- New site style!
- Initial foray into SQL99 syntax with Common Table Expression support.
- Add system property for using SQL boolean literals for boolean values.
SqlBuilder 2.1.1 released
SqlBuilder 2.1.1 Release
- Add a framework for enabling SqlBuilder queries to support custom SQL syntax. Add a few common database-specific customizations
- Add NamedParamObject which supports the "named" param syntax used by some SQL or SQL-like frameworks
- Add CheckConstraint for handling table/column CHECK constraints
SqlBuilder 2.1.0 released
SqlBuilder 2.1.0 Release
- OpenHMS relicenses to Apache License, 2.0!
RMIIO 2.1.0 released
RMIIO 2.1.0 Release
- OpenHMS relicenses to Apache License, 2.0!
OpenHMS Common Util 1.1.0 released
OpenHMS Common Util 1.1.0 Release
- OpenHMS relicenses to Apache License, 2.0!
RMIIO 2.0.5 released
RMIIO 2.0.5 Release
- Add preemptive null checks to avoid remote NPEs
SqlBuilder 2.0.13 released
SqlBuilder 2.0.13 Release
- Add QueryPreparer.ListPlaceHolder to simplify working with lists of PlaceHolders (common in IN expressions).
RMIIO 2.0.4 released
RMIIO 2.0.4 Release
- Added the RMISocket utility for simulating a socket-like connection over RMI (using RemoteOutputStreams under the hood).
- Attempt to use context classloader when necessary for loading a RemoteStreamExporter.
SqlBuilder 2.0.12 released
SqlBuilder 2.0.12 Release
- Add support for arbitrary column type qualifiers (e.g. scale and precision)
SqlBuilder 2.0.11 released
SqlBuilder 2.0.11 Release
- Added the AddColumnAction to the AlterTableQuery, thanks to Eric Fennell
- Add support for column default values
RMIIO 2.0.3 released
RMIIO 2.0.3 Release
- Fix closing of RemoteInputStreamClient
SqlBuilder 2.0.10 released
SqlBuilder 2.0.10 Release
- Add more flexible table aliasing: handle Table with no alias and allow DbTable alias to be passed in constructor
- Add SelectQuery.addCustomJoin(Object) for fully customizable join clauses
- Allow ComboCondition, UnaryCondition, BinaryCondition, ComboExpression to have custom operators
- Add option to disable wrapping parentheses in Conditions and Expressions which utilize them
SqlBuilder 2.0.9 released
SqlBuilder 2.0.9 Release
- Make DbSpec the factory for all other DbObject classes.
- Add methods/constructors to enable more flexible usage of DbObject classes with custom subclasses (thanks to Douglas Russell for some code contributions)