Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Re: EOF Inheritance problems help needed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: EOF Inheritance problems help needed

Subject: Re: EOF Inheritance problems help needed
From: Lachlan Deck <email@hidden>
Date: Fri, 18 May 2007 19:31:34 +1000

Okay, I've made some progress, simplified the model, but there's one final problem that's a bit baffling: - the foreign key ('clientId') is not being given a value in the sql.

So I have an abstract parent called Taggable with various kids.

Taggable (Abstract, vertical inheritance)
	id
	created
	modified
	clientId (foreignKey) with relationship 'client'

One of the subentities 'Course' has additional fields - but when saving the record the clientId is not being passed in the sql statement.

Any ideas why?

with regards,
--

Lachlan Deck
email@hidden

2007-05-18 19:11:02,070 [WorkerThread2 ] DEBUG com.ish.willow.soap.webservices.controllers.SOAPController - >>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2007-05-18 19:11:02,071 [WorkerThread2 ] DEBUG com.ish.willow.soap.webservices.controllers.SOAPController - Label:Snapshot for Child Editing Context 2007-05-18 19:11:02,071 [WorkerThread2 ] DEBUG com.ish.willow.soap.webservices.controllers.SOAPController - ----------------------------- 2007-05-18 19:11:02,071 [WorkerThread2 ] DEBUG com.ish.willow.soap.webservices.controllers.SOAPController - Inserted objects: 2007-05-18 19:11:02,078 [WorkerThread2 ] DEBUG com.ish.willow.soap.webservices.controllers.SOAPController - snapshot:{<....>; created = 2007-02-27 05:16:28 Etc/GMT; modified = 2007-05-18 02:35:45 Etc/GMT; isWebVisible = false; code = "BAPB"; isDeleted = false; name = "Test"; detail = "<...>"; client = <java.lang.Class(1c4ff2c) Fault _EOIntegralKeyGlobalID[Client (java.lang.Long)1]>; entityType = "Course"; } 2007-05-18 19:11:02,080 [WorkerThread2 ] DEBUG com.ish.willow.soap.webservices.controllers.SOAPController - Updated objects: 2007-05-18 19:11:02,080 [WorkerThread2 ] DEBUG com.ish.willow.soap.webservices.controllers.SOAPController - <<<<<<<<<<<<<<<<<<<<<<<<<<<<< 2007-05-18 19:11:02,152 [WorkerThread2 ] DEBUG com.ish.willow.soap.webservices.controllers.SOAPController - >>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2007-05-18 19:11:02,152 [WorkerThread2 ] DEBUG com.ish.willow.soap.webservices.controllers.SOAPController - Label:Snapshot for Parent Editing Context 2007-05-18 19:11:02,152 [WorkerThread2 ] DEBUG com.ish.willow.soap.webservices.controllers.SOAPController - ----------------------------- 2007-05-18 19:11:02,153 [WorkerThread2 ] DEBUG com.ish.willow.soap.webservices.controllers.SOAPController - Inserted objects: 2007-05-18 19:11:02,153 [WorkerThread2 ] DEBUG com.ish.willow.soap.webservices.controllers.SOAPController - Updated objects: 2007-05-18 19:11:02,153 [WorkerThread2 ] DEBUG com.ish.willow.soap.webservices.controllers.SOAPController - <<<<<<<<<<<<<<<<<<<<<<<<<<<<< [2007-05-18 19:11:01 EST] <WorkerThread2> === Begin Internal Transaction [2007-05-18 19:11:01 EST] <WorkerThread2> finding primary key value for Taggable [2007-05-18 19:11:01 EST] <WorkerThread2> evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT PK FROM EO_PK_TABLE WHERE NAME = 'Taggable' FOR UPDATE"> [2007-05-18 19:11:01 EST] <WorkerThread2> 0 row(s) processed [2007-05-18 19:11:01 EST] <WorkerThread2> setting initial primary key value for Taggable [2007-05-18 19:11:01 EST] <WorkerThread2> evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "INSERT INTO EO_PK_TABLE(NAME, PK) VALUES ( 'Taggable', 0 )"> [2007-05-18 19:11:01 EST] <WorkerThread2> finding maximum primary key value for Taggable [2007-05-18 19:11:01 EST] <WorkerThread2> evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT MAX (id) FROM Course"> [2007-05-18 19:11:01 EST] <WorkerThread2> fetch canceled [2007-05-18 19:11:01 EST] <WorkerThread2> 1 row(s) processed <....> [2007-05-18 19:11:01 EST] <WorkerThread2> updating primary key value for Taggable [2007-05-18 19:11:01 EST] <WorkerThread2> evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE EO_PK_TABLE SET PK = 1 WHERE NAME = 'Taggable' AND PK = 0"> [2007-05-18 19:11:01 EST] <WorkerThread2> === Commit Internal Transaction [2007-05-18 19:11:01 EST] <WorkerThread2> === Begin Internal Transaction [2007-05-18 19:11:01 EST] <WorkerThread2> evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "INSERT INTO Course(name, detail, isWebVisible, detail_textile, id, code) VALUES (<....>)" withBindings: <......> [2007-05-18 19:11:01 EST] <WorkerThread2> evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "INSERT INTO Taggable(id, created, modified, angelId, entityType, isDeleted) VALUES (?, ?, ?, ?, ?, ?)" withBindings: 1:1(NeededByEOF0), 2:2007-05-18 19:11:02(created), 3:2007-05-18 19:11:02(modified), 4:215 (angelId), 5:"Course"(entityType), 6:false(isDeleted)> [2007-05-18 19:11:01 EST] <WorkerThread2> === Rollback Internal Transaction

Why would it not be passing clientId also in the sql?

with regards,
--

Lachlan Deck

_______________________________________________
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: EOF Inheritance problems help needed
From: Chuck Hill <email@hidden>


References:  
  >EOF Inheritance problems help (From: Lachlan Deck <email@hidden>)




Prev by Date:
RE: Microsoft SQL support

Next by Date:
Re: EOF Inheritance problems help

Previous by thread:
EOF Inheritance problems help

Next by thread:
Re: EOF Inheritance problems help needed

Index(es):

Date
Thread