• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Learning Vertical Inheritance
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Learning Vertical Inheritance

  • Subject: Learning Vertical Inheritance
  • From: Kevin Xiaowen REN <email@hidden>
  • Date: Mon, 21 Dec 2009 00:56:17 -0800 (PST)

Hi, All

I know this is old topic, but I found something this time when try to play this "vertical inheritance" with Apple/example/SophisticatedDatabaseExample

Copied from README:
The SophisticatedDatabaseExample demonstrates the use of inheritance, flattening, and multiple models.
 The Person class is abstract. Student, Parent and Employee inherit from Person using horizontal inheritance.
 The Admin,Staff, Teacher classes all inherit from Employee using single-table inheritance.
 The HomeAddress, WorkAddress, and BillingAddress inherit from Address using vertical inheritance.

I turn on the log, because the application is working randomly. Attached is working and not working part log file.

When it's working, EOF generated the  the right sequence table name for insert sql like address, home_addres then student.

When it's not working, EOF generated sql is wrong sequence , try to insert STUDENT first and broken, because no address and home_address in database.

I found there was a bug fixed report in WO5.4.1, No 5405227 , "Vertical inheritance does not generate the right sequence table name",

I am using WO 5.4.3, but not WOnder. Not sure this is the new bug, or not fixed totally,

Is any workaround solution? Or fix in WO , Wonder later?

Is it an "INITIALLY DEFERRED DEFERRABLE" constraints issue in MySQL?but it's working sometimes.



Thanks

<<saveChanges.txt>>


kevin

Reading this email at work? Make a change with Yahoo!Xtra Jobs
==saveChanges =====insertedObjects: ( {values = {zip = "6001"; state = "WG"; street = "4 Hunter street"; addressType = 1; emailAddress = "email@hidden"; city = "Wellington"; phone = <com.webobjects.foundation.NSKeyValueCoding$Null>; }; this = "<school.eo.HomeAddress fdb00d <EOTemporaryGlobalID: 0 0 127 0 0 1 0 0 11 -71 4 0 0 0 1 37 -98 82 56 -62 90 -18 -42 -124>>"; },
{values = {lastName = "Lee"; status = <com.webobjects.foundation.NSKeyValueCoding$Null>; address = "<school.eo.HomeAddress fdb00d <EOTemporaryGlobalID: 0 0 127 0 0 1 0 0 11 -71 4 0 0 0 1 37 -98 82 56 -62 90 -18 -42 -124>>"; scheduledClasses = (  ); firstName = "james"; login = "james"; dateOfBirth = 2000-12-31 11:00:00 Etc/GMT; password = "james"; parents = (  ); age = <com.webobjects.foundation.NSKeyValueCoding$Null>; }; this = "<school.eo.Student 3cc262 <EOTemporaryGlobalID: 0 0 127 0 0 1 0 0 11 -71 3 0 0 0 1 37 -98 82 56 -62 90 -18 -42 -124>>"; } )
==saveChanges =====updateObjects: (  )
==saveChanges =====deleteObjects: (  )
[2009-12-18 9:31:25 NZDT] <WorkerThread12>  === Begin Internal Transaction
[2009-12-18 9:31:25 NZDT] <WorkerThread12> Searching for primary key value for ADDRESS
[2009-12-18 9:31:25 NZDT] <WorkerThread12>  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT PK FROM EO_PK_TABLE WHERE NAME = 'ADDRESS' FOR UPDATE" withBindings: >
[2009-12-18 9:31:25 NZDT] <WorkerThread12> fetch canceled
[2009-12-18 9:31:25 NZDT] <WorkerThread12> 1 row(s) processed
[2009-12-18 9:31:25 NZDT] <WorkerThread12> Updating primary key value for ADDRESS in PK table named: EO_PK_TABLE to seed value: 29
[2009-12-18 9:31:25 NZDT] <WorkerThread12>  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE EO_PK_TABLE SET PK = 29 WHERE NAME = 'ADDRESS' AND PK = 28" withBindings: >
[2009-12-18 9:31:25 NZDT] <WorkerThread12>  === Commit Internal Transaction
[2009-12-18 9:31:25 NZDT] <WorkerThread12>  === Begin Internal Transaction
[2009-12-18 9:31:25 NZDT] <WorkerThread12> Searching for primary key value for Person
[2009-12-18 9:31:25 NZDT] <WorkerThread12>  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT PK FROM EO_PK_TABLE WHERE NAME = 'Person' FOR UPDATE" withBindings: >
[2009-12-18 9:31:25 NZDT] <WorkerThread12> fetch canceled
[2009-12-18 9:31:25 NZDT] <WorkerThread12> 1 row(s) processed
[2009-12-18 9:31:25 NZDT] <WorkerThread12> Updating primary key value for Person in PK table named: EO_PK_TABLE to seed value: 94
[2009-12-18 9:31:25 NZDT] <WorkerThread12>  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE EO_PK_TABLE SET PK = 94 WHERE NAME = 'Person' AND PK = 93" withBindings: >
[2009-12-18 9:31:25 NZDT] <WorkerThread12>  === Commit Internal Transaction
[2009-12-18 9:31:25 NZDT] <WorkerThread12>  === Begin Internal Transaction
[2009-12-18 9:31:25 NZDT] <WorkerThread12>  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "INSERT INTO ADDRESS(ADDRESS_ID, STATE, STREET, ADDRESS_TYPE, CITY, PHONE, ZIP) VALUES (?, ?, ?, ?, ?, NULL, ?)" withBindings: 1:29(NeededByEOF0), 2:"WG"(state), 3:"4 Hunter street"(street), 4:1(addressType), 5:"Wellington"(city), 6:"6001"(zip)>
[2009-12-18 9:31:25 NZDT] <WorkerThread12>  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "INSERT INTO HOME_ADDRESS(EMAIL_ADDRESS, ADDRESS_ID) VALUES (?, ?)" withBindings: 1:"email@hidden"(emailAddress), 2:29(addressID)>
[2009-12-18 9:31:25 NZDT] <WorkerThread12>  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "INSERT INTO STUDENT(PERSON_ID, LAST_NAME, STATUS, ADDRESS_ID, PASSWORD, LOGIN, DATE_OF_BIRTH, FIRST_NAME, AGE) VALUES (?, ?, NULL, ?, ?, ?, ?, ?, NULL)" withBindings: 1:94(personID), 2:"Lee"(lastName), 3:29(addressID), 4:"james"(password), 5:"james"(login), 6:2001-01-01 00:00:00(dateOfBirth), 7:"james"(firstName)>
[2009-12-18 9:31:25 NZDT] <WorkerThread12>  === Commit Internal Transaction


