Support for autonomous transactions [CORE1409]

[firebird-automations]

Submitted by: Igor Lobov (ivl)

Is related to QA302

Votes: 1

To add support of autonomous transactions.

[firebird-automations]

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Commented by: Roman Rokytskyy (rrokytskyy)

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.

[firebird-automations]

Commented by: @asfernandes

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.

[firebird-automations]

Commented by: @asfernandes

Syntax:

IN AUTONOMOUS TRANSACTION DO <statement>

Example:

IN AUTONOMOUS TRANSACTION DO
BEGIN
INSERT INTO T VALUES (CURRENT_TIMESTAMP);
END

[firebird-automations]

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5 Alpha 1 [ 10224 ]

[firebird-automations]

Modified by: @pcisar

Workflow: jira [ 12780 ] => Firebird [ 14876 ]

[firebird-automations]

Commented by: Jonas Jasas (jon)

This feature would be great, and useful! Hope it will be implemented one day.

[firebird-automations]

Commented by: @dyemanov

The ticket is resolved as you could see, so it is already implemented :-)

[firebird-automations]

Commented by: Alexander Tyutik (tut)

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...

[firebird-automations]

Commented by: @asfernandes

In the moment, no.

The new transaction starts with the same isolation level of the existing one.

[firebird-automations]

Modified by: @asfernandes

Wiki Page: http://wiki.firebirdsql.org/wiki/index.php?page=IN+AUTONOMOUS+TRANSACTION

[firebird-automations]

Commented by: Sascha Michel (datiscum1)

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 ?

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA302 [ QA302 ]

[firebird-automations]

Modified by: @pmakowski

status: Resolved [ 5 ] => Closed [ 6 ]