Re: PK generation?!?
Re: PK generation?!?
- Subject: Re: PK generation?!?
- From: Elizabeth Lynch <email@hidden>
- Date: Wed, 10 Sep 2008 16:28:48 +0100
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@hidden http://www.ocs.cz
private email@hidden http://www.ocs.cz/oc
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40plsys.co.uk
This email sent to email@hidden
_______________________________________________
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