Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Mutliple database commit using .net connector ?
Mutliple database commit using .net connector ? [message #3480] Sat, 30 August 2008 09:56 Go to next message
newtomysql is currently offline newtomysql
Messages: 30
Registered: February 2007
Member
Dear All,
I am currently using the .net connector. So I would like to run distributed transaction meaning that I need to commit multiple database at one gone. Can .net connector support distributed transaction? Thanks.
Report message to a moderator
Re: Mutliple database commit using .net connector ? [message #3496 is a reply to message #3480 ] Tue, 02 September 2008 01:33 Go to previous messageGo to next message
debug is currently offline debug
Messages: 132
Registered: March 2008
Senior Member
look here: http://forums.mysql.com/read.php?3,186077,186077
there is a reference to some bug related to distributed transactions

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting
Report message to a moderator
Re: Mutliple database commit using .net connector ? [message #3498 is a reply to message #3480 ] Tue, 02 September 2008 06:33 Go to previous message
newtomysql is currently offline newtomysql
Messages: 30
Registered: February 2007
Member
Dear Mikhail,
Yes I have seen this thing many places "Fixed problem where attempting to enlist in a distributed transaction would succeed even though Connector/Net doesn't currently support that. (Bug #31703) ". So what does it say actually ? Can I still use the transaction scope to implement the distributed transactions with .net connector? Now I am using 5.2.3? So I dont know whether it will work or not ? Do you have any link where I can do my reference? Thanks.
Report message to a moderator
Previous Topic:To change username
Next Topic:Benchmark tool for MySQL
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Thu Jul 9 22:15:24 EDT 2009

Total time taken to generate the page: 0.02989 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.