• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: PK generation?!?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
References: 
 >PK generation?!? (From: Ondřej Čada <email@hidden>)

  • Prev by Date: PK generation?!?
  • Next by Date: Re: PK generation?!?
  • Previous by thread: PK generation?!?
  • Next by thread: Re: PK generation?!?
  • Index(es):
    • Date
    • Thread