On 10/09/08 10:58 AM, "Ondřej Čada" <[EMAIL PROTECTED]> 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      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to