Re: Database reverse engineering - Mailing list pgsql-general

From Ow Mun Heng
Subject Re: Database reverse engineering
Date
Msg-id 1189656755.20660.22.camel@neuromancer.home.net
Whole thread Raw
In response to Re: Database reverse engineering  (RC Gobeille <bob.gobeille@hp.com>)
Responses Re: Database reverse engineering  (Paul Boddie <paul@boddie.org.uk>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Josh Trutwin
Date:
Subject: Re: Database reverse engineering
Next
From: Norberto Meijome
Date:
Subject: Re: importing pgsql schema into visio (for diagramming)