The 2nd most useful Java-Oracle Tool for 2006

by Paul Browne

The 2nd most useful Java-Oracle Tool that I've used this year is schema spy.

How often have you taken over a project without any documenation? Even worse , there is a database involved, and everybody just 'knows' (or pretends to know) where things are. What if all the orginal developers are gone and nobody is left to explain things? I can find my way around most legacy Java code , but databases leave me cold.

Still not convinced - take a look on the Schema Spy website. The level of information that this tool gives you takes you from knowing nothing about the database to knowing almost everything.

Interested in trying it out? Follow these simple steps
- Download it from
- Change the configuration to point to your database
- Install the Graphviz component (available here)
- Run the tool and await your fully documented database.

Just to shame the commercial competition , as well as Oracle , Schema Spy supports DB2, hsqldb , Microsoft SQL Server, MySQL, PostgreSQL and Sybase. It's written by John Currier and is well worth a donation.

In case you're wondering, the most useful Java-Oracle tool for 2006 is Oracle's project raptor. Schema spy runs it a very close second. Considering that it's a Billion dollar company Vs one man , I'd chalk that up as a victory for the little guy!

More Technical Blogs in Technology in Plain English


Jason W.
2006-05-01 12:08:12
this tool totally rocks. I just downloaded it and it has found database anomalies. The graph is awesome. I had problems with "-t ora" and had to use "-t orathin" as I was using the ojdbc14.jar. thanks for an awesome post.
Paul Browne
2006-05-01 12:51:59
I've shown the results to clients as well , as they've been completely blown away by how good it is.

I think we all mean to donate more than we do to Open Source projects that we use , but is one tool that I've actually followed through on the good intentions.

2006-07-06 00:53:44
and the 2nd most horrible java source code I've seen this year
Paul Browne
2006-07-06 12:54:19
Dear Anonymous,

I have no connection with the project , but being open source, you are welcome to make the source code a little bit better (perhaps only the 3rd worst?).

Fact is , 99% of people using this are probably happy with what it does, not how the code looks.


2007-12-31 17:14:56
My opinion is that it's really a good piece of code, and it's OS so I can do anything I want with it. Bye
2008-03-24 02:51:32
I want make application by oracl and conncet with internetwebsit help me if you have explane or some programe or websit(iam beginner in oracl) thankyou>