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 PROTECTED]> wrote:
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]
