Re: WO - can`t connect to database

On Apr 24, 2005, at 7:12 AM, Marc Manthey wrote:

> hello all,
>
> i am not an expert , after Lauching my  application , a simple 
> bulletinboard,
>
> my log shows:
>
> <WorkerThread1> 
> <com.webobjects.appserver._private.WOComponentRequestHandler>: 
> Exception occurred while handling request:
>
>     Next exception:SQL State:42000 -- error code: 0 -- msg: SQL ERROR 
> - [position 520, near 'WHERE' in 'M Login t0 WHERE t0.board'] (1)  
> table 'Login' does not exist.
>
> *********************
>
> does this mean a complete table does  not  exist ?

Although that's what the error message is saying, "it ain't necessarily 
so." (to quote an old song).

Since this is probably the application's first fetch of the database, 
it simply means it can't find the table. There could be several 
problems there, among which are database permission/security problems, 
possible key word conflicts (Is "Login" a keyword for your database's 
version of SQL?) and so forth.

On the other hand, since you gave no background information, anything 
is possible from our point of view. Does the database exist (probably, 
or you would probably have gotten a connection error)? Have the tables 
been created for it? Has the Login table been created for it? Has the 
database been started up (again, probably, or you would probably have 
gotten a connection error)?

Open your EOModel in EOModeler.  Be sure the connection dictionary is 
set correctly in EOModeler, then try browsing the database with your 
EOModel through EOModeler.  In particular, browse the Login table. If 
EOModeler can see the table, then (presuming your app doesn't change 
the connection dictionary) your app should be able to see the table.

This is one of the easier ways to debug such problems. Also try 
executing the raw SQL statement yourself. To see the exact SQL 
statement that the application is generating, set the runtime 
parameter, EOAdaptorDebugEnabled, to true when you run your app and 
check the run log for it.

> *************
>
> how can i dump the  tables from the existing  database ?
>
> ************

See above. It would help to know what database and its version you're 
using as well as what version of WebObjects, what platform you're 
running on, whether you developed the app or are trying to start up a 
packaged app, and so forth.

> thank you very much and  a nice  sunday;)

...and you as well.

Jerry

> marc
>
> --  Marc Manthey
> D - 50672 Cologne
> West Germany
> office: 0049.221.355.80.32
> mobile: 0049.177.341.54.81
> www.let.de
> www.applehelpers.com
> aim://macfreak2004
> [email protected]
> _______________________________________________
> WebObjects-talk mailing list
> [email protected]
> http://www.omnigroup.com/mailman/listinfo/webobjects-talk
>

--
__ Jerry W. Walker, Partner
     C o d e F a b, LLC - "High Performance Industrial Strength Internet 
Enabled Systems"
     [email protected]
     212 465 8484 X-102  office
     212 465 9178        fax