Re: How to debug fetch problem
Re: How to debug fetch problem
- Subject: Re: How to debug fetch problem
- From: Chuck Hill <email@hidden>
- Date: Tue, 10 Apr 2007 14:45:47 -0700
On Apr 10, 2007, at 2:36 PM, Janine Sisk wrote:
On Apr 10, 2007, at 2:12 PM, Chuck Hill wrote:
Is the join between the two correctly defined? Turn on SQL
logging and see what it is trying to do to fetch these.
Apparently not:
[2007-04-10 14:22:13 PDT] <WorkerThread0> === Begin Internal
Transaction
[2007-04-10 14:22:13 PDT] <WorkerThread0> evaluateExpression:
<com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression:
"SELECT t0."creationDate", t0."description", t0."eoid",
t0."imageEoid", t0."lastModifiedDate", t0."title" FROM "PANEL" t0">
[2007-04-10 14:22:13 PDT] <WorkerThread0> 2 row(s) processed
[2007-04-10 14:22:13 PDT] <WorkerThread0> === Commit Internal
Transaction
Ok, so the relationship is defined thusly:
Name images
Cardinality To One
Optionality Optional
Delete Rule Cascade
Model LicensePlate
Destination PanelImages
Inner
And then in the table below that I have image_eoid from Panel and
eoid from PanelImages listed.
That is all under the Basic tab of the Properties pane. I didn't
enter anything in the Advanced or User Info tabs.
Also, I had thought that everything was working on my save because
data appeared in both tables, but I just checked in FrontBase
Manager and confirmed that image_eoid in Panel is null, so the root
of the problem is that that is not being written properly.
OK, now we are getting somewhere. How are you connecting the create
PanelImage with the Panel? Are you connecting it? If it is not an
owned object you need to tell WO which object it belongs with.
Chuck
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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