Category Image EOModeler Adaptor settings for connecting to MySQL


For WebObjects 5.2 you only need to fill out the URL field and the user/password fields and use a connection URL like this:

Adaptor Connection URL: jdbc:mysql://hostname/mydatabase?capitalizeTypenames=true

Update 10/4/2006: For UTF8 development, the MySQL documentation here and here indicates that the the connection URL should be set to:
jdbc:mysql://hostname/databasename?capitalizeTypenames=true&useUnicode=true&characterEncoding=UTF-8

------------------------------------------------------------------------------------------------------------------------------------
For local machine development where MySQL is running on your own OS X machine, use localhost as the hostname.



More information on the URL connection parameters can be found at:
http://dev.mysql.com/doc/refman/4.1/en/connector-j-reference-configuration-properties.html

And more interesting links here:
http://lists.apple.com/archives/webobjects-dev/2004/Jan/msg00861.html

NOTE: Make sure you have the MySQL JDBC adaptor installed first (instructions here ), otherwise EOModeler with complain with an error something like this:
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/username/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

Posted: Thursday - January 29, 2004 at 08:58 AM        

Published by