Projects / SQL Construction Kit

SQL Construction Kit

SQL Construction Kit aims to provide a simple builder/factory pattern based approach to generating DML SQL for all popular RDBMS systems. Included builders are SelectBuilder, InsertBuilder, UpdateBuilder, and DeleteBuilder. It is much lighter weight than any of the ORM tools available, and is 100% Java. It is a complete re-factoring of code that has been in production use since 2001 (updated to use features of Java 6). Also included is a Facade patterned Database object that wraps a Datasource object. This provides an execution framework for the results of the Builder objects, which includes simplified transaction and batch management as well as the ability to transparently handle SQL exceptions in a default manner. The Database object also provides a simple object-oriented approach via wrappers around the database metadata.

Operating Systems

Last announcement

SQL Construction Kit is now available in Maven Central Repository 22 Mar 2011 17:23

You can use the following entries in your Maven 2/3 pom.xml files. I can't paste the actual XML fragment so groupId = com.vertigrated artifactId = sqlck version = 1.0 or version = 1.1-SNAPSHOT

Recent releases

  •  22 Mar 2011 17:11

    Release Notes: The code repository was moved to github. The build system was changed to Maven 3. Artifacts were moved to Maven Central.

    •  23 Jan 2009 19:47

      Release Notes: This release fixes a bug in the AbstractDeleteBuilder object where it did not override the toString() method correctly.

      •  27 Aug 2008 20:51

        Release Notes: The DeleteBuilder interface was not extending the SQLStatement interface; this has been fixed.

        •  22 Aug 2008 17:47

          Release Notes: Temporal object handling has been refactored with new SQL99 inspired DATE, TIME, and TIMESTAMP classes. There is more Javadoc documentation and more wiki example code and documentation.

          •  13 Aug 2008 17:45

            Release Notes: This release adds implementations to many methods that threw UnsupportedOperationExceptions. The WhereClause API has been refactored to make a few methods more self-explanatory. Some broken unit tests have been fixed. The beginning of an EXAMPLE source tree has been added.


            Project Spotlight


            A Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.