#150 Can't get a valid datapath for the jdbc driver for Sybase

open
John Currier
5
2012-04-06
2012-04-06
Becky Mikalinis
No

I'm a new user to this product and I want to trial it for our company. So far no luck. It's been failing on not able to load the jdbc driver.

Here is a sample command (password removed) and run:

java -jar "schemaSpy_5.0.0.jar" -t sybase -db MYDB -all -host MYSERVER -port 4100 -u MYUSER -o "C:\SchemaSPY\Output\programs\"
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/sybase.properties
java.lang.ClassNotFoundException: com.sybase.jdbc3.jdbc.SybDriver

Failed to load driver 'com.sybase.jdbc3.jdbc.SybDriver'
These entries don't point to valid files/directories: [D:\Programme\sybase\jConnect-6_0\classes\jconn3.jar, C:\Programme\sybase\jConnect-6_0\classes\jconn3.jar, D:\Programs\sybase\jConnect-6_0\classes\jconn3.jar, C:\Programs\sybase\jConnect-6_0\classes\jconn3.jar]

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

I have tried to specify a path to the 2 files I suspected were the jdbc driver containers on my laptop: jodbc.jar, jconn3.jar which is I believe is where the jdbc3 driver is? Not working.

My laptop is Window 7.

The SchemaSpy doc says this is the correct driver for sybase - Sybase Server with JDBC3 Driver

Can anyone assist me in getting this going and an easy way to find all the required jdbc driver paths so I can also connect to other database platforms? What is the exact filename I'm looking for?

Thank you!

Discussion