It looks like you may be using Tomcat.  If so, then I quote from http://www.sisuworks.com/page3/files/WebObjects%20Tomcat%20MySQL.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
[EMAIL PROTECTED]: 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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/the_larsons%40mac.com

This email sent to [EMAIL PROTECTED]

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to