maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

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.

Cheers,
Federico



--------------------------------------------
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
 #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  
 #yiv0052539947 p.yiv0052539947MsoNormal, #yiv0052539947
 li.yiv0052539947MsoNormal, #yiv0052539947
 div.yiv0052539947MsoNormal
 	{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;color:windowtext;}
 #yiv0052539947 a:link, #yiv0052539947
 span.yiv0052539947MsoHyperlink
 	{color:blue;text-decoration:underline;}
 #yiv0052539947 a:visited, #yiv0052539947
 span.yiv0052539947MsoHyperlinkFollowed
 	{color:#954F72;text-decoration:underline;}
 #yiv0052539947 pre
 	{margin:0cm;margin-bottom:.0001pt;font-size:10.0pt;color:black;}
 #yiv0052539947 span.yiv0052539947HTMLPreformattedChar
 	{color:black;}
 #yiv0052539947 .yiv0052539947MsoChpDefault
 	{}
  _filtered #yiv0052539947 {margin:72.0pt 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
 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-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