Torque

by Simon Email

Link: http://db.apache.org/torque/

I'm very reluctant to use 3rd party software - often it can cause more problems than it solves.

However Torque looks very useful - it generates SQL and Java from and XML-based schema definition.

It uses Velocity templates to control the Java generation, so presumably you could tailor it to other languages??

Another nice feature is that it can read an existing database, generates an XML schema, and the associated Java code.

Great for legacy apps!