• 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: Chuck Hill <email@hidden>
  • Date: Wed, 10 Sep 2008 12:03:09 -0700


On Sep 10, 2008, at 10:14 AM, Guido Neitzer wrote:

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.

That is the only thing that comes to mind for me.


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 ...

I don't think that would work. You would be missing a lot of things.


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.


It seems odd that a manually inserted row would have a PK like that.

Chuck


-- Chuck Hill Senior Consultant / VP Development

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects







_______________________________________________ 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: Guido Neitzer <email@hidden>
References: 
 >Re: PK generation?!? (From: Guido Neitzer <email@hidden>)

  • Prev by Date: Re: Slightly OT: Command line Java tool with EOF?
  • Next by Date: Re: PK generation?!?
  • Previous by thread: Re: crossed sessions (was: PK generation?!?)
  • Next by thread: Re: PK generation?!?
  • Index(es):
    • Date
    • Thread