Projects
Castor is an open source data binding framework for Java. It's the shortest path between Java objects, XML and relational tables. Castor provides Java-to-XML binding, Java-to-relational persistence, and more.
Google Summer of Code (SOC) project to create a module for Castor to generate DDL.
A convenience API for dealing with SQL from Java.
Library for supporting access to data using different declarative query-based languages. For example, access to data could be provided using both SQL and EJBQL.
Jequel is an Java embedded DSL for SQL. Using its expressions one can easily create expression trees that can be rendered e.g. to SQL.
Advantages:
* code completion, syntax highlighting, error reporting in IDE
* re-generate java schema-model during CI build, all non complying code will fail to compile
* enhance the schema-model with lots of other information and have this at your fingertips (quick documentation lookup of your IDE)
* generate browseable javadoc from the schema model files
What exists by now:
* Expression Language
* small Generator Framework
* Ant Tasks for Generation
* Unit tests for all the above
