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.
HotCache is a transactional distributed caching system that runs on top of most RDBMSes. It provides an object-relational mapping tool that makes the use of embedded SQL unnecessary and saves tedious mapping programming. It enhances RDBMS commit functionality by adding commit-broadcast transactions where data is committed to the database and at the same time pushed to all other client caches, in essence keeping the data at remote clients hot. This improves performance by orders of magnitude (as most data access can be done locally) and reduces the load on the database server. The commit-broadcast transactions are implemented using UDP multicast for maximum network utilization. HotCache provides a sophisticated event framework that allows the client to register interest in business objects and be notified when changes are committed. The event framework is built so that it can be easily integrated with other systems' event-loops, eliminating multi-threading problems, etc. Notification can also be configured to take place in an asynchronous/multi-threaded method.