Hi Ondra
I once had a similar problem using automatic PK generation with
OpenBase - and discovered that the table in question only had a
'normal' index set on the primary key field rather than a 'unique'
index. I don't know if Frontbase creates indexes in the same way,
but if so it is definitely worth checking.
Liz
On 10 Sep 2008, at 16:06, Ondřej Čada wrote:
Hello all,
someone who understands how exactly does EOF generate PK's with
FrontBase and the default setup (PK's generated automatically) --
any idea whether (and if so, why) a duplicated PK can be generated?
A client just have reported to me this error:
Database Error: com.webobjects.eoaccess.EOGeneralAdaptorException:
EvaluateExpression failed:
<com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression:
"INSERT INTO "ORDERITEM"("RUBBER", "PRICE", "FROM", "ORDER_ID",
"C_CREATION_DATE", "DATE", "OID", "EXPRESS", "PAD",
"DISAPPROVED_SINCE", "PADCOLOR", "COMPLETE", "C_SAMPLEGROUP_CHECK",
"SAMPLE_ID") VALUES (NULL, NULL, NULL, 1019876, TIMESTAMP
'2008-09-10 16:13:27.561', TIMESTAMP '2008-09-10 16:13:27.561',
1042378, false, NULL, NULL, '?erná', 100, NULL, 1046134)">:
Next exception:SQL State:23 -- error code: 358 -- msg:
Exception condition 358. Integrity constraint violation (PRIMARY
KEY, ORDERITEM._C0000000015(OID=1042378)).
Thanks,
---
Ondra Čada
OCSoftware: [EMAIL PROTECTED] http://www.ocs.cz
private [EMAIL PROTECTED] http://www.ocs.cz/oc
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/liz%
40plsys.co.uk
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]