Re: PK generation?!?
Re: PK generation?!?
- Subject: Re: PK generation?!?
- From: Ondra Cada <email@hidden>
- Date: Wed, 10 Sep 2008 19:35:41 +0200
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).
Thanks and best,
---
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:
This email sent to email@hidden