Re: weird sql generation problem
Re: weird sql generation problem
- Subject: Re: weird sql generation problem
- From: Chuck Hill <email@hidden>
- Date: Mon, 31 Aug 2009 22:28:06 -0400
On Aug 31, 2009, at 9:06 PM, Tim Worman wrote:
In looking through the prototype model for EOJDBCOpenBasePrototype I
found that the "id" attribute there has a column name of "id." I'll
bet that the prototype is what is causing the problem here.
I am not sure of that, though it does sound suspicious. If the
attributes using this prototype define a column name, then that should
override the name in the prototype.
So, I'm trying to build ERPrototypes manually from within Eclipse
which is causing another problem. wocompile task is returning errors:
[wocompile] /Users/worman/Source/wonder/Frameworks/Core/ERPrototypes/
Sources/er/prototypes/ERPrototypes.java:3: package er.extensions
does not exist
[wocompile] import er.extensions.ERXExtensions; errors
The ERExtensions project is building in Eclipse so I don't know what
is causing this. I don't usually build Wonder myself.
I am unsure if you can Ant build and Install the frameworks from
Eclipse. I always do it from the command line. I am not going to
look, but I think that Ray has updated the build instructions in svn.
Chuck
On Aug 31, 2009, at 4:20 PM, Chuck Hill wrote:
On Aug 31, 2009, at 7:10 PM, Tim Worman wrote:
On Aug 31, 2009, at 3:54 PM, Chuck Hill wrote:
On Aug 31, 2009, at 6:41 PM, Tim Worman wrote:
On Aug 31, 2009, at 3:27 PM, Ray Kiddy wrote:
On Aug 31, 2009, at 2:54 PM, Tim Worman wrote:
WO'ers:
My app is crashing with an sql error that looks like this:
SQL ERROR - [position 572, near 'WHERE' in 'IBUTION t0 WHERE
(t0.is_d'] (1) field 'id' not found in table
'FUND_DISTRIBUTION'. SQL: SELECT t0.account_number,
t0.appt_begin_date, t0.appt_num, t0.cost_center_code,
t0.create_date, t0.dist_dept_code, t0.dist_num,
t0.dist_off_above, t0.dist_payrate_hour,
t0.dist_payrate_month, t0.dist_percent, t0.dist_perq,
t0.dist_step, t0.dos_earnings_type, t0.emp_full_name,
t0.emp_status, t0.employee_id, t0.fund_distribution_id,
t0.fund_number, t0.hrly_as_mthly_est, t0.id, t0.is_debit,
t0.job_id, t0.location_code, t0.modify_date,
t0.pay_begin_date, t0.pay_end_date, t0.project, t0.sub_code,
t0.sub_location, t0.title_code, t0.work_study_pgm FROM
FUND_DISTRIBUTION t0 WHERE (t0.is_debit = 'false' AND
(t0.dos_earnings_type <> 'STP' AND t0.dos_earnings_type <>
'RES' AND t0.job_id = 219)) ORDER BY t0.pay_end_date DESC
In my model there is no "id" attribute for the
FundDistribution entity. The table obviously doesn't have a
matching column hence the error. But why is sql being
generated for an attribute that doesn't exist? I looked at
FundDistribution.plist in the model and there is no "id"
attribute in there.
Your model must contain an attribute with some name (which
could be very different than "id") and which has a columnName
of "id". You will not see this by looking at the attribute names.
There are no attributes with the column name "id" either. I've
confirmed this both through Entity Modeler and by viewing the
raw plist file for the entity.
Look for attributes with *no* column name defined that use a
prototype that has id for the column name.
Chuck
Thanks Chuck. I don't appear to have any attributes with no column
name defined. Here's a screenshot of the entity definition.
I'd suspect a caching issue. Have you tried restarting Eclipse and
cleaning the affect project(s)?
Chuck
_______________________________________________
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