Re: Database connection error (MYSQL)
Re: Database connection error (MYSQL)
- Subject: Re: Database connection error (MYSQL)
- From: Randy Wigginton <email@hidden>
- Date: Thu, 14 Sep 2006 12:43:27 -0400
The problem comes from having the mysql JDBC driver in the "wrong"
location for webobjects. EOModeler picks it up, but WO does not.
Put it in /System/Library/Java and you'll be running.
On Sep 14, 2006, at 12:10 PM, John Larson wrote:
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:
40gmail.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