About dbSlurp

What is it?

dbSlurp is a Java library that converts database metadata into object graphs in a database-independant way, presenting an object oriented view of the information present in a database (the available schemas, tables, columns, etc.). It is a low-level library that may be used for building code generators, database GUI frontends, data manipulation utilities, etc.

Why not use JDBC's DatabaseMetaData functionality? Unfortunately, the level of support of that class among the different JDBC drivers is unequal. Many methods are not implemented or throw exceptions (this is particularly painful for Oracle). Many other methods do not return full information of the database object, so exploration of each database's specific information schema is necessary. And to add insult to injury, the terms "schema" and "catalog" - which are so prevalent in many of the results returned by the methods of DatabaseMetaData - vary wildly among servers.

As a bonus, dbSlurp also comes with a set of swing utilities that allow the information of the database to be represented in a JTree, JList or JCombobox.

Supported databases

Currently, dbSlurp works with: