Base solution for your next web application
Open Closed

Transaction rollback issue oracle Devart #7069


User avatar
0
velu created

Hi,

We are using .netCore and angular 6 Combined solution.

We have connected to oracle database using Devart Drivers, UnitOfWork.IsTransactional = false , Not supported yet.

in this case SaveChangesAsync records are not rolled back.

How can we rollback after unit of work is failed.

Thanks


3 Answer(s)
  • User Avatar
    0
    maliming created
    Support Team

    I remember that there is no transaction and can't roll back the operation. This is also a rule of the database

    Does Devart Drivers not support transactions?

  • User Avatar
    1
    velu created

    Hi,

    We have diagnosed and resolved this issue.

    The actual problem is that the default behavior of Unitofwork is Readuncommited.

    This isolation level is not supported by Oracle (Devart Drivers)* .

    Instead of UOW.IsTransactional = false we have changed the isolation level of UOW to ReadCommitted.

    This is supported by oracle and working as expected.

    Thanks

  • User Avatar
    0
    ismcagdas created
    Support Team

    Thanks @velu