UniDac and AutoCommit (Oracle)

roznicki · Post by **roznicki** » Wed 03 Mar 2010 13:43

How can I choose default value for autocommit property of session in UniDac. There is no TOraSession object in Unidac. Maybe I should use SpecificOptions for connection? I don't want to start transact ...

Challenger · Post by **Challenger** » Fri 05 Mar 2010 09:21

UniDAC has no such feature by design. If you do not starta transaction manually all statements will be commited on execute.

roznicki · Post by **roznicki** » Mon 08 Mar 2010 09:25

Do you plan such a feature in future release? I don't want to modify original source only to do that. ODAC has such a feature and I think that it is not a problem to add it in Unidac

roznicki · Post by **roznicki** » Tue 09 Mar 2010 09:41

I think such a feature should be in Unidac. BDE has property SQLPASSTHRU MODE that you can set to SHARED NOAUTOCOMMIT.
And migration to Unidac can be painful if one cannot set such property for Unidac connection. I changed Unidac sources in 30 minutes (including tests) to change that behavior but I think it should be standard Unidac feature...

Challenger · Post by **Challenger** » Wed 10 Mar 2010 11:08

Thank you for the suggestion. We will consider this functionality and perhaps add it in one of the next builds.