How to get schemaspy to see the mysql connector?

Question

I've just downloaded schemaspy and it is working perfectly apart from one thing. I always have to specify the path to the mysql connector with the -dp option.

If I don't specify it, I get this error:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Failed to load driver 'com.mysql.jdbc.Driver'
This entry doesn't point to a valid file/directory: [/mysql/mysql-connector-java-5.1.6-  bin.jar]

The path (symlink to /usr/share/java/mysql-connector-java-5.1.28.jar or whatever version you have) is:

/usr/share/java/mysql-connector-java.jar

And it is on the $CLASSPATH.

Also, don't expect -p prompt for a password.

Answer 1

I do it this way.. Added this as parameter: -dp C:\apache-tomcat-6.0.37\lib\mysql-connector-java-5.1.10.jar kept my mysql driver in destined folder.

Worked for me.