Take the 2-minute tour ×

Is there any open-source library in Java for getting deep information about database, its tables, schema and ... (size in bytes, records, etc.)? I need to connect to database (various distributions) and get as much as possible meta and statistics about each!

share|improve this question

put on hold as off-topic by Mureinik, Kenster, glglgl, popovitsj, Mohamad Dec 22 at 12:51



2 Answers 2

up vote 1 down vote accepted

Have you considered JDBC ;-)

It contains all the data you would likely need in the *MetaData structures, in your case: DatabaseMetaData ?

share|improve this answer
Definitely yes but unfortunately is not enough for my project. I need something more abstract for faster developing. I need something like MS SQL Management Studio, or MySQL workbench but Java based and Open-Source. –  Amir Apr 29 '13 at 2:22
As soon as you need more detail than JDBC gives, then tou can't (easily) do different dbms . –  rolfl Apr 29 '13 at 2:30

Take a look at SchemaCrawler, which is an open source Java library that abstracts database metadata into a usable object model.

Sualeh Fatehi, SchemaCrawler

share|improve this answer
