I'm trying to open up a JDBC connection to a MySQL server using EOModeler. I specify my username and password and the URL of "jdbc:mysql://localhost/test? useUnicode=true&characterEncoding=UTF8". When I try to connect I get the following error:

  Communication failure during handshake. Is there a server running
  on localhost:3306?

I know the server is running at localhost:3306 as I can connect to it via the MySQL Administrator.

If I try to specify a specific driver such as com.mysql.jdbc.Driver I get the following error:

JDBC connection failed for driver :'com.mysql.jdbc.Driver'. Driver not found in Java Runtime! Please verify your CLASSPATH environment variable. The current CLASSPATH for your application is : /Developer/ Applications/WebObjects/EOModeler.app/Contents/Resources/Java/ eomodeler.zip:/Users/keith/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/WebObjects/ EOModeler.app/Contents/Resources/Java/eomodeler.zip

Where is EOModeler picking up the value of CLASSPATH from?

I'm running with the following:

  MacOS 10.4.2
  MySQL 4.1.14
  MySQL Connector/J 3.0.17
  MySQL Database Driver mm.mysql-2.0.14

I tried putting the jar files for Connector/J and the driver in $JAVA_HOME/jre/lib/ext as stated in the driver Readme file but it doesn't look like EOModeler is finding them there given the error message when I explicitly state which driver class to use (com.mysql.jdbc.Driver)?

What is the default driver if one is not specified? Is it one for OpenBase since that is the default database EOModeler is setup to use?

Any help would be greatly appreciated.

Thanks,
  Keith
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to