Skip to main content

Hi Everyone,

Been a while since my last interaction here and have been up to my armpits in it all.

Have a question about transaction processing/commits/boundaries etc and the compatibility with file triggers. Can the two co-exist? I have a feeling the answer will be no but thought i should ask. We're on UV11.3.4. Any info would be great thanks.

Regards,

Peter

Hi Everyone,

Been a while since my last interaction here and have been up to my armpits in it all.

Have a question about transaction processing/commits/boundaries etc and the compatibility with file triggers. Can the two co-exist? I have a feeling the answer will be no but thought i should ask. We're on UV11.3.4. Any info would be great thanks.

Regards,

Peter

Hi Peter,

I don't have a lot of specific experience in this area but I don't see a general reason why you would not be able to use transaction processing and file triggers. The trigger itself will execute as a transaction. UniVerse supports nested transactions. So if updating a file with a trigger inside a transaction, the trigger transaction would be a nested transaction of the BASIC transaction and would be committed when the top level BASIC transaction was committed. I can probably put a test together to confirm this understanding.

Thanks,

Neil


Hi Everyone,

Been a while since my last interaction here and have been up to my armpits in it all.

Have a question about transaction processing/commits/boundaries etc and the compatibility with file triggers. Can the two co-exist? I have a feeling the answer will be no but thought i should ask. We're on UV11.3.4. Any info would be great thanks.

Regards,

Peter

Hello 

As Neil sais, I confirm it works. 

Pay attention to locks you acquire into the trigger it can be already acquired by the top transaction.

Then, when write/trigger is done the locks acquired within are still there until final commit / rollback. A real diffence ! 

If you need to log something before rollback.. Use openseq/writeseq which is not part of transaction. 

Manu