WO 5.2 and MySQL
WO 5.2 and MySQL
- Subject: WO 5.2 and MySQL
- From: David Holt <email@hidden>
- Date: Thu, 13 Feb 2003 09:11:57 -0800
Hello,
I am writing my first WO (5.2) app using MySQL (3.23.54) tables that I
have been using with PHP. I created a model in EOModeler using the
MySQL tables and the java mysql driver. I can browse the data from
within EOModeler so the connection in that context seems fine.
I have done the D2W tutorial that uses an openbase schema and it runs
and queries with no problem. It appears to be a MySQL difficulty that I
am having.
My Connection dictionary is as follows:
username:
password:
URL: jdbc:mysql://localhost/royal college?capitalizeTypeNames=true
Driver: org.gjt.mm.mysql.Driver
Plugin: Mysql
I am using Mac OS X 10.2.3 I built my Direct to Web app using WO 5.2
and it builds and runs with no problem. When I try to actually query my
database, I am presented with the following message in the D2W
application (in the Project Builder "Run" window):
[2003-02-12 16:07:46 PST] <WorkerThread2> _WOProject: could not find
path to source file for sun.reflect.DelegatingMethodAccessorImpl
DelegatingMethodAccessorImpl.java
[2003-02-12 16:10:36 PST] <WorkerThread9> An exception occurred while
trying to open a channel: java.lang.IllegalStateException: Unable to
load JDBCPlugIn 'Mysql' for JDBCAdaptor@3324204. Check your connection
dictionary and make sure the specified JDBCPlugIn subclass is in your
classpath.
[2003-02-12 16:10:36 PST] <WorkerThread9>
<com.webobjects.appserver._private.WOComponentRequestHandler>:
Exception occurred while handling request:
java.lang.IllegalStateException: _obtainOpenChannel --
com.webobjects.eoaccess.EODatabaseContext
com.webobjects.eoaccess.EODatabaseContext@a32604: failed to open
database channel. Check your connection dictionary, and ensure your
database is correctly configured.
[2003-02-12 16:10:36 PST] <WorkerThread9>
java.lang.IllegalStateException: _obtainOpenChannel --
com.webobjects.eoaccess.EODatabaseContext
com.webobjects.eoaccess.EODatabaseContext@a32604: failed to open
database channel. Check your connection dictionary, and ensure your
database is correctly configured.
at
com.webobjects.eoaccess.EODatabaseContext._obtainOpenChannel(EODatabaseC
ontext.java:2115)
Thanks in advance for any guidance you can offer.
David Holt
_______________________________________________
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.