Re: Re: Database connection error (MYSQL)
Re: Re: Database connection error (MYSQL)
- Subject: Re: Re: Database connection error (MYSQL)
- From: "Andrew Joso" <email@hidden>
- Date: Thu, 14 Sep 2006 18:29:44 +0800
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:
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