Solution for "The MySQL driver is not on the classpath. Is it still zipped?"

[Robert Stewart]

I was getting this MySQL driver error message for the full application
version (1.6.1) as well as the community version (1.6.3) on OS X 10.6.
After poking around in the manifest, I found that there was a
discrepancy between the name of the MySQL JDBC driver in the manifest
and the name of the actual file.

Manifest-Version: 1.0
Ant-Version: Apache Ant 1.7.0
Created-By: 14.1-b02-90 (Apple Inc.)
Main-Class: Entrance
Class-Path: lib/mysql-connector-java-bin.jar lib/cotta.jar lib/jama.ja
r lib/log4j.jar lib/commons-logging.jar lib/entrancex.jar

But the file name is actually:

mysql-connector-java.bin.jar

After changing the file name to match the manifest (change java.bin to
java-bin), everything worked.

On OS X, the JDBC driver for the full application version is in the
following directory:

/Applications/Entrance.app/Contents/Resources/Java/lib

[Tod Landis]

Good catch, thank you! Version 1.6.4 is up there and should fix
the problem.

Incidentally, there are notes about the changes between versions
in com.dbentrance.entrance.versions.Version. The most recent ones
are:

// 1.6.4 public release 2010.4.12
// rename MySQL driver jar to match manifest
// 1.6.2-3 public release 2010.4.11
// RAWS extensions built in
// version string in Info.plist for MacUpdate
// 1.6.1 public release 2010.4.10
// disabled painting pics are now visible, even when not
paintable
// 1.6.0
// 48 series supported by Chart & warn when limit exceeded
// (to avoid problems in data exploration)

The changes have been minor since 1.6.1, so if you are running
Entrance 1.6.1 Community or IDE you are probably fine. Version 1.6.1
had a number of bug fixes that everyone will want to pick up.

The Entrance driver is one version behind the current MySQL driver
version.
To upgrade,you can copy the current one into the lib directory for
Entrance and
rename it 'mysql-connector-java.bin.jar'. To see which one you are
running, open the "About Entrance" dialog and click settings.

More information about the driver is here:
http://dev.mysql.com/downloads/connector/j/

- Tod