Re: Strange constraint violation
Re: Strange constraint violation
- Subject: Re: Strange constraint violation
- From: Chuck Hill <email@hidden>
- Date: Fri, 30 Sep 2011 11:12:27 -0700
It sure looks like you have a constraint that says t_pool.id = t_pool.id. Check in FB manager.
On 2011-09-30, at 11:06 AM, Jeff Schmitz wrote:
> Hi Pascal,
>
> Yes, it gets the same error when executed directly from FrontbaseManager:
>
> 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@hidden', 'false', 'false', 1, 'pw', 'false', 'pw', 'false', 'false', 0, 0, 0, NULL, 'false', 1000002, 1, 'false', 1000001, 0, 'false');
>
> Exception 361 (23:000). Integrity constraint violation (FOREIGN KEY, t_pool.t_pool_id_id_FK(id=1000002)).
> Exception 363 (40:000). Transaction rollback.
>
> Again, there is no row with id 1000002 in the t_pool table.
>
> Thanks,
> Jeff
>
> On Sep 30, 2011, at 6:33 AM, Pascal Robert wrote:
>
>>> withBindings:
>
> _______________________________________________
> 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
--
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden