On 22/05/2007, at 11:52 AM, Lachlan Deck wrote:
On 22/05/2007, at 11:28 AM, Lachlan Deck wrote:
[2007-05-22 11:26:02 EST] <WorkerThread12> === Begin Internal
Transaction
[2007-05-22 11:26:02 EST] <WorkerThread12> finding primary key
value for Person
[2007-05-22 11:26:02 EST] <WorkerThread12> evaluateExpression:
<com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT
PK FROM EO_PK_TABLE WHERE NAME = 'Person' FOR UPDATE">
[2007-05-22 11:26:02 EST] <WorkerThread12> fetch canceled
[2007-05-22 11:26:02 EST] <WorkerThread12> 1 row(s) processed
[2007-05-22 11:26:02 EST] <WorkerThread12> updating primary key
value for Person
[2007-05-22 11:26:02 EST] <WorkerThread12> evaluateExpression:
<com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE
EO_PK_TABLE SET PK = 14 WHERE NAME = 'Person' AND PK = 13">
[2007-05-22 11:26:02 EST] <WorkerThread12> === Commit Internal
Transaction
[2007-05-22 11:26:02 EST] <WorkerThread12> === Begin Internal
Transaction
[2007-05-22 11:26:02 EST] <WorkerThread12> evaluateExpression:
<com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "INSERT
INTO Person(id, lastName, code, created, modified, firstName,
entityType) VALUES (?, ?, ?, ?, ?, ?, ?)" withBindings: 1:14
(NeededByEOF0), 2:"SaveMe"(lastName), 3:2(code), 4:2007-05-22
00:00:00(created), 5:2007-05-22 00:00:00(modified),
6:"Please"(firstName), 7:"Employee"(entityType)>
[2007-05-22 11:26:02 EST] <WorkerThread12> === Rollback Internal
Transaction
The message on screen says:
Could not save your changes:
Object value '2' for column 3 is not an instanceof String
Hmm, so when I enter the string '7777' it's trying to insert '2'...
why? That's sounds like it's trying to set the foreign key to
company on the wrong binding.
In fact, this means it's not even including the foreign key
'companyId' in the SQL generation and so it's getting tripped up
somewhere and outputting the foreign key against the wrong column.
Does anyone know what's going on here?
with regards,
--
Lachlan Deck
_______________________________________________
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]
