Re: Database connection error (MYSQL)
Re: Database connection error (MYSQL)
- Subject: Re: Database connection error (MYSQL)
- From: John Larson <email@hidden>
- Date: Thu, 14 Sep 2006 09:22:25 -0500
So I take it that the error is occurring when you are launching from
you IDE? Which IDE are you using: Eclipse or XCode?
On Sep 14, 2006, at 5:29 AM, Andrew Joso wrote:
Thank you very much for replying.
However, I don't use Tomcat.
I only use WebObjects, EO, MYSQL.
The problem is just when webobjects is trying to request data to
MYSQL.
EO modeller doesn't have any problem to communicate to the MYSQL
database.
Help is greatly appreciated.
Thank you
Andrew Joso
On 9/14/06, John Larson <email@hidden> wrote:
It looks like you may be using Tomcat. If so, then I quote from
http://www.sisuworks.com/page3/files/WebObjects Tomcat MySQL.rtf:
Open the /Library/Tomcat/apache-tomcat-5.5.12/webapps/yourappname/
WEB-INF/
folder, and open the web.xml file using a text editor, or command-
line
editor.
Comment-out these line:
<resource-ref>
<description>The data source to be used by EOF. If there are
multiple
data sources,
then the definition below must be used to
configure which
JDBC URL (Model) should
use which data source. If EOF should use a JDBC
driver
directly, this section must be commented out</description>
<res-ref-name>jdbc/DefaultDataSource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
By adding this:
<!--
<resource-ref>
<description>The data source to be used by EOF. If there are
multiple
data sources,
then the definition below must be used to
configure which
JDBC URL (Model) should
use which data source. If EOF should use a JDBC
driver
directly, this section must be commented out</description>
<res-ref-name>jdbc/DefaultDataSource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
-->
Hope that is it,
John
On Sep 13, 2006, at 11:48 PM, Andrew Joso wrote:
As the webobjects is trying to request data from the database, I got
this error message
java.lang.IllegalStateException: _obtainOpenChannel --
com.webobjects.eoaccess.EODatabaseContext
com.webobjects.eoaccess.EODatabaseContext@3598c3: failed to
open
database channel. Check your connection dictionary, and ensure your
database is correctly configured.
The database that I use is MYSQL and it is located in the same
machine. I have checked the connection dictionary and it seems to be
correct.
I am able to see the database from the EO Modeller. It's just when
webobjects request for data, the error message is thrown.
Can someone help me ?
Thank you for your help. It's greatly appreciated
AJoso
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40mac.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden