Please help my understand what will happen in the following cases involving
transactions. System: Delphi XE2, Firebird 2,5x, Using DBX components.
Isolation level: ReadCommitted.
The actual statements are much more complex and involves various statements in
the transaction and/or triggers
Greetings,
I’m sure this has been asked before - is there a knowledge base somewhere?
I’m trying to get a handle on transactions from gstat and I just want to make
sure I’m reading this correctly. One of my installs is having some issues,
Firebird 1.56, Classic Server. I have been reading Hel
>Please help my understand what will happen in the following cases involving
>transactions.
>System: Delphi XE2, Firebird 2,5x, Using DBX components. Isolation level:
>ReadCommitted.
>
>The actual statements are much more complex and involves various statements in
>the transaction and/or trigge
BTW, I took the code out, and made a simple query.. I stripped it down
to nothing, and gives me an error of..
"No current record for fetch operation"
Im lost as to why this simple query wont work..
Select P.product,SI.Rec_ID
FROM stores S,Products P
LEFT JOIN Stores_Inventory SI ON (S.Rec
At 07:36 a.m. 13/04/2014, Gordon Hamm wrote:
>BTW, I took the code out, and made a simple query.. I stripped it down to
>nothing, and gives me an error of..
>"No current record for fetch operation"
>
>Im lost as to why this simple query wont work..
>
>
>Select P.product,SI.Rec_ID
>FROM stores S
On 2014-04-12 18:56, Helen Borrie wrote:
> At a minimum you need
>
> Select P.product,SI.Rec_ID
> FROM stores S,Products P
> LEFT JOIN Stores_Inventory SI ON (S.Rec_ID = P.something)
>
> and if you want the join value to be limited to Rec_ID =12 then
> provide the WHERE clause:
>
> WHERE S.Rec_I
Kevin,
You might want to read this...
https://www.ibphoenix.com/resources/documents/search/doc_67
Regards
Paul
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-supp...@yahoogroups..com]
Sent: 03 April 2019 06:37
To: Firebird Support
Subject: [firebird-support
I have a table with before and after insert triggers. I also have a
stored procedure that loops, inserting rows in to the table. The last
statement in the loop is WHEN ANY to catch and log errors to an external
table and continue looping.
If an insert trigger throws an exception, will the insert
At 04:49 AM 10/08/2012, Rick Debay wrote:
>I have a table with before and after insert triggers. I also have a
>stored procedure that loops, inserting rows in to the table. The last
>statement in the loop is WHEN ANY to catch and log errors to an external
>table and continue looping.
>
>If an ins
pport@yahoogroups.com] On Behalf Of Helen Borrie
Sent: Friday, August 10, 2012 12:35 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Transactions & exception trapping
At 04:49 AM 10/08/2012, Rick Debay wrote:
>I have a table with before and after insert triggers. I also hav
At 05:00 AM 11/08/2012, Rick Debay wrote:
>FOR ... BEGIN
> INSERT_PROCEDURE RETURNING VALUE
> UPDATE TABLE WITH VALUE
> WHEN ... BEGIN
>LOG
> END
>END
>
>If the insert procedure directly or indirectly causes an exception the
>insert will be abandoned, the update will be skipped, and all dat
ird-support@yahoogroups.com
Subject: RE: [firebird-support] Transactions & exception trapping
At 05:00 AM 11/08/2012, Rick Debay wrote:
>FOR ... BEGIN
> INSERT_PROCEDURE RETURNING VALUE
> UPDATE TABLE WITH VALUE
> WHEN ... BEGIN
>LOG
> END
>END
>
>If the inser
Hi All,
I have a table: CREATE TABLE TBL_TRA_TEST(ID BIGINT);
and want to write to it and read from it concurrently.
For this task I use two transactions (read_committed, no_rec_version,
wait), one with "write" parameter and one with "read".
After started the "write" transaction execute: INSERT I
When closing a read-only transaction for a read operation - does it
matter if COMMIT vs ROLLBACK is used?
--
Daniel
23.08.2016 17:22, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote:
> For me this is looks like a bug.
You have chosen "no_rec_version", so you are getting what you asked for.
--
WBR, SD.
++
2016. 08. 23. 17:34 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] írta:
> 23.08.2016 17:22, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote:
>> For me this is looks like a bug.
>
>You have chosen "no_rec_version", so you are getting what you asked for.
If the
Hello,
I'm trying to understand interactions between transactions with
different isolation levels.
My environment is Firebird Super Server 2.5 (v. 2.5.2) on Linux
Ubuntu 14.04
I'm testing by opening two consoles and running isql-fb on both consoles.
On the first one I start a SNAPSHO
Hello,
i have remarked a strange thing, if you do only one transaction by connection
these counters are not updated , it is normal ?
i have done the test with dotnet provider and node-firebird (they uses the xdr
remote protocol).
it is very easy to reproduce :
1) Open Connection
> On Feb 28, 2017, at 3:07 PM, Aldo Caruso wrote:
>
> I'm trying to understand interactions between transactions with
> different isolation levels.
The problem is not mixed isolation levels. You would get the same behavior if
all transactions were Snapshot
The scenario (described below in d
Ann,
Thanks for your detailed answer.
I agree with you: the only isolation level which each transaction
takes care of is its own isolation level. So this behavior happens
because A isolation level is snapshot ( regardless of the isolation
level of B or C ).
Also I suspected your las
> On Mar 1, 2017, at 9:53 AM, Aldo Caruso wrote:
>
>
>
> Ann,
>
> Thanks for your detailed answer.
>
> But this leads me to the following question: If snapshot transactions
> have their own copy of the Transaction Inventory Pages ( TIP ), taken when
> the transaction started, transact
Ann,
thank you very much for your answer.
Aldo
El 01/03/17 a las 11:44, Ann Harrison aharri...@ibphoenix.com
[firebird-support] escribió:
On Mar 1, 2017, at 9:53 AM, Aldo Caruso wrote:
Ann,
Thanks for your detailed answer.
But this leads me to the following question: If snapsh
Hello,
I have the following situation. A table is used to store values that are
generated quite frequently. A second process will read the values and do
something with them. After that processing the read values are no longer needed
and they can (should!) be deleted from the database. However,
On Tue, Oct 25, 2011 at 11:24 AM, fernnaj wrote:
>
>
> The question is: if I have a select in one transaction that is suffering
> from the cleaning up after a deletion of say 1 million rows (and it's taking
> forever to return results), will another transaction that just writes a new
> row in the
> I have the following situation. A table is used to store values that are
> generated quite frequently. A second process will read the values and do
> something with them. After that processing the read values are no longer
> needed and they can (should!) be deleted from the database. However,
26 matches
Mail list logo
