Re: Database connection error (MYSQL)
Re: Database connection error (MYSQL)
- Subject: Re: Database connection error (MYSQL)
- From: Paul Lynch <email@hidden>
- Date: Thu, 14 Sep 2006 17:01:33 +0100
EOModeler uses a different driver from your WebObjects app. Either
your driver for WebObjects isn't installed, or is in the wrong
location. I don't use MySQL (it doesn't conform to my definition of
a database, which seems to be my problem to deal with), but there
have been several messages in the past on this list about how to
install the drivers for it, and which ones to use.
Paul
On 14 Sep 2006, at 16:42, Andrew Joso wrote:
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%
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
>> 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.
_______________________________________________
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