If it also Owns Destination (I think) and is to-one, then EOF will
automatically create it. Otherwise you need to create it.
Is the Pricing relationship optional or mandatory?
Is that constraint marked as DEFERRED INITIALLY DEFERRED?
Chuck
On 2011-09-30, at 11:47 AM, Jeff Schmitz wrote:
> Yep, that's the clue I needed. There's a defined relationship from Pool to
> another EO (Pricing) that I created with "Propagates primary key". Should
> such objects get created automatically in the "createxxx" function of the
> parent EO code generated by EOModeler? Seems like they would have to be to
> keep the ID's in sync, but I'm not seeing it in the generated code.
>
>
> On Sep 30, 2011, at 12:12 PM, Chuck Hill wrote:
>
>> Connect to that database using FrontBaseManager. Go to Schema Objects,
>> select that table and click the Open Definition button. Click Foreign Key
>> and see what is really set for that table. It looks like perhaps you have
>> made a self-referencing FK constraint.
>>
>>
>>
>> On 2011-09-29, at 9:44 PM, Jeff Schmitz wrote:
>>
>>> Hello all,
>>> For some reason I'm seeing the below constraint violation when I try to
>>> insert a new EO into my database (frontbase). I checked the database, and
>>> in the t_pool table, no row exists that has the ID of the row being
>>> inserted (1000002), but every time I try to insert a new row I get the
>>> below exception. Also, this build runs fine on my development machine,
>>> it's only on the deployment machine where I'm seeing this. I've tried
>>> dropping the database, re-generating my migration code and installing the
>>> new build from scratch, but no luck.
>>>
>>> I am a little confused by where it says the violation is occurring:
>>>
>>> Integrity constraint violation (FOREIGN KEY,
>>> t_pool.t_pool_id_id_FK(id=1000002)).
>>>
>>> as I don't know why it would be considered a foreign key since it's the ID
>>> of the row being added, but then I'm no low level DB expert (one of the
>>> reasons I use webobjects :-))
>>>
>>>
>>> Any ideas?
>>>
>>>
>>> evaluateExpression:
>>> <com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression: "INSERT
>>> INTO "t_pool"("c_spare_string", "c_name", "c_paid", "c_admin_email",
>>> "c_can_i_wins_calculated", "c_ud_bonus", "c_possibilities", "c_admin_pw",
>>> "c_weighted", "c_password", "c_stand_alone", "c_early_bird_paid",
>>> "c_entry_limit", "c_can_i_win_index", "c_seed_type", "c_admin_msg",
>>> "c_calculating_can_i_wins", "id", "c_pool_type", "c_updating_results",
>>> "applicationStateID", "c_results_index", "c_allow_one_entry_per_user")
>>> VALUES ('', 'ZEBRAS NEW 401K PLAN', 'false', '[email protected]', 'false',
>>> 'false', 1, 'pw', 'false', 'pw', 'false', 'false', 0, 0, 0, NULL, 'false',
>>> 1000002, 1, 'false', 1000001, 0, 'false')" withBindings: >
>>> Sep 29 22:40:39 netBrackets[2002] (ERXDatabaseContextDelegate.java:177)
>>> INFO er.transaction.adaptor.Exceptions - Database Exception occured:
>>> com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression
>>> failed: <com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression:
>>> "INSERT INTO "t_pool"("c_spare_string", "c_name", "c_paid",
>>> "c_admin_email", "c_can_i_wins_calculated", "c_ud_bonus",
>>> "c_possibilities", "c_admin_pw", "c_weighted", "c_password",
>>> "c_stand_alone", "c_early_bird_paid", "c_entry_limit", "c_can_i_win_index",
>>> "c_seed_type", "c_admin_msg", "c_calculating_can_i_wins", "id",
>>> "c_pool_type", "c_updating_results", "applicationStateID",
>>> "c_results_index", "c_allow_one_entry_per_user") VALUES ('', 'ZEBRAS NEW
>>> 401K PLAN', 'false', '[email protected]', 'false', 'false', 1, 'pw', 'false',
>>> 'pw', 'false', 'false', 0, 0, 0, NULL, 'false', 1000002, 1, 'false',
>>> 1000001, 0, 'false')" withBindings: >:
>>> Next exception:SQL State:23 subclass = 00 -- error code: 361 --
>>> msg: Exception condition 361. Integrity constraint violation (FOREIGN KEY,
>>> t_pool.t_pool_id_id_FK(id=1000002)).
>>> Next exception:SQL State:40 subclass = 00 -- error code: 363 --
>>> msg: Exception condition 363. Transaction rollback.
>>> Sep 29 22:40:39 netBrackets[2002] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog
>>> - === Rollback Internal Transaction
>>> com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression
>>> failed: <com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression:
>>> "INSERT INTO "t_pool"("c_spare_string", "c_name", "c_paid",
>>> "c_admin_email", "c_can_i_wins_calculated", "c_ud_bonus",
>>> "c_possibilities", "c_admin_pw", "c_weighted", "c_password",
>>> "c_stand_alone", "c_early_bird_paid", "c_entry_limit", "c_can_i_win_index",
>>> "c_seed_type", "c_admin_msg", "c_calculating_can_i_wins", "id",
>>> "c_pool_type", "c_updating_results", "applicationStateID",
>>> "c_results_index", "c_allow_one_entry_per_user") VALUES ('', 'ZEBRAS NEW
>>> 401K PLAN', 'false', '[email protected]', 'false', 'false', 1, 'pw', 'false',
>>> 'pw', 'false', 'false', 0, 0, 0, NULL, 'false', 1000002, 1, 'false',
>>> 1000001, 0, 'false')" withBindings: >:
>>> Next exception:SQL State:23 subclass = 00 -- error code: 361 --
>>> msg: Exception condition 361. Integrity constraint violation (FOREIGN KEY,
>>> t_pool.t_pool_id_id_FK(id=1000002)).
>>> Next exception:SQL State:40 subclass = 00 -- error code: 363 --
>>> msg: Exception condition 363. Transaction rollback.
>>> at
>>> com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504)
>>> at
>>> com.webobjects.eoaccess.EODatabaseContext.performChanges(EODatabaseContext.java:6216)
>>> at
>>> com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376)
>>> at
>>> com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192)
>>> at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:1094)
>>> at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:1016)
>>>
>>> _______________________________________________
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list ([email protected])
>>> Help/Unsubscribe/Update your Subscription:
>>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
>>>
>>> This email sent to [email protected]
>>
>> --
>> Chuck Hill Senior Consultant / VP Development
>>
>> 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
>>
>>
>>
>>
>>
>>
>>
>
--
Chuck Hill Senior Consultant / VP Development
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
