Subject | Re: [ib-support] (unknown) |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2002-11-28T15:48:09Z |
Data doesn't disappear temporarily. My guess is that this has something to
do with transaction issues. What transaction isolation are you using and
what do you mean that data temporarily disappears?
Suddenly an idea burst into my mind. Are you by any chance generating
primary keys in triggers? If so, there is no way for your client to keep
track of the inserted record and it will appear to disappear. You have to
know the PK in advance, in IBO this is done by using GeneratorLinks,
whereas you have to use GEN_ID explicitly if using other connectivity tools.
HTH,
Set
At 12:16 28.11.2002 -0300, you wrote:
do with transaction issues. What transaction isolation are you using and
what do you mean that data temporarily disappears?
Suddenly an idea burst into my mind. Are you by any chance generating
primary keys in triggers? If so, there is no way for your client to keep
track of the inserted record and it will appear to disappear. You have to
know the PK in advance, in IBO this is done by using GeneratorLinks,
whereas you have to use GEN_ID explicitly if using other connectivity tools.
HTH,
Set
At 12:16 28.11.2002 -0300, you wrote:
>I have the Firebird installed in a Conectiva Linux
>8.0 and the Jakarta in another PC as web server, the
>database lost data temporarily and later they
>reappear. This occurs in interval of hours or days.
>How to resolve this problem?