Re: failed to open database channel. Check your connection dictionary, and ensure your database is correctly configured.

On Jul 28, 2005, at 6:52 AMGMT-04:00, Robert Huber@7r wrote:

> _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext  
> com.webobjects.eoaccess.EODatabaseContext@ddf0a: failed to open  
> database channel. Check your connection dictionary, and ensure your  
> database is correctly configured.

In my limited experience, this error can be taken at face value. A  
misspelled word, a change in permissions on the database, etc.

Questions:

Have you changed the ip/hostname of your dev machine recently? Is  
that ip/hostname properly listed in the mysql:user table of the server?

Do you have a firewall turned on?


> how can I access the mentioned connection dictionary?

The connection dictionary is usually that info in the "Adapter Info"  
of EOModel Window. Or, it can be a separate connection dictionary you  
write within the code. Have you hard-coded the connection info  
anywhere in your application?

Try this: Open the model, change some parameters of "Adapter Info",  
then change it back. When you close the "Adapter Info" window, the  
model will try connecting to the database. (You'll sometimes have to  
wait a few seconds). Any problems?

I get the same error every once in a while. If I look around long  
enough, the problem will become clear.

Jaime