#180 "Failed to load driver 'org.postgresql.Driver'"

N/A
open
nobody
None
5
2014-09-30
2014-05-09
Bulrush
No
  • Win 7 with i-net Clear Reports 12.1 (Crystal Reports)
  • SchemaSpy 5.0.0
  • Java 1.6.0_27

Just learning Crystal Reports (i-net Clear Reports) and I need to print out the layout of the database tables. Got this error. Command line is:

java -jar schemaSpy_5.0.0.jar -o out -u myuser -p mypw -t pgsql -host 1.2.3.4 -db epace -db "c:\program files\i-net Clear Reports\lib\driver"

My path to Graphviz is setup in my command window, so that should not be a problem. Problem appears to be SchemaSpy cannot find the Postgre SQL drivers. They might be installed with Crystal Reports in the path I specified with -db on the command line.

Actual error:

java.lang.ClassNotFoundException: org.postgresql.Driver

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

Use the -dp option to specify the location of the database drivers for your database (usually in a .jar or .zip/.Z).

Any ideas?

Thanks.

Discussion

  • Bulrush
    Bulrush
    2014-05-09

    I figured out this part but couldn't figure out how to close this ticket.