I can see that you solved the problem. Too bad the actual feature is not implemented in the official package.
I would really hate going from MySql to MsSql, but it seems like an option. On Nov 22, 1:09 pm, eti <[email protected]> wrote: > Hi, > > I guess the problem is that mysql .net connector does not support > distributed transactions. I had a similar problem trying to use > nservicebus with transactional msmq and nhibernate. > > I've described my conclusions > herehttp://www.erata.net/net/nservicebus-with-nhibernate-and-mysql/ > > Hope it helps > eti > > On 11/20/2010 21:19, Jason Dentler wrote: > > > > > > > > > I'm not a MySQL guy. I'm pretty confident, when done properly, > > TransactionScope works with MySQL simply because I haven't seen anyone > > post here that it doesn't. > > > using (var ts = new TransactionScope()) > > { > > // Do some RavenDB work here maybe > > // Open the session & transaction inside the TransactionScope > > using (var session = sessionFactory.OpenSession()) > > { > > using (var tx = session.BeginTransaction()) > > { > > // Do all your NH / MySQL work here > > tx.Commit(); > > } > > } > > // You can also do some RavenDB work here > > // Notice that this is *after* the session has been disposed. > > ts.Complete(); > > } > > > On Sat, Nov 20, 2010 at 7:40 AM, Jacob Madsen <[email protected] > > <mailto:[email protected]>> wrote: > > > Hi all, > > > I have a customer where the system is running on Amazon Web Services. > > They already have a running system with NH and MySql. TransactionScope > > is not used, since NH transactions is enough to do the job. > > > The MySql setup is tested, multiple machines and have great uptime. > > > Now they are trying out RavenDB for some reporting features. They want > > to use TransactionScope for transactions. > > > This is now an issue, since NH or the MySql client throw up with > > "Nested transactions are not supported", when BeginTransaction() is > > invoked on the ISession object. > > > Is it a complete no-go with MySql or can we do something to get > > TransactionScope working with NH transaction? > > > I read several times read on this list that NH transaction is needed > > for NH internals to work properly, so I don't wont to stop using it. > > > Cheer! > > > -- > > You received this message because you are subscribed to the Google > > Groups "nhusers" group. > > To post to this group, send email to [email protected] > > <mailto:[email protected]>. > > To unsubscribe from this group, send email to > > [email protected] > > <mailto:nhusers%[email protected]>. > > For more options, visit this group at > > http://groups.google.com/group/nhusers?hl=en. > > > -- > > You received this message because you are subscribed to the Google > > Groups "nhusers" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group at > >http://groups.google.com/group/nhusers?hl=en. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
