Re: Database connection error (MYSQL)
Re: Database connection error (MYSQL)
- Subject: Re: Database connection error (MYSQL)
- From: John Larson <email@hidden>
- Date: Thu, 14 Sep 2006 11:10:11 -0500
It's been a while since I've used XCode, but I am afraid that Paul is
right about the driver. I have personally dealt with this on
deployment, but not in development. I'd check the list or google for
prior postings with this issue. Another troubleshooting path is to
try making a new project with the wizard and try just one table to
see if anything is working.
John
On Sep 14, 2006, at 11:01 AM, Paul Lynch wrote:
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