• 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: Guido Neitzer <email@hidden>
  • Date: Wed, 10 Sep 2008 11:14:23 -0600
  • Thread-topic: PK generation?!?

On 10/09/08 10:58 AM, "Ondřej Čada" <email@hidden> wrote:

> Me too; that's why I am that surprised seeing the duplicated PK
> problem :-O

I remember having heard of something like that happening when FrontBase
crashed or got bad data somehow. Which version of FB are you using?

We had a database here that was working fine, but you couldn't export/import
it to a different box because it had a couple rows with duplicate primary
keys. The interesting part was, that there was a unique index on the column
... must have either come from crash or a bad import or so.

> Well... if I try just to remove the plugin (I've just tried to be
> sure), I get _obtainOpenChannel error, so the client could hardly do
> that and keep the application running.

Okay, wasn't really sure about that one.

> Or is that somehow possible to run the app without the plugin
> "successfully" (in the sense it would seem to work all right, but
> would generate wrong PK's)? If so, how?

I have never tried using FrontBase with the generic JDBCPlugin. Maybe some
of the others who actually use FrontBase a bit more than I do can chime in
here ...

>> or someone is inserting data manually or at least not through
>> WebObjects.
>
> Far as I can say, they do not... well, of course I cannot be entirely
> sure, but it seems extremely improbable the client, who hardly is
> able to use FBManager to read in the database contents, would insert
> lines manually :(
>
> Anyway, thanks a big lot for the advices!

You can insert rows with FrontBaseManager. I don't say it has to be that
situation, but it seems to be the most likely, as FrontBase is normally
rather stable.

cug


 _______________________________________________
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

  • Follow-Ups:
    • Re: PK generation?!?
      • From: Chuck Hill <email@hidden>
    • Re: PK generation?!?
      • From: Ondra Cada <email@hidden>
References: 
 >Re: PK generation?!? (From: Ondřej Čada <email@hidden>)

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