Page 1 of 1
UniDac and AutoCommit (Oracle)
Posted: Wed 03 Mar 2010 13:43
by roznicki
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 ...
Posted: Fri 05 Mar 2010 09:21
by Challenger
UniDAC has no such feature by design. If you do not starta transaction manually all statements will be commited on execute.
Posted: Mon 08 Mar 2010 09:25
by roznicki
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
Posted: Tue 09 Mar 2010 09:41
by roznicki
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...
Posted: Wed 10 Mar 2010 11:08
by Challenger
Thank you for the suggestion. We will consider this functionality and perhaps add it in one of the next builds.