Re: MySQL and WebObjects
Re: MySQL and WebObjects
- Subject: Re: MySQL and WebObjects
- From: Geoff Hopson <email@hidden>
- Date: Fri, 24 Jan 2003 09:40:03 +0000
THis is what I do:
a) put mm.mysql-2.0.14-bin.jar in /Library/Java/Extensions
b) restart EOModeler
c) open 'Set Adaptor Info'
d) Enter the following values:
Username: <your mysql username>
Password: <your mysql user password>
URL: jdbc:mysql://127.0.0.1/<your DB name inside
mysql>?useUnicode=true&characterEncoding=UTF-
8&autoReconnect=true&maxReconnects=3&capitalizeTypeNames=true&readOnly=t
rue
Driver: org.gjt.mm.mysql.Driver
All the above works for me, gleaned from the incredibly useful
http://www.prnet.de/RegEx/mysql-wo.html
Hope that helps,
Geoff
On Friday, January 24, 2003, at 03:14 am, Ari Denison wrote:
Hi. I'm completely new to WebObjects, Java and this list. I am
learning WebObjects as a possible alternative to Lasso, and also
because I'm unemployed and bored. I'm hoping that someone can help me
get connected to my MySQL database. I'm encountering an error in
EOModeler and I suspect it's for one of two possible reasons.
Here's the error:
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/ari/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
Here are the two possible reasons I suspect caused this error:
1. I did something wrong when I installed WebObjects developer
software.
2. The URL I am using in EOModeler isn't correct.
jdbc:mysql://localhost:3306/DATABASENAME
I have also tried
jdbc:mysql://localhost/DATABASENAME
I suspect it's the former.
I haven't had any success locating specific information on using
WebObjects with MySQL.
So if anyone has any suggestions for fixing the problem or on
WebObjects/MySQL documentation I would greatly appreciate it.
Many thanks,
Ari Denison
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
--
Geoff Hopson
Objectology Ltd.
http://www.objectology.co.uk/
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.