|
[
Permalink
| « Hide
]
Roman Rokytskyy added a comment - 08/Aug/07 01:00 PM
Please provide exact description of what the autonomous transactions are. We had already the case where autonomous transactions where just another name to savepoints, which are fully supported by Firebird.
Autonomous transaction is when a procedure or trigger run in another (self open and close) transaction.
This is very desired feature to use with database triggers. Syntax:
IN AUTONOMOUS TRANSACTION DO <statement> Example: IN AUTONOMOUS TRANSACTION DO BEGIN INSERT INTO T VALUES (CURRENT_TIMESTAMP); END This feature would be great, and useful! Hope it will be implemented one day.
The ticket is resolved as you could see, so it is already implemented :-)
Is it possible to set transaction parameters for autonomous transactions?
Few years ago i used similar feature in MS SQL server an remember that we used such possiblility for some tasks... In the moment, no.
The new transaction starts with the same isolation level of the existing one. OK to set Transaction parameters makes sense !
I have the following problem: Using an ReadOnly Transaction for long outstanding commit and a Write transaction for the Datachange. Now it can be possible that in an Trigger or used SP that is joined with the select statemant an write must be done for insert a initiale row. When we can say IN AUTONOMOUS WRITE TRANSACTION It would be very useful for this concept of long read and short write transactions. We using FIBplus and here it can greatly help. Or is that conncept og long outstanding ReadOnly transactions obsolete ? |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
 |
|
New Feature
Closed
Major
Support for autonomous transactions