Next is the not working log:

==saveChanges =====insertedObjects: ( {values = {lastName = "ren"; status = <com.webobjects.foundation.NSKeyValueCoding$Null>; address = "<school.eo.HomeAddress 1976011 <EOTemporaryGlobalID: 0 0 127 0 0 1 0 0 11 -71 2 0 0 0 1 37 -98 111 109 113 4 -104 -10 85>>"; scheduledClasses = (  ); firstName = "xiao"; login = "xiao"; dateOfBirth = 1973-03-05 12:00:00 Etc/GMT; password = "xiao"; parents = (  ); age = <com.webobjects.foundation.NSKeyValueCoding$Null>; }; this = "<school.eo.Student 1bb5c09 <EOTemporaryGlobalID: 0 0 127 0 0 1 0 0 11 -71 1 0 0 0 1 37 -98 111 109 113 4 -104 -10 85>>"; },
{values = {zip = "5555"; state = "WG"; street = "2  Hunter street"; addressType = 1; emailAddress = "email@hidden"; city = "wellington"; phone = <com.webobjects.foundation.NSKeyValueCoding$Null>; }; this = "<school.eo.HomeAddress 1976011 <EOTemporaryGlobalID: 0 0 127 0 0 1 0 0 11 -71 2 0 0 0 1 37 -98 111 109 113 4 -104 -10 85>>"; } )
==saveChanges =====updateObjects: (  )
==saveChanges =====deleteObjects: (  )
[2009-12-18 9:59:21 NZDT] <WorkerThread13>  === Begin Internal Transaction
[2009-12-18 9:59:21 NZDT] <WorkerThread13> Searching for primary key value for ADDRESS
[2009-12-18 9:59:21 NZDT] <WorkerThread13>  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT PK FROM EO_PK_TABLE WHERE NAME = 'ADDRESS' FOR UPDATE" withBindings: >
[2009-12-18 9:59:21 NZDT] <WorkerThread13> fetch canceled
[2009-12-18 9:59:21 NZDT] <WorkerThread13> 1 row(s) processed
[2009-12-18 9:59:21 NZDT] <WorkerThread13> Updating primary key value for ADDRESS in PK table named: EO_PK_TABLE to seed value: 33
[2009-12-18 9:59:21 NZDT] <WorkerThread13>  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE EO_PK_TABLE SET PK = 33 WHERE NAME = 'ADDRESS' AND PK = 32" withBindings: >
[2009-12-18 9:59:21 NZDT] <WorkerThread13>  === Commit Internal Transaction
[2009-12-18 9:59:21 NZDT] <WorkerThread13>  === Begin Internal Transaction
[2009-12-18 9:59:21 NZDT] <WorkerThread13> Searching for primary key value for Person
[2009-12-18 9:59:21 NZDT] <WorkerThread13>  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT PK FROM EO_PK_TABLE WHERE NAME = 'Person' FOR UPDATE" withBindings: >
[2009-12-18 9:59:21 NZDT] <WorkerThread13> fetch canceled
[2009-12-18 9:59:21 NZDT] <WorkerThread13> 1 row(s) processed
[2009-12-18 9:59:21 NZDT] <WorkerThread13> Updating primary key value for Person in PK table named: EO_PK_TABLE to seed value: 98
[2009-12-18 9:59:21 NZDT] <WorkerThread13>  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE EO_PK_TABLE SET PK = 98 WHERE NAME = 'Person' AND PK = 97" withBindings: >
[2009-12-18 9:59:21 NZDT] <WorkerThread13>  === Commit Internal Transaction
[2009-12-18 9:59:21 NZDT] <WorkerThread13>  === Begin Internal Transaction
[2009-12-18 9:59:21 NZDT] <WorkerThread13>  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "INSERT INTO STUDENT(PERSON_ID, LAST_NAME, STATUS, ADDRESS_ID, PASSWORD, LOGIN, DATE_OF_BIRTH, FIRST_NAME, AGE) VALUES (?, ?, NULL, ?, ?, ?, ?, ?, NULL)" withBindings: 1:98(personID), 2:"ren"(lastName), 3:33(addressID), 4:"xiao"(password), 5:"xiao"(login), 6:1973-03-06 00:00:00(dateOfBirth), 7:"xiao"(firstName)>
[2009-12-18 9:59:21 NZDT] <WorkerThread13>  === Rollback Internal Transaction
[2009-12-18 9:59:21 NZDT] <WorkerThread13> <com.webobjects.appserver._private.WOComponentRequestHandler>: Exception occurred while handling request:
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "INSERT INTO STUDENT(PERSON_ID, LAST_NAME, STATUS, ADDRESS_ID, PASSWORD, LOGIN, DATE_OF_BIRTH, FIRST_NAME, AGE) VALUES (?, ?, NULL, ?, ?, ?, ?, ?, NULL)" withBindings: 1:98(personID), 2:"ren"(lastName), 3:33(addressID), 4:"xiao"(password), 5:"xiao"(login), 6:1973-03-06 00:00:00(dateOfBirth), 7:"xiao"(firstName)>:
    Next exception:SQL State:23000 -- error code: 1452 -- msg: Cannot add or update a child row: a foreign key constraint fails (`school`.`STUDENT`, CONSTRAINT `STUDENT_ibfk_1` FOREIGN KEY (`ADDRESS_ID`) REFERENCES `ADDRESS` (`ADDRESS_ID`))



 _______________________________________________
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
  • Follow-Ups:
    • Re: Learning Vertical Inheritance
      • From: David Avendasora <email@hidden>
  • Prev by Date: Converting EOModel to Core Data model
  • Next by Date: Re: Learning Vertical Inheritance
  • Previous by thread: Converting EOModel to Core Data model
  • Next by thread: Re: Learning Vertical Inheritance
  • Index(es):
    • Date
    • Thread