jDBMD: provides a simple java library for fetching database metadata information, and reading and writing it as XML.

As a Java Library: 
==================
  The dbmd.jar archive may be used as a simple Java library for fetching metadata information for a database schema.  Use class gov.fda.nctr.dbmd.DatabaseMetadataFetcher to fetch metadata information about tables, views, fields and foreign keys in a given schema.  Class DBMD represents the metadata itself and supports reading and writing to and from xml.


Requests, suggestions and comments are welcome.  Send to gmail user steveOfAR.


As a Standalone Program
=======================
The DatabaseMetadataFetcher class includes a main method which can write database metadata as xml to an output file. To do this, first create a properties file describing the database connnection information, with properties:
jdbc-connect-url, jdbc-driver-class, user, and password.

For example,
#file connection.props
jdbc-connect-url=jdbc:oracle:thin:myhost.mydomain.org:1528:mysid
jdbc-driver-class=oracle.jdbc.OracleDriver
user=mydbuser
password=mypassword


Then invoke the command like this:

  java -cp dbmd.jar:ojdbc6.jar gov.fda.nctr.dbmd.DatabaseMetadataFetcher myschema connection.props myschema.xml

which would write the database metadata for schema myschema to file myschema.xml.