Re: Database reverse engineering

On Mon, 2007-09-10 at 13:00 -0600, RC Gobeille wrote:
> Or this one:
> http://schemaspy.sourceforge.net/


Can't seem to get it to connect to PG using the example.

java -jar schemaSpy_3.1.1.jar -t pgsql -u operator -p operator -o
test_db  -host localhost -db test_db
Using database properties:

[schemaSpy_3.1.1.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
java.lang.ClassNotFoundException: org.postgresql.Driver

Failed to load driver 'org.postgresql.Driver' from: []
This entry doesn't point to a valid file/directory:
[/whereever/postgresql-8.0-312.jdbc3.jar]

Use -t [databaseType] to specify what drivers to use or modify
one of the .properties from the jar, put it on your file
system and point to it with -t [databasePropertiesFile].

For many people it's easiest to use the -cp option to directly specify
where the database drivers exist (usually in a .jar or .zip/.Z).
Note that the -cp option must be specified after schemaSpy_3.1.1.jar