For posterity:
- if you get this error then yes there's a problem with your model :-)
- For me, changing the restricting qualifiers to reference a character flag
instead of a boolean seems to have fixed this issue. So that would be one
example of what not to do.
- As Chuck said in his last, it appears I do not need a restricting qualifier
on my abstract entity.
Thanks Chuck, Dave, and Kevin for your suggestions.
Tim
Tim Worman
UCLA GSE&IS
On Jan 4, 2010, at 5:32 PM, Chuck Hill wrote:
>
> On Jan 4, 2010, at 5:06 PM, Tim Worman wrote:
>
>> On Jan 4, 2010, at 4:39 PM, Chuck Hill wrote:
>>
>>> On Jan 4, 2010, at 4:30 PM, Tim Worman wrote:
>>>> On Jan 4, 2010, at 4:00 PM, David Avendasora wrote:
>>>>> On Jan 4, 2010, at 6:42 PM, Tim Worman wrote:
>>>>>> On Jan 4, 2010, at 3:27 PM, Chuck Hill wrote:
>>>>>>> On Jan 4, 2010, at 3:13 PM, Tim Worman wrote:
>>>>>>>
>>>>>>>> Is it pretty much a certainty that the error I'm experiencing is
>>>>>>>> caused by a problem in my models? This problem is a show stopper for
>>>>>>>> me right now. Just for refresher, the error is:
>>>>>>>>
>>>>>>>> Error: java.lang.IllegalStateException: The object with globalID
>>>>>>>> _EOIntegralKeyGlobalID[Timesheet (java.lang.Long)10253] could not be
>>>>>>>> found in the database. This could be result of a referential integrity
>>>>>>>> problem with the database. An empty fault could not be created because
>>>>>>>> the object's class could not be determined (e.g. the GID is temporary
>>>>>>>> or it is for an abstract entity)
>>>>>>>
>>>>>>> Does a Timesheet with a 10253 actually exist in the database? Is
>>>>>>> Timesheet in an inheritance hierarchy? If so, check very, very
>>>>>>> carefully for a duplicated PK.
>>>>>>
>>>>>> Timesheet is in an inheritance hierarchy. From the original post, this
>>>>>> is how Timesheet is modeled:
>>>>>>
>>>>>> Timesheet (abstract parent) <-----------------< TimeEntry (just a time
>>>>>> entry on a timesheet)
>>>>>> TimesheetExempt (child)
>>>>>> TimesheetNonExempt(child)
>>>>>>
>>>>>> Yes, there is a Timesheet with timesheet_id=10253. There are no
>>>>>> Timesheet with duplicate timesheet_id. The error is thrown when
>>>>>> TimeEntry.timesheet() is called.
>>>>>
>>>>> What is the restricting qualifier on each Timesheet entity?
>>>>>
>>>>> Dave
>>>>
>>>> Timesheet is abstract and does not have a restricting qualifier.
>>>
>>> And that, IIRC, is your problem. Add one that matches nothing.
>>
>> Ya know - I'm feeling some deja vu about this. I probably am just ridiculous
>> enough to reach a similar problem twice and have a conversation with you
>> about it. Sorry if that's the case. Anyway, is this what you're suggesting?
>>
>> TimesheetAbstract (no restricting qual)
>> TimesheetGeneric (1=0 or some such - I think I may have tried that qual
>> before and it didn't work)
>
> Ignore that. It does not need a restricting qualifier. That was some long
> ago voodoo I was remembering or imagining.
>
>
>> TimesheetExempt (isExempt=1)
>> TimesheetNonExempt (isExempt=0)
>>
>>
>>>> The entity has an attribute 'isExempt' which is boolean and modeled using
>>>> the toString approach. So, 'true' and 'false' are being stored in the
>>>> database. My restricting qualifiers for the child entities is as follows:
>>>>
>>>> TimesheetExempt: 'isExempt=1'
>>>> TimesheetNonExempt: 'isExempt=0'
>>>>
>>>> Maybe I would be better off not using a boolean attribute and instead have
>>>> a string flag of with values of 'E' and 'N?' Then I could put a cover
>>>> method Timesheet.isExempt() to return the boolean.
>>>
>>> Can Timesheets ever change from Exempt to Non-Exempt? Where is Kieran to
>>> tell you to use the Role pattern for this? Kieran? Hello?
>>
>> No, they can't. A Timesheet is either exempt or non-exempt because it
>> belongs to a Job that is either exempt or non-exempt. That status can't
>> change for a job or a timesheet so I'm guaranteed safe to model it if I can
>> get it working.
>>
>>> I think the best practices for restricting values are:
>>> 1. Don't try to be clever. Use E and N.
>>
>> OK, I'm going to try and re-model it like that and see if it makes a
>> difference.
>>
>>> 2. Don't use the restricting value for anything else. Ever.
>>
>>> public boolean isExempt() { return
>>> TimesheetExempt.ENTITY_NAME.equals(entityName()));
>>> or add another column, or something.
>>
>> OK, thanks for that - I would not have done that for sure. :-)
>>
>> Tim
>>
>>> Chuck
>>>>
>>>> Tim
>>>>
>>>>>>
>>>>>> Tim
>>>>>>
>>>>>>> Chuck
>>>>>>>
>>>>>>>
>>>>>>>>
>>>>>>>> I've tested the equality of the connection dictionaries of the models
>>>>>>>> and they are equal.
>>>>>>>>
>>>>>>>> Tim Worman
>>>>>>>> UCLA GSE&IS
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Dec 31, 2009, at 12:36 AM, Tim Worman wrote:
>>>>>>>>
>>>>>>>>> On Dec 30, 2009, at 3:18 AM, David Avendasora wrote:
>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Dec 29, 2009, at 9:46 PM, Tim Worman wrote:
>>>>>>>>>>
>>>>>>>>>>> OK, so, I've reviewed all the prototypes in use, data types, etc. I
>>>>>>>>>>> did find some areas where my prototypes were messed up so it was
>>>>>>>>>>> worth it to go through it all. The fk and pk both are long values.
>>>>>>>>>>>
>>>>>>>>>>> But I'm still getting the same error. This solution also doesn't
>>>>>>>>>>> cross databases. It does crosses models at this point. But the
>>>>>>>>>>> TimeEntry and Timesheet entities are in the same model.
>>>>>>>>>>
>>>>>>>>>> If TimeEntry and Timesheet are in the same model, what crosses
>>>>>>>>>> models? The inheritance hierarchy? What type of Inheritance are you
>>>>>>>>>> using?
>>>>>>>>>>
>>>>>>>>>> If you have two models that point to the same database you have to
>>>>>>>>>> be very careful to make sure that the connection dictionaries of the
>>>>>>>>>> two models are EXACTLY IDENTICAL (yelling intended). This is very,
>>>>>>>>>> very important. Otherwise they will likely have different
>>>>>>>>>> EODatabaseContexts which can cause all manor of EOF confusion when
>>>>>>>>>> it comes to assigning keys.
>>>>>>>>>>
>>>>>>>>>> Read this thread from way back in 2006 where Mike Schrag seemed to
>>>>>>>>>> have a similar problem (start at the beginning):
>>>>>>>>>> http://lists.apple.com/archives/webobjects-dev//2006/May/msg00530.html
>>>>>>>>>
>>>>>>>>> Thanks Dave. But I still don't have a solution. I tested all the
>>>>>>>>> models that refer to the same database. I'm testing the equality of
>>>>>>>>> the connection dictionaries at app launch and they all pass the
>>>>>>>>> connectionDictionary().equals() test. There is another JNDI model
>>>>>>>>> that obviously refers to an LDAP data source and necessarily the
>>>>>>>>> connection dictionary to that is different.
>>>>>>>>>
>>>>>>>>> Any other ideas about what is causing the problem or troubleshooting
>>>>>>>>> techniques you'd employ here? Obviously I'm doing something wrong?
>>>>>>>>>
>>>>>>>>> Tim
>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Dave
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> Tim Worman
>>>>>>>>>>> UCLA GSE&IS
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> On Dec 28, 2009, at 4:45 PM, [email protected] wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Check cross database issues and also name sure the types on your
>>>>>>>>>>>> pk and fk match ... I notice that says your fk is a long, make
>>>>>>>>>>>> sure that matches the pk of the destination entity.
>>>>>>>>>>>>
>>>>>>>>>>>> Sent from my iPhone
>>>>>>>>>>>>
>>>>>>>>>>>> On Dec 28, 2009, at 7:33 PM, "Tim Worman"<[email protected]>
>>>>>>>>>>>> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> ...or wondering if I've modeled something incorrectly.
>>>>>>>>>>>>>
>>>>>>>>>>>>> I've got a model with these Entities:
>>>>>>>>>>>>>
>>>>>>>>>>>>> Timesheet (abstract parent) >----------------- TimeEntry (just
>>>>>>>>>>>>> a time entry on a timesheet)
>>>>>>>>>>>>> TimesheetExempt (child)
>>>>>>>>>>>>> TimesheetNonExempt(child)
>>>>>>>>>>>>>
>>>>>>>>>>>>> Everything works fine until a given TimeEntry tries to refer back
>>>>>>>>>>>>> to its timesheet by calling timesheet(). At that point I get this
>>>>>>>>>>>>> error:
>>>>>>>>>>>>>
>>>>>>>>>>>>> Error: java.lang.IllegalStateException: The object with
>>>>>>>>>>>>> globalID _EOIntegralKeyGlobalID[Timesheet (java.lang.Long)10253]
>>>>>>>>>>>>> could not be found in the database. This could be result of a
>>>>>>>>>>>>> referential integrity problem with the database. An empty fault
>>>>>>>>>>>>> could not be created because the object's class could not be
>>>>>>>>>>>>> determined (e.g. the GID is temporary or it is for an abstract
>>>>>>>>>>>>> entity)
>>>>>>>>>>>>>
>>>>>>>>>>>>> It is true that the GID would be for an abstract entity -
>>>>>>>>>>>>> Timesheet. But I assumed that a TimeEntry would not need to know
>>>>>>>>>>>>> specifically what variety of Timesheet it is dealing with. I
>>>>>>>>>>>>> guess the question I have is, what is the better way to model
>>>>>>>>>>>>> this? Will it be necessary for me to model TimeEntryExempt and
>>>>>>>>>>>>> TimeEntryNonExempt just so the time entries know which type of
>>>>>>>>>>>>> timesheet they belong to and don't call the abstract parent?
>>>>>>>>>>>>>
>>>>>>>>>>>>> Tim
>>>>>>>>>>>>> UCLA GSE&IS
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>> 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/mschrag%40mdimension.com
>>>>>>>>>>>>>
>>>>>>>>>>>>> This email sent to [email protected]
>>>>>>>>>>>
>>>>>>>>>>> _______________________________________________
>>>>>>>>>>> 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/webobjects%40avendasora.com
>>>>>>>>>>>
>>>>>>>>>>> This email sent to [email protected]
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> David Avendasora
>>>>>>>>>> Senior Software Engineer
>>>>>>>>>> K12, Inc.
>>>>>>>>>>
>>>>>>>>>> *****
>>>>>>>>>> WebObjects Documentation Wiki :
>>>>>>>>>> http://wiki.objectstyle.org/confluence/display/WO/
>>>>>>>>>> *****
>>>>>>>>>> WebObjects API:
>>>>>>>>>> http://developer.apple.com/legacy/mac/library/documentation/MacOSXServer/Reference/WO54_Reference/index.html
>>>>>>>>>> *****
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> 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/lists%40thetimmy.com
>>>>>>>>>
>>>>>>>>> This email sent to [email protected]
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> 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
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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/webobjects%40avendasora.com
>>>>>>
>>>>>> This email sent to [email protected]
>>>>>>
>>>>>>
>>>>>
>>>>> David Avendasora
>>>>> Senior Software Engineer
>>>>> K12, Inc.
>>>>>
>>>>> *****
>>>>> WebObjects Documentation Wiki :
>>>>> http://wiki.objectstyle.org/confluence/display/WO/
>>>>> *****
>>>>> WebObjects API:
>>>>> http://developer.apple.com/legacy/mac/library/documentation/MacOSXServer/Reference/WO54_Reference/index.html
>>>>> *****
>>>>>
>>>>
>>>
>>> --
>>> 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]