maria-discuss team mailing list archive

[<ksubramanian@xxxxxxxxxxxxxxx>]

The reason for disable the auto-commit is to mimic more or less similar to oracle behaviour. Because our existing system was in oracle. Just asking out of curiosity – why we enable auto-commit by default in Maria DB. I felt that it wont give control on how we maintain the transaction. 

Can anyone provide some reasons for why we need to keep the auto-commit enabled at server level. 

Sent from Mail for Windows 10

From: Vladislav Vaintroub
Sent: 17 May 2017 18:08
To: ksubramanian@xxxxxxxxxxxxxxx; Maria Discuss
Subject: Re: [Maria-discuss] Connector Net Question



On 17.05.2017 11:26, ksubramanian@xxxxxxxxxxxxxxx wrote:
All,
 
We have set auto-commit=false at server level. 
 
But our .Net developers want to enable this auto-commit as true (default behaviour) that I hesitant to do that. Is there any connector (driver) properties that we can set at connection level for auto-commit. I know in JDBC driver, we have the properties that we can set at driver level when we establish connection to DB. But for connector/Net I am trying to find, couldn’t locate one. I noticed auto-enlist sett to true or false, not sure whether this will mimic the auto-commit functionality in a given connection. 
 
Can anyone using .Net and MariaDB combination help me to share your thought on this. 
 

Out of curiosity, what is the reason for you to use the non-default behavior (global auto-commit=false)? 

As far as I know, you cannot set arbitrary session variable automatically with C/NET, and there is no property for autocommit.  Thus this would need to be done in code, just after connecting, e.g command.executeNonQuery("set @@autocommit=1")


Regards,
Karthick
 
Sent from Mail for Windows 10
 



_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp