| From: | Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> |
|---|---|
| To: | RC Gobeille <bob(dot)gobeille(at)hp(dot)com> |
| Cc: | "A(dot)Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Database reverse engineering |
| Date: | 2007-09-13 04:12:35 |
| Message-ID: | 1189656755.20660.22.camel@neuromancer.home.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Norberto Meijome | 2007-09-13 04:21:09 | Re: importing pgsql schema into visio (for diagramming) |
| Previous Message | Josh Trutwin | 2007-09-13 03:43:21 | Re: Database reverse engineering |