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.