Java library for reading database schema

Question

I'm looking for a lightweight, open source, more or less cross-database Java library that would allow me to read off metainformation on columns, tables and integrity constraints given a DataSource.

Thrush

Answer 1

I have found an answer to my question, Apache DDLUtils. My question was really a duplicate of this one.

Thrush

Answer 2

Depends what you want to do afterwards of course, but if you just want to visualise an existing datatbase, I recommend SchemaSpy.

Of course, JDBC already lets you read metainformation, using Connection.getMetaData(). This gives you a DatabaseMetaData instance.

Names