Re: PK generation?!?
Re: PK generation?!?
- Subject: Re: PK generation?!?
- From: Chuck Hill <email@hidden>
- Date: Wed, 10 Sep 2008 12:04:54 -0700
On Sep 10, 2008, at 10:35 AM, Ondra Cada wrote:
Guido,
On 10.9.2008, at 19:14, Guido Neitzer wrote:
I remember having heard of something like that happening when
FrontBase
crashed or got bad data somehow. Which version of FB are you using?
A pretty recent one, let me see what the client has... 4.4.10.
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.
Client never reported a DB crash, but who knows... Do you happen to
know whether there is something as "consistency check tool"? Haven't
found anything like that in FBM.
A full ASCII export and import was tried about a month ago, worked
all right. Will remind them to do it again asap (I think they
regularly back-up by copying the databases in their binary form).
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.
Unless *VERY* weird things happen, this should not be possible --
the project is very old, uses FB plugin for years, and always worked
all right; but for maintenance and updates nothing was changed for a
long long time.
You can insert rows with FrontBaseManager.
Definitely, just like with sql92. Still I deem it extremely
improbable the client would....
I don't say it has to be that
situation, but it seems to be the most likely, as FrontBase is
normally
rather stable.
Yup; this very application works for them without a serious problem
for ten-odd years. Lately though strange problems kind of began to
emerge (hardly any connexion to this, but a few days ago they
reported a user had logged in -- to see _another_ user's
environment! Since nobody can repeat that, I rather think the user
happened to mistype login to bump into other's one -- most of those
jokers use three-character logins and empty passwords, and cannot be
brought to sensibility hook or crook -- but who knows.... :-O).
Is this an older version of WO? I recall hearing stories of crossed
sessions years back. I think it was a bug in the WO adaptor.
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