Re: creating first framework
Ahg! Don't worry, I'm not getting a big head over it. It makes me feel like crap for not getting the updated one done at WOWODC 2011! I *still* have to do it. Not a huge amount has changed, and I have some better build scripts. I will be rebuilding one of the Hudson servers I have responsibility for in the next couple weeks. Once I've done that I'll get an updated presentation / screen cast ready an maybe even do it as a WebEx presentation. Dave On Oct 1, 2011, at 1:05 AM, Chuck Hill wrote: > > On 2011-09-30, at 9:57 AM, Ramsey Gurley wrote: > >> >> On Sep 30, 2011, at 9:43 AM, Chuck Hill wrote: >> >>> >>> On 2011-09-30, at 9:15 AM, Ramsey Gurley wrote: >>> On Sep 30, 2011, at 8:56 AM, Jean-Francois Veillette wrote: > >> Dave Avendasora's presentation 'Practical Builds (WOWODC East 2009)' is >> really good if you're having difficulty with Jenkins. > > Wow, that Video is very informative about configuring Hudson and what is > missing and all! > I'm halfway through and will take the time to finish it. Well done > presentation! > > jfv Yeah, Dave did a kick ass job. I've probably watched that podcast more than any other one. >>> >>> Great. Now he is going to be walking around Brunei with this great, swelled >>> head. :-) >>> >>> -- >>> Chuck Hill Senior Consultant / VP Development >>> >> >> Oh no! With Brunei situated on the coast like it is, that may cause the >> entire island to tip over and capsize! >> >> http://www.youtube.com/watch?v=zNZczIgVXjg > > > We an only hope and pray that Sarawak will keep it upright! > > > -- > 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 (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com > > This email sent to webobje...@avendasora.com > > ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Strange constraint violation
On 2011-10-01, at 4:31 AM, Jeff Schmitz wrote:
> Well, I thought I was, but apparently I wasn't. After deleting all my wonder
> framework projects (I'm using them from source), updating my Wonder source
> from git, and re-adding them back into my workspace and build path, the
> constraint is now being created DEFERRED INITIALLY DEFERRED. I also put a
> break point in the wonder source in function
> foreignKeyConstraintStatementsForRelationship, and it is getting hit for
> every addForeignKey call in my migration code.
>
> In the meantime though, I re-designed my database to remove the problem
> problem foreign key that was setup with owns destination and propagate id, so
> not sure if this would have fixed my original problem or not.
It would have. That is its purpose.
Chuck
>
> As always, thanks much for you help.
>
> Jeff
>
> On Sep 30, 2011, at 3:04 PM, Chuck Hill wrote:
>
>>
>> On 2011-09-30, at 12:18 PM, Jeff Schmitz wrote:
>>
>>> Yes, it is also set to "Owns Destination". It's "to-one" from Pool to
>>> Pricing, but I didn't create a return relationship in the Pricing EO, so I
>>> don't know if you would consider that one-to-one. It is mandatory though.
>>>
>>> Deferrable is set to No, Check Time is set to Initially Immediate.
>>
>> That part is wrong. DEFERRED INITIALLY DEFERRED is what you want. Entity
>> Modeler or Migrations SHOULD be generating that for you. You are using the
>> Wonder Frontbase plugin, right?
>>
>> Chuck
>>
>>
>>>
>>> Oh, and after dropping and restoring the DB on my dev machine, the error is
>>> now reproducible on it too.
>>>
>>> On Sep 30, 2011, at 1:54 PM, Chuck Hill wrote:
>>>
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 (102), 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=102)).
>>>
>>> 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:
>>> >> "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', 'x...@yyy.com', 'false',
>>> 'false', 1, 'pw', 'false', 'pw', 'false', 'false', 0, 0, 0, NULL,
>>> 'false', 102, 1, 'false', 101, 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
>>>
Re: Strange constraint violation
Well, I thought I was, but apparently I wasn't. After deleting all my wonder
framework projects (I'm using them from source), updating my Wonder source from
git, and re-adding them back into my workspace and build path, the constraint
is now being created DEFERRED INITIALLY DEFERRED. I also put a break point in
the wonder source in function foreignKeyConstraintStatementsForRelationship,
and it is getting hit for every addForeignKey call in my migration code.
In the meantime though, I re-designed my database to remove the problem problem
foreign key that was setup with owns destination and propagate id, so not sure
if this would have fixed my original problem or not.
As always, thanks much for you help.
Jeff
On Sep 30, 2011, at 3:04 PM, Chuck Hill wrote:
>
> On 2011-09-30, at 12:18 PM, Jeff Schmitz wrote:
>
>> Yes, it is also set to "Owns Destination". It's "to-one" from Pool to
>> Pricing, but I didn't create a return relationship in the Pricing EO, so I
>> don't know if you would consider that one-to-one. It is mandatory though.
>>
>> Deferrable is set to No, Check Time is set to Initially Immediate.
>
> That part is wrong. DEFERRED INITIALLY DEFERRED is what you want. Entity
> Modeler or Migrations SHOULD be generating that for you. You are using the
> Wonder Frontbase plugin, right?
>
> Chuck
>
>
>>
>> Oh, and after dropping and restoring the DB on my dev machine, the error is
>> now reproducible on it too.
>>
>> On Sep 30, 2011, at 1:54 PM, Chuck Hill wrote:
>>
>>> 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 (102), 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=102)).
>>
>> 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:
>> > 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', 'x...@yyy.com', 'false', 'false', 1, 'pw', 'false',
>> 'pw', 'false', 'false', 0, 0, 0, NULL, 'false', 102, 1, 'false',
>> 101, 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: > "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_alon
