Transaction support

[javiercornejo]

Hi there.
First I want to thank you for this project.
I read in the documentation that offshore-sql does not have Transaction support yet bu I saw in the code some reference to commit / rollback functions. So my questions is: Do you know some way to use transaction with oracledb with this version of the project?
Thank you in advance.
Regards.

[atiertant]

@javiercornejo you 're right, you can use transaction with offshore, see https://github.com/Atlantis-Software/offshore-docs/blob/master/transaction/transactions.md

[javiercornejo]

Hi @atiertant thank you for your response!! I figured out few days earlier than your response. It works very good and thank you for implementing it.

I noticed that when I create / query some instance and then I access to some standard Class Method like .save() or .remove() is not executed in the transaction that created / retrieve the instance in first place. Do you think this is possible to implement?

Regards and thanks again!

[atiertant]

for sure, there are maybe some missing _loadQuery in this functions.