Re: [SOLVED] App hangs on 1st access to DB
Re: [SOLVED] App hangs on 1st access to DB
- Subject: Re: [SOLVED] App hangs on 1st access to DB
- From: Jonathan Rochkind <email@hidden>
- Date: Thu, 25 Mar 2004 16:19:06 -0600
Footnote:
Curious that no death was reported, that there was no server
log entry, and the app just hung with no HTML sent at all.
That definitely indicates a WO bug of some kind. Even if
objectMatchingKeyAndValue threw an exception, you'd expect this
exception would simply be reported to
WOApplication.handleException(). It's not supposed to hang the app.
Odd. If this is a bug in WO itself, it would definitely be nice to
figure it out and report it to Apple. But few of us have time to hunt
down bugs we've already worked around satisfactorily.
At 1:46 PM -0800 3/25/04, Baiss Eric Magnusson wrote:
I added:
NSLog.allowDebugLoggingForGroups( NSLog.DebugGroupSQLGeneration );
NSLog.allowDebugLoggingForGroups( NSLog.DebugGroupDatabaseAccess );
And saw:
com.webobjects.eoaccess.EOObjectNotAvailableException:
objectMatchingValueForKeyEntityNamed: No Regions found with key
regionName matching Seattle_&_Eastside
Why, (throw mud on face):
I did not put a try-catch around the
<EOUtilities.objectMatchingKeyAndValue> call because the regions
were hard-coded DB values.
But, there was a 1 character difference between the default
region name in the DB on the development box and the deploy box.
Thanks to Chuck for the prodding, and to Marc Repass for answering
Kaj Helner's question about how to show the generated SQL.
On Mar 24, 2004, at 6:11 PM, Chuck Hill wrote:
Can you run the equivalent SQL for that? Perhaps exporting and
re-importing the data might help. Can you tell if a request is
being made of the DB server? Is it hanging there, or before or
after the select?
Chuck
----
Baiss Eric Magnusson
<http://www.Track-Your-Finances.com>
<http://www.CascadeWebDesign.com>
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.