The OpenHMS Project / News: Recent posts

SqlBuilder 3.0.3 Release

• Add a variety of useful helpers for schema setup
• Add CURRENT_TIMESTAMP expression

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 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 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 Release

• Add the EXTRACT expression (thanks to Andrey Karepin)
• Add support for window functions (ideas from Andrey Karepin)

SqlBuilder 2.1.6 Release

• Add the BETWEEN condition

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).

RMIIO 2.1.2 Release

• Add OSGi support to jar manifest

SqlBuilder 2.1.4 Release

• Add OSGi support to jar manifest

OpenHMS Common Util 1.1.1 Release

• Add OSGi support to jar manifest

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 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 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 Release

• OpenHMS relicenses to Apache License, 2.0!

RMIIO 2.1.0 Release

• OpenHMS relicenses to Apache License, 2.0!

OpenHMS Common Util 1.1.0 Release

• OpenHMS relicenses to Apache License, 2.0!

RMIIO 2.0.5 Release

• Add preemptive null checks to avoid remote NPEs

SqlBuilder 2.0.13 Release

• Add QueryPreparer.ListPlaceHolder to simplify working with lists of PlaceHolders (common in IN expressions).

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 Release

• Add support for arbitrary column type qualifiers (e.g. scale and precision)

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 Release

• Fix closing of RemoteInputStreamClient

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 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)

SqlBuilder 2.0.8 Release

• Add support for updatable ResultSets to QueryReader.
• Fix date tests so that they are TimeZone agnostic. Fixes 3237822