smithproject.org

Hello,

This is a Windows XP system. Here's what I've done.

1.) Dowloaded and extracted mysql-connector-java-5.0.8.zip
(also tried mysql-connector-java-5.1.7.zip)

2. Placed mysql-connector-java-5.0.8-bin.jar in: C:\smith-bin-windows-1.3b6\wwwroot\WEB-INF\lib

(also tried C:\smith-bin-windows-1.3b6\lib)
(also tried mysql-connector-java-5.1.7-bin.jar in both locations)

3.) Have tried setting CLASSPATH in System Control Panel to whatever appropriate path was being used.

4.)After each attempt, restarted SMITH.

5.) Datasource is setup as follows:

jdbc url: jdbc:mysql://localhost/ccc_vote

(have also put port :3306 after localhost)

jdbc driver full class name: com.mysql.jdbc.Driver

(MySQL db is at C:\smith-bin-windows-1.3b6\wwwroot\data\ccc_vote)

In every case, datasource will not validate. I get the red X. Clicking on it gives me:

Error Message:
com/mysql/jdbc/Driver

Any ideas what I'm missing?

Thanks!