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 23:42:32 +0800
I use Xcode.
When I launch the software, as webobjects try to find the database,
The error message is "Check your connection dictionary and ensure your
database is correctly configured". From what I can see, my connection
dictionary is correct. But I may be wrong. However I can connect from
EO Modeller to the database.
Thanks again in advanced
On 9/14/06, John Larson <email@hidden> wrote:
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