I have been having the

I have been having the most difficult time getting EOModeler to connect to mySQL. It worked great on my PowerBook. However, on my iMac it will not connect. Connection attempts result in the message:

JDBC connection failed for driver :’org.gjt.mm.mysql.Driver’. Driver not found in Java Runtime! Please verify your CLASSPATH environment variable. The current CLASSPATH for your application is : /Developer/Applications/EOModeler.app /Contents/Resources/Java/
eomodeler.zip:/Users/MikeD/Library/Java:/Library/Java:/System/
Library/Java:/Network/Library/Java:/System/Library/Frameworks/
JavaVM.framework/Classes/classes.jar:/System/Library/Frameworks/
JavaVM.framework/Classes/ui.jar:/Developer/Applications/
EOModeler.app/Contents/Resources/Java/eomodeler.zip

So downloaded the latest stable JDBC from the mySQL site, and copied the jar to the /Library/Java/Extensions/ directory. Still could not connect. However, the error message had changed to:

java/sql/Savepoint

I tried alternate entries for the URL and Optional Driver value but nothing worked. Even created a small java class to verify the JDBC Driver worked. It did. I could connect to mySQL create a new database, add tables, and create a new user. After a couple evenings of failed attempts to get a connection, I emailed a request for help to
Webobjects-dev mailing list. Received several responses.  One responder(Jacky Gagnon), suggested:

Try on another computer with 10.3.8…Or try another version of mysql-connector-java-3.1.x like 3.1.7.

Since I did not have access to a sysem with 10.3.8, I opted to tried another version of the driver. Downloaded
mysql-connector-java-3.0.16-ga.tar.gz and placed
mysql-connector-java-3.0.16-ga-bin.jar in my /Library/Java/Extensions directory and EOModerel immediately connected to mySQL.

Yahoo! What a wonderful feeling when one resolves an irritating problem like Java connections. Once again everything is right with the world … well at least it seems that way for the moment.