My guess is that you are doing the insert twice in the same
transaction. The transaction is then rolled back and consequently you
can manually insert the same values with no violation of the
uniqueness constraint. Turn on EOAdaptorDebugEnabled and
watch the SQL that's generated to get a better idea of what's going on.
Alan
On May 30, 2008, at 10:38 AM, Amedeo Mantica wrote:
I got this error:
[2008-5-30 18:31:43 CEST] <WorkerThread0>
com.webobjects.eoaccess.EOGeneralAdaptorException:
EvaluateExpression failed:
<com.webobjects.jdbcadaptor.OpenBasePlugIn$OpenBaseExpression:
"INSERT INTO INDBLocalizedString(it, de, id, en) VALUES
(?, ?, ?, ?)" withBindings: 1:"write ITghgf"(it), 2:"write DE"(de),
3:128(id), 4:"write EN"(en)>:
Next exception:SQL State:42000 -- error code: 0 -- msg: ERROR -
Value for column 'id' is not unique.
SQL: INSERT INTO INDBLocalizedString(it, de, id, en) VALUES ('write
ITghgf', 'write DE', 128, 'write EN')
I checked and rechecked, the value for column ID is UNIQUE!!!
also typing the SQL directly into database works!
Any suggestion?!!
Thanks
Amedeo
_______________________________________________
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/award%
40apple.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/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
