Generate SQL-Statements from abstract definition

From: Volker Raum (Volker.Raum_at_heitec.de)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 09:13:09 +0200

Hi everyone,

we are developing Software using Databases. The Software is said to run
under various databases (Oracle, Interbase, MySQL, etc.)
In order to run correctly we need to run several DB-Scripts creating
tables and filling them once before our application can be started.
I would like to have a single source of descriptionfile (XML or
whatever) i can generate DB-Scripts from.
So i can specify the tables in an abstract way and create generation
scripts for the various databases on a single click.
I also want to specify the data for the inserts (as java Datatypes i.e.)
X-Doclet is a good start, but with X-Doclet you cant generate inserts to
fill the db with statupvalues.
I wonder if there are dummy JDBC Drivers? A Driver that does NOT do the
inserts into the Database but print out the generated SQL-Commands would
be of help, because then we could write a java program do the job for
the inserts.

any ideas (products?)