The OpenHMS Project / News: Recent posts

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)
Posted by James Ahlborn 2017-04-21

SqlBuilder 2.1.6 released

SqlBuilder 2.1.6 Release

  • Add the BETWEEN condition
Posted by James Ahlborn 2016-12-18

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).
Posted by James Ahlborn 2016-09-20

RMIIO 2.1.2 released

RMIIO 2.1.2 Release

  • Add OSGi support to jar manifest
Posted by James Ahlborn 2016-07-02

SqlBuilder 2.1.4 released

SqlBuilder 2.1.4 Release

  • Add OSGi support to jar manifest
Posted by James Ahlborn 2016-07-02

OpenHMS Common Util 1.1.1 released

OpenHMS Common Util 1.1.1 Release

  • Add OSGi support to jar manifest
Posted by James Ahlborn 2016-07-02

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.
Posted by James Ahlborn 2016-05-30

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.
Posted by James Ahlborn 2016-01-30

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
Posted by James Ahlborn 2015-07-02

SqlBuilder 2.1.0 released

SqlBuilder 2.1.0 Release

  • OpenHMS relicenses to Apache License, 2.0!
Posted by James Ahlborn 2015-04-17

RMIIO 2.1.0 released

RMIIO 2.1.0 Release

  • OpenHMS relicenses to Apache License, 2.0!
Posted by James Ahlborn 2015-04-17

OpenHMS Common Util 1.1.0 released

OpenHMS Common Util 1.1.0 Release

  • OpenHMS relicenses to Apache License, 2.0!
Posted by James Ahlborn 2015-04-17

RMIIO 2.0.5 released

RMIIO 2.0.5 Release

  • Add preemptive null checks to avoid remote NPEs
Posted by James Ahlborn 2015-01-20

SqlBuilder 2.0.13 released

SqlBuilder 2.0.13 Release

  • Add QueryPreparer.ListPlaceHolder to simplify working with lists of PlaceHolders (common in IN expressions).
Posted by James Ahlborn 2014-12-28

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.
Posted by James Ahlborn 2013-09-24

SqlBuilder 2.0.12 released

SqlBuilder 2.0.12 Release

  • Add support for arbitrary column type qualifiers (e.g. scale and precision)
Posted by James Ahlborn 2012-10-04

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
Posted by James Ahlborn 2012-01-11

RMIIO 2.0.3 released

RMIIO 2.0.3 Release

  • Fix closing of RemoteInputStreamClient
Posted by James Ahlborn 2012-01-11

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
Posted by James Ahlborn 2011-10-20

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)
Posted by James Ahlborn 2011-08-26

SqlBuilder 2.0.8 released

SqlBuilder 2.0.8 Release

  • Add support for updatable ResultSets to QueryReader.
  • Fix date tests so that they are TimeZone agnostic. Fixes 3237822
Posted by James Ahlborn 2011-04-25

SqlBuilder 2.0.7 released

SqlBuilder 2.0.7 Release

  • 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.
Posted by James Ahlborn 2011-03-07

Sqlbuilder 2.0.6 released

SqlBuilder 2.0.6

  • Add hasParens() method to NestableClause so that InCondition can accurately determine if the values need to be wrapped in parens or not. Fixes 2817484.
Posted by James Ahlborn 2009-10-25

SqlBuilder 2.0.5 released

SqlBuilder 2.0.5

  • Add support for additional query "set operators" (EXCEPT, INTERSECT), and add support for mixed usage of said operators. Fixes 2794171 .
  • Add UnaryCondition EXISTS and UNIQUE operators.
  • Fix isEmpty implementation for Subquery.
  • Don't put double parens around IN condition with subexpression.
Posted by James Ahlborn 2009-05-26

SqlBuilder 2.0.4 released

SqlBuilder 2.0.4

  • Fixed handling of boolean values (handle them as numbers because Sql92 has no notion of a real boolean type)
Posted by James Ahlborn 2008-10-06