reverse mapping needs

[Dave Jenkins <da...@paradise.net.nz>]

I've always been a code generator. Most of the apps that I've worked 
with over the past 2 decades have been bound to a DB of some sort and 
I've always generated stuff from the DB. I used to do it the hard way, 
but now use Velocity.
Take my current project; a typical web app with a DB. I've generated:

    * All the OJB XML files.
    * All the Mapped Java classes.
    * All the DAO code.
    * All the interfaces between client and DB.
    * A complete (no hand coding at all) Webstart Swing based Data Admin
      application with panels, models etc.

In effect I can generate anything that uses any data from any datamodel.
I use DatabaseMetaData as the source of all metadata. I've had to write 
a coupla implemetations that take SQL scripts and Powerdesigner models 
so that I can get at the relationships when they are not present in the 
database or the database does not yet exist.

I've not formalised it all as a GUI tool, although on occasion I wish 
that I had. But I'm dead keen on helping with any OS tool for OJB.

Dave.