Re: WO - can`t connect to database

Hi, Marc,

I don't know how familiar you are with EOModeler, but this sounds like  
you're misunderstanding my advice.

So, at the risk of patronizing you if you know it well (sorry), I will  
respond as if you don't to try to help you through what sounds like a  
potentially bad Monday.

The EOModeler Generate SQL button (and menu item of the same name) is  
used to generate the SQL statements necessary to create/delete the  
database or tables reflected in your EOModel. It is NOT used to browse  
the data.

In order to browse data using EOModeler, simply select an entity and  
click on the little yellow cylinder with the magnifying glass over it  
in the tool bar (or select "Tools->Data Browser..."  from the menu). If  
your connection dictionary is correct and you can successfully connect  
to the database, then a window will pop up displaying up to 1000 rows  
of data from the table represented by the entity you selected.

If something is wrong either with your connection dictionary or the  
connection itself, then EOModeler should pop up a panel indicating what  
it thinks is wrong. If everything is OK, but the table you're browsing  
is empty, then an empty window with the appropriate column names will  
pop-up with no data.

This is not a fool proof method of debugging your connection, since  
EOModeler uses a different Java version than the latest version of WO  
and since it uses the JavaBridge to bridge between the Objective C code  
from which the current EOModeler is implemented and any Java code it  
needs to use.

However, I have used the browser feature often to quickly resolve  
issues like whether my connection dictionary is correct, whether a  
table exists in the database or whether it contains the data I think is  
there (or any data at all, for that matter).

Since I see from your connection dictionary adaptor info that you're  
connecting to OpenBase, you might also use the OpenBase Manager to  
browse the data. Either method (EOModeler or OpenBase Manager) can be  
used to do a great deal of database investigation, right down to the  
row and column data, without resorting to SQL.

Hope this helps.

Good luck,
Jerry


On Apr 24, 2005, at 9:53 PM, Marc Manthey wrote:

>
> On 24. Apr 2005, at 14:44 Uhr, Jerry W. Walker wrote:
>
>> 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.
>
> hello jerry, all
>
> and thank you for your assistance , i opened my database in emodeler  
> and
> set the  adapter info to  jdbc:openbase://127.0.0.1/WOBB
> i went to the Property Menu and select Generate SQL.
>
> After i want  to browse an error pops  up "The url cannot be null" ?
>
> and this:
>
> An unexpected error has occurred which may cause EOModeler to  
> malfunction.  You may want to save copies of your open documents and  
> quit EOModeler.
>
> Error: JDBCAdaptorException: The url cannot be null
> Stack Trace:
> JDBCAdaptorException: The url cannot be null
> 	at JDBCContext.connect(JDBCContext.java:244)
> 	at JDBCContext._tryConnect(JDBCContext.java:331)
> 	at JDBCContext._fetchJDBCInfo(JDBCContext.java:558)
> 	at JDBCPlugIn.jdbcInfo(JDBCPlugIn.java:862)
> 	at JDBCAdaptor.jdbcInfo(JDBCAdaptor.java:233)
> 	at  
> JDBCExpressionFactory.createExpression(JDBCExpressionFactory.java:22)
> 	at  
> EOSQLExpressionFactory.expressionForString(EOSQLExpressionFactory.java: 
> 60)
> 	at  
> EOSynchronizationFactory._expressionForString(EOSynchronizationFactory. 
> java:980)
> 	at  
> EOSynchronizationFactory.dropPrimaryKeySupportStatementsForEntityGroups 
> (EOSynchronizationFactory.java:611)
> 	at  
> EOSynchronizationFactory.schemaCreationStatementsForEntities(EOSynchron 
> izationFactory.java:842)
> 	at  
> EOSynchronizationFactory.schemaCreationScriptForEntities(EOSynchronizat 
> ionFactory.java:663)
>
> regards
>
>
> marc
>
>>> thank you very much and  a nice  sunday;)
>>
>> ...and you as well.
>
> its  monday  now:-(((
>
> -- 
> 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