← Back to team overview

maria-discuss team mailing list archive

Re: Connector Net Question


Note that the auto commit was always enabled by default in MySQL. So, changing this default would probably break most existing applications.

Running a multi-statement transaction in autocommit is possible by using START TRANSACTION explicitly. Applications can do this and just don't care about autocommit value, if they want.


Mer 17/5/17,  <ksubramanian@xxxxxxxxxxxxxxx> ha scritto:

 Oggetto: Re: [Maria-discuss] Connector Net Question
 A: "Vladislav Vaintroub" <vvaintroub@xxxxxxxxx>, "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 Data: Mercoledì 17 maggio 2017, 16:36
 #yiv0052539947 --
  _filtered #yiv0052539947 {panose-1:2 4 5 3 5 4 6 3 2 4;}
  _filtered #yiv0052539947 {font-family:Calibri;panose-1:2 15
 5 2 2 2 4 3 2 4;}
 #yiv0052539947 p.yiv0052539947MsoNormal, #yiv0052539947
 li.yiv0052539947MsoNormal, #yiv0052539947
 #yiv0052539947 a:link, #yiv0052539947
 #yiv0052539947 a:visited, #yiv0052539947
 #yiv0052539947 pre
 #yiv0052539947 span.yiv0052539947HTMLPreformattedChar
 #yiv0052539947 .yiv0052539947MsoChpDefault
  _filtered #yiv0052539947 {margin:72.0pt 72.0pt 72.0pt
 #yiv0052539947 div.yiv0052539947WordSection1
 #yiv0052539947 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
 Sent: 17 May 2017
 To: ksubramanian@xxxxxxxxxxxxxxx;
 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 
 list: https://launchpad.net/~maria-discussPost
 to     : maria-discuss@lists.launchpad.netUnsubscribe
 : https://launchpad.net/~maria-discussMore
 help   : https://help.launchpad.net/ListHelp
 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