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

[Bulrush]

• 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.

[Bulrush]

It seems to need a driver "postgresql-8.0-312.jdbc3.jar" but I can't find it at http://jdbc.postgresql.org/download.html. All I can find is 8.0-325, will that one work?

Also, will you put a link to the JDBC drivers somewhere on your page: http://jdbc.postgresql.org/download.html

Thank you.

[Bulrush]

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