"Failed to load driver 'org.postgresql.Driver'"
Brought to you by:
johncurrier
Menu
▾
▴
#180 "Failed to load driver 'org.postgresql.Driver'"
- 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.
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.
I figured out this part but couldn't figure out how to close this ticket.